-
Title
Error 1 calling de_msg_svr_preCompareGiveAnswer when running compare on a table -
Description
running compare (or repair) causes Error 1 calling de_msg_svr_preCompareGiveAnswer error message
-
Cause
Compare (or repair) errors out due to the referenced table does not exist on target. -
Resolution
Compare (or repair) is not designed to work when the target table does not exist. The following errors are received when attempting to run it on the source table with the target table non-existent:
001: Error 1 calling de_msg_svr_preCompareGiveAnswer (de_msg_svr_preCompareMessaging1,L330)
001: Unable to lock target table (de_thrdmgr_sub_main,L2219)
001: Status : Error
001: Compare OWNER.SOURCE_TABLE_NAME to OWNER.TARGET_TABLE_NAME failed. See error message above.
000: DEBUG:logoff from Oracle, pid 2910 (de_trans_ora_logoff,L1170)
000: Exiting........ (Wed Dec 2 02:16:47 2015)
To resolve the problem, create an empty table with the name OWNER.TARGET_TABLE_NAME (taken from example above) on target database and re-run compare (or repair).