I'm using SymmetricDS to replicate a table structure (DDL), and I ran the following sequence of commands to sync the triggers and send the table schema:
bin\symadmin.bat -e rada-000 --node=001 sync-triggers
bin\symadmin.bat -e rada-000 --node=001 send-schema TABLE
After replicating the DDL, the new field in the table appears correctly in the target database. However, when I insert data into this table, the content of the new field is not being replicated to the target node. The other data in the table is replicated without issues.
I have verified that:
Question: What might be preventing the replication of the data in the new field? Is there any additional procedure I should follow after DDL replication to ensure that the data in the new fields is properly replicated?
Environment:
Here is the command you should run on node 000: bin\symadmin.bat -e rada-000 sync-triggers
If this is not detecting the change in the table you can use :bin\symadmin.bat -e rada-000 sync-triggers -f
to force it to rebuild the trigger.
It should automatically sync triggers on the target node when it detects a schema change is loaded. There was a bug related to this issue that was fixed in 3.15.8 https://issues.symmetricds.org/view.php?id=6526