GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Golden Gate replication errors

RobeenJun 30 2019 — edited Jul 5 2019

Oracle Database 12.1.0.2(source)

Oracle Database 12.2.0 (target)

RHEL 7.4

Hello Team,

I am getting the 3 errors below whenever I am replicating tables:

2019-06-30T12:14:58.456+0400 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, reploggt.prm: SQL error 1403 mapping CBS_CORE.CB_ADDRESS_XML to CBSOGG.CB_ADDRESS_XML OCI Error ORA-01403: no data found, SQL <UPDATE "CBSOGG"."CB_ADDRESS_XML" x SET x."ADDRESS_X" = sys.xmltype.createxml(:a6,null,1,1) WHERE x."ACCOUNT_LINK_CODE_N" = :b0 AND x."ADDRESS_TYPE_N" = :b1 AND x."ACCOUNT_TYPE_V" = :b2 AND ROWNUM = 1>.

2019-06-30T12:14:58.456+0400 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Error mapping from CBS_CORE.CB_ADDRESS_XML to CBSOGG.CB_ADDRESS_XML.

2019-06-30T12:15:04.857+0400 INFO OGG-02333 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Reading /u01/app/oracle/OGG/dirdat/cd000000050, current RBA 427,790,486, 15 records, m_file_seqno = 50, m_file_rba = 427,791,045.

2019-06-30T12:15:04.931+0400 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, reploggt.prm: PROCESS ABENDING.

2019-06-30T12:16:53.121+0400 INFO OGG-06510 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Using the following key columns for target table CBSOGG.WF_WORKASSIGNMENT: WORK_ID_N, USER_GROUP_OPTN_V, USER_GROUP_ID_N, ASSIGNED_BY_N.

2019-06-30T12:16:55.161+0400 WARNING OGG-02544 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Unhandled error (ORA-04098: trigger '.' is invalid and failed re-validation

ORA-04098: trigger 'CBSOGG.UPDT_USER_RIGHTS_TRG' is invalid and failed re-validation) while processing the record at SEQNO 50, RBA 427933197 in Integrated mode. REPLICAT will retry in Direct mode.

2019-06-30T12:16:55.195+0400 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Aborted grouped transaction on CBSOGG.CB_USERS, Database error 4098 (OCI Error ORA-04098: trigger 'CBSOGG.UPDT_USER_RIGHTS_TRG' is invalid and failed re-validation (status = 4098), SQL <UPDATE "CBSOGG"."CB_USERS" x SET x."LOCATION_CODE_V" = :a6,x."NO_OF_INVALID_ATTEMPTS_N" = :a7,x."LAST_LOGIN_DATE_D" = :a8,x."LOCATION_CODE_N" = :a9 WHERE x."USER_CODE_N" = :b0>).

2019-06-30T12:16:55.195+0400 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Repositioning to rba 427933197 in seqno 50.

2019-06-30T12:16:55.195+0400 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, reploggt.prm: SQL error 4098 mapping CBS_CORE.CB_USERS to CBSOGG.CB_USERS OCI Error ORA-04098: trigger 'CBSOGG.UPDT_USER_RIGHTS_TRG' is invalid and failed re-validation (status = 4098), SQL <UPDATE "CBSOGG"."CB_USERS" x SET x."LOCATION_CODE_V" = :a6,x."NO_OF_INVALID_ATTEMPTS_N" = :a7,x."LAST_LOGIN_DATE_D" = :a8,x."LOCATION_CODE_N" = :a9 WHERE x."USER_CODE_N" = :b0>.

2019-06-30T12:16:55.195+0400 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Error mapping from CBS_CORE.CB_USERS to CBSOGG.CB_USERS.

2019-06-30T12:17:00.429+0400 INFO OGG-02333 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Reading /u01/app/oracle/OGG/dirdat/cd000000050, current RBA 427,933,197, 330 records, m_file_seqno = 50, m_file_rba = 427,933,511.

