How To Trace data changes through the system

Use these steps to troubleshoot capture and delivery of data changes via SymmetricDS.

1. Ensure the change was captured by querying the SYM_DATA table:

   SELECT * FROM SYM_DATA WHERE table_name='your_data_table';

2. Check if this change was routed into a SymmetricDS batch:

   SELECT * FROM SYM_DATA_EVENT WHERE data_id=data_id_from_step_1;

3. Check if batch was processed (review the status column):

   SELECT * FROM SYM_OUTGOING_BATCH WHERE batch_id=batch_id_from_step_2;

4. Common values for batch status:
   NE = New batch is ready to send
   SE = Batch is being transferred
   LD = Batch is being loaded at the target
   OK = Batch processing was completed
   ER = Error detected! Review this further - search logs for this batch number or open a ticket with the SymmetricDS PRO support team (licensed PRO customers only).