Question
DR Setup - Gets unique contstraint violation error
We are in production since long time. Recently, we started setting up a multi data center DR environment and we are testing the new environment.
Data from primary environment is replicated to the newly set up environment.
When we try to create new work objects (a campaign in this case) in the new environment, we get unique constraint violation error as work objects with same ids created on our primary environment are replicated to the new environment.
com.pega.pegarules.pub.database.DuplicateKeyException: ORA-00001: unique constraint (PREPAY_DATA.MKT_VZW_PREPAID_WORK) violated
Need guidance on how to resolve this issue.
issue got resolved by replicating table pc_data_uniqueid as well.
Is there a documentation detailing requirements for setting up DR?
Is there a list of tables to be replicated for setting up DR?
Please advise.