Return
-
Title
Compare config fails when using upper and lower case SID combination for Source and Target -
Description
Replication works fine but Compare config OR compare with complete Target routing information fails when using the upper and lower case SID combination on Source and Target.This only happens when using the same SID name on both sides with different case.Example:sp_ctrl (XXXXX:8497)> view config 4.confdatasource:o.ora11gr2#source tables target tables routing mapscott.test_interval_part scott.test_interval_part Target_server@o.ORA11GR2scott.test1 scott.test1 10.112.23.154@o.ORA11GR2sp_ctrl (XXXXX:8497)> compare using 4.confCannot compare "SCOTT"."TEST_INTERVAL_PART"Invalid specification scott.test_interval_part scott.test_interval_part Target_server@o.ORA11GR2Table "SCOTT"."TEST_INTERVAL_PART" is in replication, but not to target specifiedSpecify correct target or use the force option to compareCannot compare "SCOTT"."TEST1"Invalid specification scott.test1 scott.test1 Target_server_IP@o.ORA11GR2Table "SCOTT"."TEST1" is in replication, but not to target specifiedSpecify correct target or use the force option to compareChanging the Target routing to lower case SID works.sp_ctrl (XXXXX:8497)> view config 5.confdatasource:o.ora11gr2#source tables target tables routing mapscott.test_interval_part scott.test_interval_part Target_server@o.ora11gr2scott.test1 scott.test1 Target_server_IP@o.ora11gr2sp_ctrl (XXXXX:8497)> compare using 5.confcomparing 2 of 2 objectscompare started; job id 6sp_ctrl (XXXXX:8497)> -
Cause
Product issue but will only effect replications with Source and Target that has the same SID with a different case. -
Resolution
No fix as of SharePlex version 8.6.5 but as a workaround, create a dummy config with the list of tables that need to be compared and change the target SID to lower case.