Backlog of data in the TotalAgility Reporting Staging database
Question / Problem:
Is it possible to determine if there is a backlog of reporting data to be processed in the TotalAgility_Reporting_Staging database?
Answer / Solution:
KTA components, such as the webserver, Core Worker, or Transformation Server, write compressed reporting data directly to the wsa_messages table of the TotalAgility_Reporting_Staging database. Then it is up to the Kofax TotalAgility Reporting Service to process and consolidate this raw reporting data into the form that ends up in the TotalAgility_Reporting database.
If the Kofax TotalAgility Reporting Service is not running, or if there is a technical problem keeping it from processing, then raw reporting data will build up in the form of an increasing number of records in the wsa_messages table of the TotalAgility_Reporting_Staging database.
If the service was simply stopped, restart it to continue processing. If a technical issue is preventing further processing, then it might be useful to quantify the amount of backlogged data as part of troubleshooting. Run the following diagnostic query on the TotalAgility_Reporting_Staging database to show the number of records along with the dates of the earliest and latest records.
SELECT COUNT(*) AS WsaMessages, MIN(enqueued_time) AS Earliest, MAX(enqueued_time) as Latest FROM wsa_messages
On an OPMT system run the following query on a specific tenant database to get information from both the live and dev environments:
SELECT 'live' AS Environment, COUNT(*) AS WsaMessages, MIN(enqueued_time) AS Earliest, MAX(enqueued_time) as Latest FROM reportingstaginglive.wsa_messages UNION ALL SELECT 'dev' AS Environment, COUNT(*) AS WsaMessages, MIN(enqueued_time) AS Earliest, MAX(enqueued_time) as Latest FROM reportingstagingdev.wsa_messages