Oracle Goldengate: REPERROR (1403, IGNORE) , Add trandata schema.*

-
I ran into some issue with goldengate where it's not taking any of the update statement, they are all sent directly to ignore

when we ran view param we see this statement, basically this is handling all the issue with update and send update statement to ignore count when the process thinks it cannot handle the update statement.

REPERROR (1403, IGNORE)

I then commented that line and restarted the replicat process. Upon starting the process, I encountered the following


2019-08-01 12:33:45  WARNING OGG-01004  Aborted grouped transaction on AVL_RPT_FOD.ALERT_MTS_SALT, Database error 1403 (OCI Error ORA-01403: no data found, SQL <UPDATE "AVL_RPT_FOD"."ALERT_MTS_SALT" x SET x."STATUS_ID" = :a9,x."FACILITY_TYPE_ID" = :a10,x."START_DATE" = :a11,x."END_DATE" = :a12,x."WEB_MERCATOR_X" = :a13,x."WEB_MERCATOR_Y" = :a14,x."FACILITY_NAME" = :a15 WHERE x."ID" = :b0>).

2019-08-01 12:33:45  WARNING OGG-01003  Repositioning to rba 245869009 in seqno 1233.

2019-08-01 12:33:45  WARNING OGG-01154  SQL error 1403 mapping AVL_FOD_SDE.ALERT_MTS_SALT to AVL_RPT_FOD.ALERT_MTS_SALT OCI Error ORA-01403: no data found, SQL <UPDATE "AVL_RPT_FOD"."ALERT_MTS_SALT" x SET x."STATUS_ID" = :a9,x."FACILITY_TYPE_ID" = :a10,x."START_DATE" = :a11,x."END_DATE" = :a12,x."WEB_MERCATOR_X" = :a13,x."WEB_MERCATOR_Y" = :a14,x."FACILITY_NAME" = :a15 WHERE x."ID" = :b0>.

2019-08-01 12:33:45  ERROR   OGG-01296  Error mapping from AVL_FOD_SDE.ALERT_MTS_SALT to AVL_RPT_FOD.ALERT_MTS_SALT.

I can run the statement manually with no issue


After taking some time looking into the issue, this is how I fixed it.

Since there are multiple tables in the processes. I ran

Add trandata AVL_FOD_SDE.*

Soon after this command ran, we see the update count started going up.



Comments

Post a Comment

Popular posts from this blog

MongoDB Tips: Kill long running processes

-
This is just a quick and simple script to find all active opid that has been running over 10 seconds and they are running against the databases and collections you can specify in the "ns" filter. It's best to first run db.currentOp(    {      "active" : true,      "secs_running" : { "$gt" : 10 },      "ns" : {$in:["equipment.detachment","personnel.detail","personnel.unavailability","personnel.detachment"]}    } ).inprog.forEach(function (doc) { print(doc.opid); }) and verify your output before you execute the kill command in my experience to make sure you are killing the processes that are meant to be killed. Once verifed, simply run: db.currentOp(    {      "active" : true,      "secs_running" : { "$gt" : 10 },      "ns" : {$in:["<db1>.<col1>","<db2>.<col2>","<dbn>.<coln>...
Read more

Oracle Goldengate Extract, Pump, and Replicat

-
This is just a quick demonstration of setting up extract, pump, and replicate. I prefer to edit the prm files at OS level, but we can also do GGSCI> edit param esource to enter the vi mode to create the prm file. Here are the sample prm files used in the demonstration: prm files: -------------------------------- Source: (2 processes) ~~~~~~~~~~~~~~~~ esource.prm ~~~~~~~~~ EXTRACT ESOURCE SETENV (ORACLE_SID=source) SETENV (ORACLE_HOME="/source/app/oracle/product/11.2.0.3") userid ggg, password ggg EXTTRAIL /ggSource/app/goldengate/product/12.1.0/dirdat/es --Resolves the TABLES to be replicated when they first encounter a dml operation WILDCARDRESOLVE DYNAMIC --Reduce the system I/O overhead of redolog reads EOFDELAY 5 TABLE mine.table; psource.prm ~~~~~~~~~ EXTRACT PDWDSPRD SETENV (ORACLE_SID=source) SETENV (ORACLE_HOME="/source/app/oracle/product/11.2.0.3") userid ggg, password ggg RMTHOST targetServer.example.net, MGRPO...
Read more

MongoDB Ops Manager Basic Installation and Configuration

-
Image
This post is just a quick guide of MongoDB Ops Manager basic installation and configuration. The bare minimum of getting an instance of MongoDB Ops Manager up and running. We will be working with the latest version of the OpsManager, release version 3.4.7. Prerequisite: To start fresh, we remove any mongodb related RPM. I had Mongod installed as well, therefore, I have extras to be removed. [root@msdlva-dsnops01 ~]# yum autoremove $(rpm -qva | grep mongo) Loaded plugins: langpacks, product-id, rhnplugin, search-disabled-repos, subscription-manager This system is receiving updates from RHN Classic or Red Hat Satellite. Resolving Dependencies --> Running transaction check ---> Package mongodb-enterprise.x86_64 0:3.4.6-1.el7 will be erased ---> Package mongodb-enterprise-mongos.x86_64 0:3.4.6-1.el7 will be erased ---> Package mongodb-enterprise-server.x86_64 0:3.4.6-1.el7 will be erased ---> Package mongodb-enterprise-shell.x86_64 0:3.4.6-1.el7 will be erased...
Read more