Golden Gate Replication across Oracle Database with PRPC7.1.7
I am in the process of installing Oracle GoldenGate replication across two ODA. The following is the configuration and version of the system
Database version: Oracle 12c
Schema type: Split
GG version: 12
When whe initiate the replication process we receive the following errors
Replicat 1 :
2015-08-31 10:59:23
WARNING OGG-01154 SQL error 1 mapping GNA_RULES.PR_SYSGEN_STATIC_CONTENT
to GNA_RULES.PR_SYSGEN_STATIC_CONTENT OCI Error ORA-00001: unique constraint
(GNA_RULES.PR_SYSGEN_STATIC_CONTENT_PK) violated (status = 1), SQL <INSERT
INTO "GNA_RULES"."PR_SYSGEN_STATIC_CONTENT"
("PXCOMMITDATETIME","PXCREATEDATETIME","PXCREATEOPNAME","PXCREATEOPERATOR","PXCREATESYSTEMID","PXINSNAME","PXOBJCLASS","PYAPPLICATIONNAME","PYBASEFILENAME","PYFILENAME","PYFILETYPE","PZCACHECONFIGID","PZPACKAGE","PZCLASS","PZINSKEY","PZPVSTREAM")
VALUES
(:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13,:a14,EMPTY_BLOB())
RETURNING "PZPVSTREAM" INTO :dl0>.
Replicat 2 :
2015-08-31 08:06:54
WARNING OGG-01154 SQL error 1403 mapping GNA_DATA.PR_LOG_REPORTSTATS to
GNA_DATA.PR_LOG_REPORTSTATS OCI Error ORA-01403: no data found, SQL <DELETE
FROM "GNA_DATA"."PR_LOG_REPORTSTATS" WHERE "PZINSKEY"
= :b0>.
Has anyone ever run across this problem or is using GG for replication on PRPC 7.1.7.
Pegasystems
US
Have you verified that it is even safe to use goldengate for the particular tables you are attempting to use it ?
In general, if the Pega software is going to update a table, and your goldengate also is updating the table, issues would be expected.
What is the business description for why goldengate is being used in your situation ?
/Eric