The following errors are observed in compare log (*desvr* log) on source when compare fails:
032: DEBUG:colName=PREPAREDATE, column.number=23, column.type=12 (DATE), dsize=7, cform=0, csid=0
032: Status : Error
032: Error 1 inserting into SHAREPLEX_DATAEQUATOR table. (de_thrdmgr_sub_main,L1604)
032: Compare MTAS.MTAS_UI_REHOME_HISTORY to MTAS2ORA.MTAS_UI_REHOME_HISTORY failed. See error message above.
000: DEQ done reading.
000: Exiting........ (Wed Jul 27 19:59:24 2011)
The ora_setup utility has not been run when upgrading Shareplex from one version to another.
With every version of Shareplex there can be changes to the Shareplex internal tables in the database. Though this is not always the case, it is recommended that ora_setup be run after every upgrade from one version to a higher version. In our situation, the internal table SHAREPLEX_DATAEQUATOR is not updated for the current version in question so compare is failing. To resolve this, shutdown Shareplex on both source and target, re-run ora_setup, then start Shareplex and run another compare.
For details on running ora_setup, please refer to Shareplex Administrator Guide chapter titled “Administering the SharePlex Oracle account” section titled “Running ora_setup on UNIX systems”