When documents remain in a "pending" status ("ORDP", "LODP", "QRYP", et cetera), but you know that the SEDI communications subsystem is working (see "How can I tell if Secure EDI [SEDI] is working?" FAQ), the problem is likely to be due to index corruption in the Export-It database. The application uses the database indices to find the EDI document for which a reply is received. But if an index is bad it cannot locate the RFP, EDN or PRA (or their associated line items) to apply the response. Leaving the status of the document, which couldn't be located, unchanged.
The solution is to re-index the Export-It database. Such a re-index must be performed when there are no Export-It or Export-It Plus modules open on any workstation at the site. That is because re-indexing requires exclusive control of all of the database tables to succeed. So get everyone to close all Syscob application windows, including SEDI_exp, on all PCs before attempting the database repair.
When no one is running any module open the Maintenance module on any workstation. Select "Re-Index ALL Export-It Data Files" from the "Maintenance" menu. This should open a small panel with two buttons for the two steps in the process. First, press the button for step 1. It will open a file selection window. Press the "Select All" button on the right near the top and then press the "Sort" button at the bottom of the window. That should open a small window in the upper left corner where database table names scroll in the upper pane while indices needed for step 2 are created. When completed it should show "No errors during sort operation" in the lower pane. At that point close the various windows until the panel with the two buttons is again visible.
Now press the button to run step 2. In the window that opens press the "Begin" button at the bottom. This process will now check the integrity of the records in the database looking for duplicate records, "orphan" records (child records with no parent), invalid key values, et cetera. When any anomolous record is identified it is deleted and the analysis begins again. Because of this the progress bar can "jump back" to an earlier point. But when the process completes the last line of the bottom pane will show the number of problems "fixed" in step 2. If it says that zero fixes were done then the re-index process is complete. Just close all of the windows and arrange for any missed replies to be resent from AQIS, Customs, 1-Stop, et cetera. They should now be properly handled upon receipt.
However, if any "fixes" were performed by step 2 it means that records, which were present when step 1 created an index, have been deleted (meaning that index is now invalid). So when more than zero "fixes" were made by step 2 it is necessary to close the various windows until the panel with the two buttons is again visible. Then run step 1 again! That will create indices that reflect the "fixed" database contents. After this indexing operation completes the system is again ready to use and received EDI messages will properly apply to the database. But it will still be necessary to have the sending agencies resend any replies that were missed due to the bad index situation.
In one special case, AQIS remote certificate print files, the agency may not be willing to retransmit the file (due to the risk of fraud by printing more than one copy of a certificate). In such a case please contact Syscob Support for assistance in recovering the "lost" certificate print files.