PASI Errors

To figure out that PASI queues have stuck messages for ATL Receivables run the following script on the PASI database located on 10.32.5.190 server:

SELECT 'SENDING QUEUE' AS QUEUE_NAME, COUNT(MessageID) AS NUMBER_OF_MESSAGES
FROM SendingQueue WITH(NOLOCK)
WHERE Recepient = 'ATL ARI' AND PATINDEX('%<MessageType>ACK</MessageType>%',Data) = 0

If the value in the NUMBER_OF_MESSAGES column is greater than 0 then perform the following steps:

1. Login on PA-COL-ARI server (10.32.5.160) using Remote Desktop Control.
2. Press Win + R and enter services.msc in the Run window, hit Enter.
3. Find PPMSI Processor service in the services list.
4. Right click on PPMSI Processor service. Click Stop context menu item. Wait till the service is stopped.
5. Find PPMSI Service service in the services list.
6. Right click on PPMSI Service service. Click Restart context menu item.Wait till the service is restarted.
7. Right click on PPMSI Processor service. Click Start context menu item. Wait till the service is started.