Compare fails withOracle Error 1406
Source event_log:
Error 2011-10-09 13:46:49.443745 1114820 258 Compare server: Oracle Error 1406: ORA-01406: fetched column value was truncated. [sp_desvr] [module deq]
compare desvr-log:
001: Oracle Error 1406: ORA-01406: fetched column value was truncated
001: Error 1406 calling OCIStmtFetch in de_select_fetch_rows (1678)
001: Error 1406 calling de_select_fetch_rows in de_batch_setup
001: DEBUG: delete from SHAREPLEX_DATAEQUATOR where session_id = 1114820 and source_schema = 'OWNER' and source_table = 'TABLE_NAME' (de_splextab_delete_row,L499)
001: Status : Error
001: Error 1 calling de_batch_setup in sp_desvr's main
Cause1. Columns in the table have security policy, and Shareplex schema user doesnt have privileges to access it.
Cause 2. Software bug when running compare on vertical partitioned table
Resolution1:
- Grant privileges to Shareplex schema owner.
- Rerun compare
Resolution2:
Contact Technical Support
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy