Out of sync due to ORA-01722 being generated on Target.
Database default language is not set to US7ASCII.
NOTE: Implement the resolution even if the same character set is set on both sides and/or if environment NLS_LANG set to the appropriate value.
1. Set NLS_LANG=AMERICAN_AMERICA.character_set_name in environment before starting sp_cop if database character set is not US7ASCII.
2. If the error is still encountered, then set these parameters on the Source and Target.
- Shutdown SharePlex.
- On the Target, sp_ctrl> set param SP_OPO_NLS_LANG <SID_A>,<character set>
- On the Source, sp_ctrl> set param SP_ORD_NLS_LANG <SID_A>,<character set>
- Start SharePlex.
Refer to the SharePlex Reference Guide for more information on these two parameters.
