Transformation fails on the target after table definitions are changed on the source
Columns have been added to the source table(s) and now transformation on the target fails with:
PLS-00103: Encountered the symbol ";" when expecting one of the following:..
Because DDL replication has been disabled for this Shareplex configuration, the object cache which Shareplex uses to store column information for the objects in replication has not been automatically updated with the new column names on the source. This means that Shareplex is not able to pass the column names as values for bind variables in the PL/SQL for transformation. Instead, Shareplex will pass an empty string.
Setting debug on the target POST process will cause the values passed to individual bind variables to be recorded in the log file for Post. The steps to set this debug are:
1. stop post 2. sp_ctrl> set param SP_OPO_DEBUG_FLAG 0x0f0001ff 3. start post
Once the error has occured the file $SP_SYS_VARDIR/log/*opo*.log will contain a list of the bind variables and values similar to: