View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003185 | SymmetricDS | Bug | public | 2017-07-04 06:40 | 2018-10-17 19:24 |
Reporter | sunil.mali | Assigned To | |||
Priority | urgent | ||||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 3.8.9 | ||||
Summary | 0003185: Some of the tables are not getting sync | ||||
Description | We 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. | ||||
Tags | No tags attached. | ||||
|
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 ? |
|
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. |
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 |