Troubleshooting tracking data transfer issue from Process Server Database to Performance Data Warehouse Database

Process Applications deployed on process server periodically sent (every 30 seconds) tracking data to performance DB

Stated below is the list of SQL Statements that you can make use to troubleshoot issues or to enable custom monitoring

Tracking data is sent from Process Server DB to PDW DB

Things can be verified at Process Server DB

1. Are there any records waiting to get transferred from BPMDB to PDWDB? Get a row count of LSW_PERF_DATA_TRANSFER table SELECT count(*) FROM LSW_PERF_DATA_TRANSFER Row count shows the no of records waiting to get transferred to PDW DB if < 500 rows, then data is most likely transferring, if not find why  data is not moving Also remember data transfer interval with respect to count As per the design -- the data transfer happens every 30 seconds if the number of records to be transferred is less than 500. If the records are greater than 500 -- then the data transfer continuously happens until all the records are transferred

Things can be verified at Performance Data Warehouse Server DB

1. Are there any data transfer errors at PDWDB? Get a row count of LSW_DATA_TRANSFER_ERRORS table SELECT count(*) FROM LSW_DATA_TRANSFER_ERRORS Row count shows the no of transfers failed due to error Most common errors can be seen at LSW_DATA_TRANSFER_ERRORS table (PFS-0065) The tracking group with external ID <BPD_ID> is not defined. When tracking definitions were sent for process application which has auto tracking disabled, PFS-0065 is written to data transfer error table. Remember auto tracking enablement with respect to BPM version BPM versions v7.5, v8.0, v8.5 - auto tracking enabled by default BPM v8.5.5 onwards auto tracking was disabled by default

2. Whether sending tracking definitions worked or not? Run the SQL statement at PDWDB to identify whether tracking definitions sent successfully or not SELECT TIME_RECEIVED, TIME_LOADED FROM LSW_LOAD_TRACE where LOAD_TYPE = 1 AND STATUS = 6 Output will show the time stamp tracking definitions were received at PDWDB