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]
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center