Compare fails withOracle Error 1406
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]
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
- Grant privileges to Shareplex schema owner.
- Rerun compare
Contact Technical Support