Guide as to when to use SQL queries 0 to 5
0 Store Processing Status SQL
This is a summary of the other 5 queries, checking regxml, servxml, commxml and out tables.
You will use this query when the store calls up and says they are unable to do end of day or start of day and they say they have already done start of day that means the documents for it has not come through on the system.
You will then use this query to:
-check there is no hold up with processing for start of day or end of day for example.
-on closing stores to be sure all data has been sent to HO
-big people counting volume of data clogging the system
1 Reg XML status SQL
You run it when you want to see what documents are not processed by the server this is represented with the letter A or when some are processed with errors represented by the letter E
You will then use this query to check there is no hold up with processing for start of day or end of day for example.
2 Serv XML status SQL
You would run this if the info from the store is not going into the odmbs database and as a result the database is not showing the latest up to date information in the database.
3 Out Status SQL
You would run this to see what documents are not sent to other systems like HO or other lanes pcs
4 Server not updating error reg xml sql
You run this query to see if the server has updated the database with the processed documents from the store. Not processed represented by the letter A or with errors represented by the letter E
5 Commxmlstatus sql
This query you would run to determine whether the processed documents have been sent out by the comm server either not processed which is represented by the letter or whether some are processed with errors represented by the letter E