Thanks so much. That's a big help! The triggers are creating now. Had already previously set the source_catalog_name, but hadn't set the source_schema_name. Now just need to figure out why the changes to the sym_trigger table that I made on the master node, weren't sync'ed to the other node. Had to manually update the sym_trigger table on the other node. But at least we've resolved the CREATE TRIGGER errors now.
Hi Our SymmetricDS installation keeps on getting the following error (for all source database tables that we want to replicate): "The object 'mydb.msg_00' does not exist or is invalid for this operation." This is when SymmetricDS is trying to create triggers on source database tables. The source database tables are in a SQL Server 2012 database. Portion of symmetric.log: 2017-10-19 15:15:44,842 INFO [mynode-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Done initializing SymmetricDS...
Hi Our SymmetricDS installation keeps on getting the following error (for all source database tables that we want to replicate): "The object 'mydb.msg_00' does not exist or is invalid for this operation." This is when SymmetricDS is trying to create triggers on source database tables. The source database tables are in a SQL Server 2012 database. Portion of symmetric.log: 2017-10-19 15:15:44,842 INFO [mynode-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Done initializing SymmetricDS...
Hi Our SymmetricDS installation keeps on getting the following error (for all source database tables that we want to replicate): "The object 'mydb.msg_00' does not exist or is invalid for this operation." This is when SymmetricDS is trying to create triggers on source database tables. The source database tables are in a SQL Server 2012 database. Portion of symmetric.log: 2017-10-19 15:15:44,842 INFO [mynode-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Done initializing SymmetricDS...
Hi Our SymmetricDS installation keeps on getting the following error (for all source database tables that we want to replicate): "The object 'mydb.msg_00' does not exist or is invalid for this operation." This is when SymmetricDS is trying to create triggers on source database tables. The source database tables are in a SQL Server 2012 database. Portion of symmetric.log: 2017-10-19 15:15:44,842 INFO [mynode-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Done initializing SymmetricDS...