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]
Workaround:
Ignore the duplicate record errors
1. Edit the vardir/data/postgresmsglist file
2. Add the error number, from this example error is 7
3. Add the error count number, since there is only one error (7) being ignored, the count is 1
Example:
1
7
4. Save the changes to the vardir/data/postgresmsglist file
5. Instruct open target post to ignore the error (7) in the postgresmsglist and start post
sp_ctrl > set param SP_OPX_CONT_ON_ERR 1
sp_ctrl> start post
