Direct Deposit Advice Slips are set up to be sent via Quick Send but they did not send.
A. First review the temp directory where the attachments are created to see if the process created the attachments or not.
1. Go to the Server Administration screen (Administration | Application Server | Server Administration) and view the Properties for the user that you are logged into SL as when you launch and run Application Server.
2. On the Properties window note the path listed for the Temporary Directory.
3. Navigate to this path in Windows Explorer and check to see if the attachments for these invoices that didn’t send exist as files in this directory. If they do exist, copy/cut to remove them from this directory and paste them in a different directory as a
backup. Scripts can be run in SQL Server Management Studio that will allow for these items to be reprocessed and the files recreated and resent the next time the quick send process is run.
B. Gather the request ID’s for each of the requests that did not send from the Quick Send Inquiry (21.200.00) screen as they will be included in the SQL statements used to reset the requests.
C. To investigate why the requests did not send, review the Application Server logs for any details relating to these requests. Go to Administration | Application Server | Application Server Log and look for anything pertaining to these requests. Depending upon the amount of content going through application server you may set the Display Request Log for = All or the specific user that you are logged into SL as when you launch and run Application Server. These request ID's that didn’t send should be referenced in the logs.
C. To investigate why the requests did not send, review the Application Server logs for any details relating to these requests. Go to Administration | Application Server | Application Server Log and look for anything pertaining to these requests. Depending upon the amount of content going through application server you may set the Display Request Log for = All or the specific user that you are logged into SL as when you launch and run Application Server. These request ID's that didn’t send should be referenced in the logs.
D. Requeue the Direct Deposit Advice Slip (02.635.00) Quick Send requests follow these steps:
***NOTE*** As a precaution, before proceeding, confirm you have recent and complete backup copies of the SL databases that you can restore if a problem occurs.
1. Run the following SQL statements against your SL system database in SQL Server Management Studio:
***NOTE*** As a precaution, before proceeding, confirm you have recent and complete backup copies of the SL databases that you can restore if a problem occurs.
1. Run the following SQL statements against your SL system database in SQL Server Management Studio:
update appsrvrequest set priority='3', status='1' where id='XXXX'
update asrdistlist set diststatus='0' where requestid='XXXX'
update asrdatabase set status='0' where id='XXXX
Note: Replace XXXX with the Application Server Request ID (The value found in the Request Nbr box in the Quick Send Inquiry (21.200.00) screen)