View Issue Details

IDProjectCategoryView StatusLast Update
0002336SymmetricDSImprovementpublic2019-08-26 12:45
Reportershunmugaraj Assigned Toelong  
Priorityurgent 
Status closedResolutionopen 
Product Version3.7.19 
Summary0002336: Data sync is not happening due to default AFTER INSERT trigger
DescriptionData sync between primary and backup node is not working because of a rule is created on user table saying on insert move the data to different table hence sync is not happening.

To get around this problem i need create BEFORE INSERT for all the user table, by default sym_trigger creates AFTER INSERT trigger.

Could you please help in creating BEFORE INSERT trigger?
Tagstrigger

Activities

elong

2019-04-23 18:40

developer   ~0001420

What database platform is this? Are you talking about an INSTEAD OF trigger that is performed to put data into a different table? Because a BEFORE trigger won't prevent the data from being inserted, like you described, unless it raises an exception, will roll back data anyway. Maybe you should be syncing the table where the final data will be.

We use an AFTER trigger to capture the data that will be committed. If we used a BEFORE trigger, we'd miss the data that is generated by triggers or the database, such as a generated identity on a primary key.

admin

2019-08-26 12:45

administrator   ~0001590

Auto closing all issues waiting for feedback after 4 months. We don't have enough information to take any action.

Issue History

Date Modified Username Field Change
2015-06-27 01:47 shunmugaraj New Issue
2019-04-23 18:40 elong Assigned To => elong
2019-04-23 18:40 elong Status new => feedback
2019-04-23 18:40 elong Note Added: 0001420
2019-04-23 18:41 elong Tag Attached: trigger
2019-08-26 12:45 admin Note Added: 0001590
2019-08-26 12:45 admin Status feedback => closed