Out of sync errors due to duplicate key values in target table after base load on Postgres database from Oracle database. The postgres Migration Tool Kit doesn't allow to select an SCN when it starts the migration so cannot reconcile the poster queue.
Example:
xpst 2018-02-09 12:39:00.612196 12135 2973910784 error_code=7 state=23505 msg=ERROR: duplicate key value violates unique constraint ""
Error 2018-02-09 11:13:49.679994 6808 4203042560 Poster: [SP-OPX01001] Errors on target table "schema"."table_name" at seqno/offset 845114/7904224. error=7 state=23505 msg=ERROR: duplicate key value violates unique constraint "name" Key (redemption_cart_id)=(47262353) already exists.; Error while executing the query. Please see event_log and open target log files for more details. See 'http://advice.shareplex.com/SP-OPX01001' for additional advice and support. (posting from o.ntpprod, queue orantp, to r.ntp) [module opx]
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center