View Issue Details

IDProjectCategoryView StatusLast Update
0003790SymmetricDSBugpublic2018-11-19 18:20
Reporterachintya.de@uk.daiwacm.com Assigned To 
Priorityhigh 
Status closedResolutionno change required 
Product Version3.9.14 
Summary0003790: FK violation between sym_channel and sym_trigger
Descriptioni'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
TagsNo tags attached.

Activities

hanes

2018-11-16 12:59

developer   ~0001335

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.

achintya.de@uk.daiwacm.com

2018-11-16 13:08

reporter   ~0001337

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

Issue History

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