View Issue Details

IDProjectCategoryView StatusLast Update
0003185SymmetricDSBugpublic2018-10-17 19:24
Reportersunil.mali Assigned To 
Priorityurgent 
Status closedResolutionunable to reproduce 
Product Version3.8.9 
Summary0003185: Some of the tables are not getting sync
DescriptionWe have some transactional tables which we sync from store to corp, out of which few tables are not getting sync. Those tables were syncing 6 days back and suddenly it stopped syncing. So i have a situation where few transactional tables are synced but other tables are not synced since last 6 days. What can be done to resync those tables and to avoid such situation.
TagsNo tags attached.

Activities

sunil.mali

2017-07-11 11:37

reporter   ~0001059

Corp to Store in working fine, but store to corp data sync not working. Only few tables are getting updated. Do we have some flags in properties which is creating the problem ?

elong

2017-07-19 16:19

developer   ~0001067

You'll need to troubleshoot to find where the problem is. Look in the log to see if the push job is running periodically. If you see it running and pushing data, like the heartbeat every 15 minutes, then push is working. Next, look in the sym_outgoing_batch table for batches with a status not OK. If there is a batch with status ER, then there should be a message in the log of what is in error. If all batches are OK, then you need to see if data is being captured in sym_data. Query sym_data where the table_name is equal to your table. If data is captured, then it could be a problem with routing. The log will show errors with routing. If there is no new data being captured, then the trigger is not installed on the table. Make sure you have configured a sym_trigger and sym_trigger_router. You can restart SymmetricDS and it will check that triggers are installed.

Issue History

Date Modified Username Field Change
2017-07-04 06:40 sunil.mali New Issue
2017-07-11 11:37 sunil.mali Note Added: 0001059
2017-07-19 16:19 elong Note Added: 0001067
2018-10-17 19:24 hanes Status new => closed
2018-10-17 19:24 hanes Resolution open => unable to reproduce