2019-06-30T12:17:00.439+0400 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, reploggt.prm: PROCESS ABENDING.

2019-06-30T12:34:19.464+0400 INFO OGG-06511 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Using following columns in default map by name: ACCOUNT_LINK_CODE_N, CR_TRANS_NUM_V, CR_SERIAL_NUM_N, CR_DATE_D, DB_TRANS_NUM_V, DB_SERIAL_NUM_N, DB_DATE_D, ADJUST_AMT_N, LAST_MODIFIED_DATE_D.

2019-06-30T12:34:19.464+0400 INFO OGG-06510 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Using the following key columns for target table CBSOGG.CB_ACCS_RECEIVE_PAY_ADJUST: ACCOUNT_LINK_CODE_N, CR_TRANS_NUM_V, CR_SERIAL_NUM_N, CR_DATE_D, DB_TRANS_NUM_V, DB_SERIAL_NUM_N, DB_DATE_D, ADJUST_AMT_N, LAST_MODIFIED_DATE_D.

2019-06-30T12:34:20.404+0400 WARNING OGG-02544 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Unhandled error (ORA-04098: trigger 'CBSOGG.WF_HISTORY_TRG' is invalid and failed re-validation) while processing the record at SEQNO 50, RBA 430094104 in Integrated mode. REPLICAT will retry in Direct mode.

2019-06-30T12:34:20.805+0400 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Aborted grouped transaction on CBSOGG.WF_WORKFLOW, Database error 4098 (OCI Error ORA-04098: trigger 'CBSOGG.WF_HISTORY_TRG' is invalid and failed re-validation (status = 4098), SQL <UPDATE /*+ CURSOR_SHARING_EXACT */ "CBSOGG"."WF_WORKFLOW" x SET x."WRKFLW_DATA_X" = updatexml(x."WRKFLW_DATA_X", '/WorkFlow/Activity[@activityStatus = "N"]/DependentParents[not(DependentActivity[@sequenceNumber])]/../@activityStatus', :1, 'xmlns:xd="http://xmlns.oracle.com/xdb/xdiff.xsd" ') WHERE x."WRKFLW_INSTANCE_ID_N" = :b0>).

2019-06-30T12:34:20.805+0400 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Repositioning to rba 430089864 in seqno 50.

2019-06-30T12:34:20.894+0400 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, reploggt.prm: SQL error 4098 mapping CLM_TT.WF_WORKFLOW to CBSOGG.WF_WORKFLOW OCI Error ORA-04098: trigger 'CBSOGG.WF_HISTORY_TRG' is invalid and failed re-validation (status = 4098), SQL <UPDATE /*+ CURSOR_SHARING_EXACT */ "CBSOGG"."WF_WORKFLOW" x SET x."WRKFLW_DATA_X" = updatexml(x."WRKFLW_DATA_X", '/WorkFlow/Activity[@activityStatus = "N"]/DependentParents[not(DependentActivity[@sequenceNumber])]/../@activityStatus', :1, 'xmlns:xd="http://xmlns.oracle.com/xdb/xdiff.xsd" ') WHERE x."WRKFLW_INSTANCE_ID_N" = :b0>.

2019-06-30T12:34:20.894+0400 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Error mapping from CLM_TT.WF_WORKFLOW to CBSOGG.WF_WORKFLOW.

2019-06-30T12:34:26.218+0400 INFO OGG-02333 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Reading /u01/app/oracle/OGG/dirdat/cd000000050, current RBA 430,094,104, 44 records, m_file_seqno = 50, m_file_rba = 430,094,778.

2019-06-30T12:34:26.228+0400 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, reploggt.prm: PROCESS ABENDING.

Error is gone whenever I am using reperror (4098,DISCARD) and reperror (1403,DISCARD) respectively. However, it is not a wise method since this can lead to data discrepencies.

Can anyone please advise on how to correct?

Thanks,

Joe

Added on Jun 30 2019

#goldengate

8 comments

2,128 views