View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003790 | SymmetricDS | Bug | public | 2018-11-09 17:27 | 2018-11-19 18:20 |
Reporter | achintya.de@uk.daiwacm.com | Assigned To | |||
Priority | high | ||||
Status | closed | Resolution | no change required | ||
Product Version | 3.9.14 | ||||
Summary | 0003790: FK violation between sym_channel and sym_trigger | ||||
Description | i've now managed to get the SQL server node working but the trouble is im getting a FK constraint failure for channel id following this for a "Quick Start" http://www.symmetricds.org/doc/3.9/html/tutorials.html#_configure Section 2.3 Configure in the corp / master node the sym_channel table has the following channel_id config reload monitor heartbeat default dynamic but the insert statement is using the channel_id as 'item' -- Trigger INSERT INTO sym_trigger ( trigger_id, source_table_name, channel_id, last_update_time, create_time ) VALUES ( 'item', 'item', 'item', getdate(), getdate() ) and keep failing please advise thanks | ||||
Tags | No tags attached. | ||||
|
If you want to use a channel id of "item" for your particular trigger, you'll need to create a channel called "item" in sym_channel. |
|
hi Hanes, as i can see you've picked up my other case (0003794) , please resolve this one I've put notes in the other call thanks achintya |
Date Modified | Username | Field | Change |
---|---|---|---|
2018-11-09 17:27 | achintya.de@uk.daiwacm.com | New Issue | |
2018-11-16 12:59 | hanes | Assigned To | => hanes |
2018-11-16 12:59 | hanes | Status | new => feedback |
2018-11-16 12:59 | hanes | Note Added: 0001335 | |
2018-11-16 13:08 | achintya.de@uk.daiwacm.com | Note Added: 0001337 | |
2018-11-16 13:08 | achintya.de@uk.daiwacm.com | Status | feedback => assigned |
2018-11-19 18:20 | hanes | Assigned To | hanes => |
2018-11-19 18:20 | hanes | Status | assigned => closed |
2018-11-19 18:20 | hanes | Resolution | open => no change required |