RKO

Thank you , it worked after putting channel_id as NULL

Hi, I am using SymmetricsDs version 3.12 to sync between mysql and oracle db . the data sync is not having any issue however when I try to reload a new table( existing in both source and destination with same name), it does not happen. I am not getting an error and also I donot see the data loaded in the source sym_data table . I use the following insert into SYM_TABLE_RELOAD_REQUEST (target_node_id, source_node_id, trigger_id, router_id,channel_id,processed,create_time, last_update_time) values...

Thank you , it worked after changing the schema mappings

Hi, I have SymmtricDs 3.12 replication setup from mysql to oracle. The replication is working fine between the 2 databases. However the table transform is not working. Following, is the configuration of the transform. Please let me know what is missing. Thanks The error I see in the logs is -> unable to insert NULL in SRC_SYSTEM_ID column. This is a not null column in Target and does not exist in Source. Insert into SYMMETRIC.SYM_TRANSFORM_TABLE (TRANSFORM_ID, SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID,...

Hi, I am SymmtricDs 3.12 replication setup from mysql to oracle. The replication is working fine between the databases. However the table transform is not working. Following, is the configuration of the transform. Please let me know what is missing. Thanks The error I see in the logs is that unable to insert NULL in SRC_SYSTEM_ID column. This is a nut null column in Target and does not exist in Source. Insert into SYMMETRIC.SYM_TRANSFORM_TABLE (TRANSFORM_ID, SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID,...

Hi We have SymmetricDs software version 3.12.9 installed for replication between database nodes. sym_channel is configured with multiple channels and dedicated queues for each channel for each database node However, we see that pushservice is randomly using the queues and even queues assigned to other nodes. please let me know if any configuration is missing Eg sym_channel node 1 : node1-channel ,node1-queue node2 : node2-channel,node2 -queue sym_trigger node1-table1 using node1-channel node2-table2...

Thank you , I was able to add multiple appenders in the log4j2.xml . But was not able to use a filter for specific engine . I tried filters from the below list http://logging.apache.org/log4j/2.x/manual/filters.html Could you suggest? Thanks

Hi We have SymmetricDS 3.9 installation where the replication is setup as below Source Node 1 -----------replicating few tables --------> Target Node 1 Target Node 1-------------replicating all tables -----------> Target node 2 The replication on the first one is working fine. While replication from target node 1 to target node 2 is not working. I see the batches are captured in sym_outgoing_batch, but node_id is set to -1 on that table. This is for config, heartbeat and all other custom channel...