11 Replies Latest reply on Aug 8, 2019 5:27 AM by Robeen

    ORA-00001 ORA-00902

    Robeen

      Oracle Database 12.2.0

      RHEL 7.4

       

      Hello Team,

       

      Replication for table CBSOGG.CB_SUBS_OFFER_DETAILS is in sync(same number of rows on source and target).

       

      I noticed a warning in ggserr.log.

       

      Will this affect the data content?

       

      2019-07-30T14:32:02.989+0400  INFO    OGG-01738  Oracle GoldenGate Capture for Oracle, extdwh.prm:  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p25576_extr: start=SeqNo: 45209, RBA: 1132709904, SCN: 60.3931985277 (261630023037), Timestamp: 2019-07-30 11:05:29.000000, end=SeqNo: 45229, RBA: 321071128, SCN: 60.3940021057 (261638058817), Timestamp: 2019-07-30 14:31:49.000000, Thread: 1.

      2019-07-30T14:45:10.682+0400  WARNING OGG-02544  Oracle GoldenGate Delivery for Oracle, reploggt.prm:  Unhandled error (ORA-00902: invalid datatype

                                    ORA-00001: unique constraint (.) violated

                                    ORA-00001: unique constraint (CBSOGG.CB_SUBS_OFFER_DTL$1) violated) while processing the record at SEQNO 110, RBA 491195569 in Integrated mode. REPLICAT will retry in Direct mode.

       

      Regards,

       

      Joe

        • 1. Re: ORA-00001 ORA-00902
          ORASCN

          Hi Joe,

           

          Is your replicat process is abending?

           

          The replicat process tried to apply the record and it didn't succeed. So, it is trying to apply it in Direct Mode. There is no problem until your replicat gets abend. But this should be looked and rectified.

           

          Regards,

          Veera

          • 2. Re: ORA-00001 ORA-00902
            Robeen

            Hi Veera,

             

            the replicat did not abend,

             

            It is fine then.

             

            Regards,

             

            Joe

            • 3. Re: ORA-00001 ORA-00902
              Robeen

              Hi Veera,

               

              Now I noticed the replicat being abended

               

              2019-08-01T14:16:15.423+0400  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, reploggt.prm:  SQL error 1 mapping CBS_CORE.CB_SUBS_OFFER_DETAILS to CBSOGG.CB_SUBS_OFFER_DETAILS OCI Error ORA-00001: unique constraint (CBSOGG.CB_SUBS_OFFER_DTL$1) violated (status = 1), SQL <UPDATE "CBSOGG"."CB_SUBS_OFFER_DETAILS" x SET x."ACCOUNT_LINK_CODE_N" = :a27,x."OFFER_CODE_V" = :a28,x."START_DATE_D" = :a29,x."END_DATE_D" = :a30,x."CANCEL_DATE_D" = :a31,x."USER_CODE_N" = :a32,x."STATUS_OPTN_V" = :a33,x."REQUESTED_DATE_D" = :a34,x."SCHEME_REF_CODE_N" = :a35,x."FACILITY_REF_ID_V" = :a36,x."NARRATION_V" = :a37,x."TARIFF_FLAG_V" = :a38,x."MOVE_CHARGE_TO_ACC_V" = :a39,x."ORDER_REF_NO" = :a40,x."ADDNL_OFFER_FLG_V" = :a41,x."EXTENDED_COUNT_N" = :a42,x."EXTENSION_DATE_D" = :a43,x."LAST_EXTENDED_DATE_D" = :a44,x."QUANTITY_N" = :a45,x."LAST_MODIFIED_DATE_D" = :a46,x."ADDN_ATTR_V_1" = :a47,x."ADDN_ATTR_V_2" = :a48,x."TECH_ATRIBUTE_V" = :a49,x."EXPIRY_DATE_D" = :a50,x."SERIAL_NUM_V" = :a51,x."AUTO_RENEW_V" = :a52,x."CONTRACT_END_DT_D" = :a53 WHERE x."ACCOUNT_LINK_CODE_N" = :b0 AND x."OFFER_CODE_V" = :b1 AND x."FACILITY_REF_ID_V" is NULL AND ROWNUM = 1>.

              2019-08-01T14:16:15.423+0400  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, reploggt.prm:  Error mapping from CBS_CORE.CB_SUBS_OFFER_DETAILS to CBSOGG.CB_SUBS_OFFER_DETAILS.

              2019-08-01T14:16:21.777+0400  INFO    OGG-02333  Oracle GoldenGate Delivery for Oracle, reploggt.prm:  Reading /u01/app/oracle/OGG/dirdat/cd000000120, current RBA 97,295,300, 5 records, m_file_seqno = 120, m_file_rba = 97,296,522.

              • 4. Re: ORA-00001 ORA-00902
                Robeen

                MAP CBS_CORE.CB_SUBS_OFFER_DETAILS,TARGET CBSOGG.CB_SUBS_OFFER_DETAILS,KEYCOLS(ACCOUNT_LINK_CODE_N,FACILITY_REF_ID_V,OFFER_CODE_V);

                • 5. Re: ORA-00001 ORA-00902
                  ORASCN

                  Hi Joe,

                   

                  Now, open the Discard File and go to the end of the file. You will see the latest error record in there with Error, Column names and Column values. Please ping me the whole error record. Or, upload the discard file.

                   

                  This will be located in the dirrpt directory. The file with extension .dsc

                   

                  Regards,

                  Veera

                  • 6. Re: ORA-00001 ORA-00902
                    Robeen

                    Hi Veera,

                     

                    thanks for the update.

                     

                    content of the discard file is shown below

                     

                    [oracle@RH-DATWHSE-DEV dirrpt]$ cat REPLOGGT9.dsc

                    Oracle GoldenGate Delivery for Oracle process started, group REPLOGGT discard file opened: 2019-08-01 12:32:02.170639

                    Current time: 2019-08-01 12:32:05

                    Discarded record from action ABEND on error 1

                     

                     

                    OCI Error ORA-00001: unique constraint (CBSOGG.CB_SUBS_OFFER_DTL$1) violated (status = 1), SQL <UPDATE "CBSOGG"."CB_SUBS_OFFER_DETAILS" x SET x."ACCOUNT_LINK_CODE_N" = :a27,x."OFFER_CODE_V" = :a28,x."START_DATE_D" = :a29,x."END_DATE_D" = :a30,x."CANCEL_DATE_D" = :a31,x."USER_CODE_N" = :a32,x."STATUS_OPTN_V" = :a33,x."REQUESTED_DATE_D" = :a34,x."SCHEME_REF_CODE_N" = :a35,x."FACILITY_REF_ID_V" = :a36,x."NARRATION_V" = :a37,x."TARIFF_FLAG_V" = :a38,x."MOVE_CHARGE_TO_ACC_V" = :a39,x."ORDER_REF_NO" = :a40,x."ADDNL_OFFER_FLG_V" = :a41,x."EXTENDED_COUNT_N" = :a42,x."EXTENSION_DATE_D" = :a43,x."LAST_EXTENDED_DATE_D" = :a44,x."QUANTITY_N" = :a45,x."LAST_MODIFIED_DATE_D" = :a46,x."ADDN_ATTR_V_1" = :a47,x."ADDN_ATTR_V_2" = :a48,x."TECH_ATRIBUTE_V" = :a49,x."EXPIRY_DATE_D" = :a50,x."SERIAL_NUM_V" = :a51,x."AUTO_RENEW_V" = :a52,x."CONTRACT_END_DT_D" = :a53 WHERE x."ACCOUNT_LINK_CODE_N" = :b0 AND x."OFFER_CODE_V" = :b1 AND x."FACILITY_REF_ID_V" is NULL AND ROWNUM = 1>

                    Aborting transaction on /u01/app/oracle/OGG/dirdat/cd beginning at seqno 120 rba 97,289,146

                                            error at seqno 120 rba 97295300

                    Problem replicating CBS_CORE.CB_SUBS_OFFER_DETAILS to CBSOGG.CB_SUBS_OFFER_DETAILS.

                    Mapping problem with unified PK update record (target format) SCN:256.34.109244...

                    *

                    ACCOUNT_LINK_CODE_N = 23373594

                    000000: 32 33 33 37 33 35 39 34                        |23373594        |

                     

                     

                    OFFER_CODE_V = O141923

                    000000: 4f 31 34 31 39 32 33                            |O141923        |

                     

                     

                    START_DATE_D = 2018-12-27 08:55:59.571603000 +04:00

                    000000: 32 30 31 38 2d 31 32 2d 32 37 20 30 38 3a 35 35 |2018-12-27 08:55|

                    000010: 3a 35 39 2e 35 37 31 36 30 33 30 30 30 20 2b 30 |:59.571603000 +0|

                    000020: 34 3a 30 30                                    |4:00            |

                     

                     

                    END_DATE_D = 2019-07-16 09:51:55.502415000 +04:00

                    000000: 32 30 31 39 2d 30 37 2d 31 36 20 30 39 3a 35 31 |2019-07-16 09:51|

                    000010: 3a 35 35 2e 35 30 32 34 31 35 30 30 30 20 2b 30 |:55.502415000 +0|

                    000020: 34 3a 30 30                                    |4:00            |

                     

                     

                    CANCEL_DATE_D = 2019-07-16 09:51:55.502415000 +04:00

                    000000: 32 30 31 39 2d 30 37 2d 31 36 20 30 39 3a 35 31 |2019-07-16 09:51|

                    000010: 3a 35 35 2e 35 30 32 34 31 35 30 30 30 20 2b 30 |:55.502415000 +0|

                    000020: 34 3a 30 30                                    |4:00            |

                     

                     

                    USER_CODE_N = 2463

                    000000: 32 34 36 33                                    |2463            |

                     

                     

                    STATUS_OPTN_V = V

                    000000: 56                                              |V              |

                     

                     

                    REQUESTED_DATE_D = 2018-12-27 08:55:59.571603000 +04:00

                    000000: 32 30 31 38 2d 31 32 2d 32 37 20 30 38 3a 35 35 |2018-12-27 08:55|

                    000010: 3a 35 39 2e 35 37 31 36 30 33 30 30 30 20 2b 30 |:59.571603000 +0|

                    000020: 34 3a 30 30                                    |4:00            |

                     

                     

                    SCHEME_REF_CODE_N = 141923

                    000000: 31 34 31 39 32 33                              |141923          |

                     

                     

                    FACILITY_REF_ID_V = NULL

                    NARRATION_V = NULL

                    TARIFF_FLAG_V = N

                    000000: 4e                                              |N              |

                     

                     

                    MOVE_CHARGE_TO_ACC_V = NULL

                    ORDER_REF_NO = 18373231

                    000000: 31 38 33 37 33 32 33 31                        |18373231        |

                     

                     

                    ADDNL_OFFER_FLG_V = NULL

                    EXTENDED_COUNT_N = NULL

                    EXTENSION_DATE_D = NULL

                    LAST_EXTENDED_DATE_D = NULL

                    QUANTITY_N = 1

                    000000: 31                                              |1              |

                     

                     

                    LAST_MODIFIED_DATE_D = 2018-12-27 08:55:59.571603000 +04:00

                    000000: 32 30 31 38 2d 31 32 2d 32 37 20 30 38 3a 35 35 |2018-12-27 08:55|

                    000010: 3a 35 39 2e 35 37 31 36 30 33 30 30 30 20 2b 30 |:59.571603000 +0|

                    000020: 34 3a 30 30                                    |4:00            |

                     

                     

                    ADDN_ATTR_V_1 = NULL

                    ADDN_ATTR_V_2 = NULL

                    TECH_ATRIBUTE_V = NULL

                    EXPIRY_DATE_D = NULL

                    SERIAL_NUM_V = NULL

                    AUTO_RENEW_V = NULL

                    CONTRACT_END_DT_D = NULL

                    ACCOUNT_LINK_CODE_N = 23373594

                    000000: 32 33 33 37 33 35 39 34                        |23373594        |

                     

                     

                    OFFER_CODE_V = O141923

                    000000: 4f 31 34 31 39 32 33                            |O141923        |

                     

                     

                    START_DATE_D = 2018-12-27 08:55:59.571603000 +04:00

                    000000: 32 30 31 38 2d 31 32 2d 32 37 20 30 38 3a 35 35 |2018-12-27 08:55|

                    000010: 3a 35 39 2e 35 37 31 36 30 33 30 30 30 20 2b 30 |:59.571603000 +0|

                    000020: 34 3a 30 30                                    |4:00            |

                     

                     

                    END_DATE_D = 2019-07-16 09:51:55.502415000 +04:00

                    000000: 32 30 31 39 2d 30 37 2d 31 36 20 30 39 3a 35 31 |2019-07-16 09:51|

                    000010: 3a 35 35 2e 35 30 32 34 31 35 30 30 30 20 2b 30 |:55.502415000 +0|

                    000020: 34 3a 30 30                                    |4:00            |

                     

                     

                    CANCEL_DATE_D = 2019-07-16 09:51:55.502415000 +04:00

                    000000: 32 30 31 39 2d 30 37 2d 31 36 20 30 39 3a 35 31 |2019-07-16 09:51|

                    000010: 3a 35 35 2e 35 30 32 34 31 35 30 30 30 20 2b 30 |:55.502415000 +0|

                    000020: 34 3a 30 30                                    |4:00            |

                     

                     

                    USER_CODE_N = 2463

                    000000: 32 34 36 33                                    |2463            |

                     

                     

                    STATUS_OPTN_V = V

                    000000: 56                                              |V              |

                     

                     

                    REQUESTED_DATE_D = 2018-12-27 08:55:59.571603000 +04:00

                    000000: 32 30 31 38 2d 31 32 2d 32 37 20 30 38 3a 35 35 |2018-12-27 08:55|

                    000010: 3a 35 39 2e 35 37 31 36 30 33 30 30 30 20 2b 30 |:59.571603000 +0|

                    000020: 34 3a 30 30                                    |4:00            |

                     

                     

                    SCHEME_REF_CODE_N = 141923

                    000000: 31 34 31 39 32 33                              |141923          |

                     

                     

                    FACILITY_REF_ID_V = NULL

                    NARRATION_V = NULL

                    TARIFF_FLAG_V = N

                    000000: 4e                                              |N              |

                     

                     

                    MOVE_CHARGE_TO_ACC_V = NULL

                    ORDER_REF_NO = 18373231

                    000000: 31 38 33 37 33 32 33 31                        |18373231        |

                     

                     

                    ADDNL_OFFER_FLG_V = NULL

                    EXTENDED_COUNT_N = NULL

                    EXTENSION_DATE_D = NULL

                    LAST_EXTENDED_DATE_D = NULL

                    QUANTITY_N = 1

                    000000: 31                                              |1              |

                     

                     

                    LAST_MODIFIED_DATE_D = 2018-12-27 08:55:59.571603000 +04:00

                    000000: 32 30 31 38 2d 31 32 2d 32 37 20 30 38 3a 35 35 |2018-12-27 08:55|

                    000010: 3a 35 39 2e 35 37 31 36 30 33 30 30 30 20 2b 30 |:59.571603000 +0|

                    000020: 34 3a 30 30                                    |4:00            |

                     

                     

                    ADDN_ATTR_V_1 = NULL

                    ADDN_ATTR_V_2 = NULL

                    TECH_ATRIBUTE_V = NULL

                    EXPIRY_DATE_D = NULL

                    SERIAL_NUM_V = NULL

                    AUTO_RENEW_V = NULL

                    CONTRACT_END_DT_D = NULL

                    *

                     

                     

                    Process Abending : 2019-08-01 12:32:10

                     

                    Regards,

                     

                    Joe

                    • 7. Re: ORA-00001 ORA-00902
                      ORASCN

                      Hi Joe,

                       

                      Does the table CBSOGG"."CB_SUBS_OFFER_DETAILS" has PK or UI?

                       

                      The below error is because of the UPDATE and not because of the INSERT.

                       

                      Problem replicating CBS_CORE.CB_SUBS_OFFER_DETAILS to CBSOGG.CB_SUBS_OFFER_DETAILS.

                      Mapping problem with unified PK update record (target format) SCN:256.34.109244...

                       

                      Can you please share the replicat process parameter file? Also, please do a select in the source and target,

                       

                      select * from CBSOGG.CB_SUBS_OFFER_DETAILS

                      where ACCOUNT_LINK_CODE_N = 23373594

                      and OFFER_CODE_V = 'O141923'

                      and USER_CODE_N = 2463

                      and STATUS_OPTN_V = 'V'

                      SCHEME_REF_CODE_N = 141923

                      /

                       

                      Regards,

                      Veera

                      • 8. Re: ORA-00001 ORA-00902
                        Robeen

                        Hi,

                         

                        target:

                         

                        source:

                         

                        It has neither primary key nor unique key.

                         

                        replicat parameter file:

                         

                        REPLICAT REPLOGGT

                        ASSUMETARGETDEFS

                        DDLOPTIONS REPORT

                        USERIDALIAS oraggext

                        ddl include mapped

                        --INSERTMISSINGUPDATES

                        MAP CBS_CORE.CB_SUBS_OFFER_DETAILS,TARGET CBSOGG.CB_SUBS_OFFER_DETAILS,KEYCOLS(ACCOUNT_LINK_CODE_N,FACILITY_REF_ID_V,OFFER_CODE_V);

                        MAP CBS_CORE.GG,TARGET CBSOGG.GG;

                        --MAP CLM_TT.WF_WORKFLOW,TARGET CBSOGG.WF_WORKFLOW,FILTER ( @GETENV ('TRANSACTION', 'CSN') >259489337519);

                        MAP CLM_TT.TT_TICKETINFO,TARGET CBSOGG.TT_TICKETINFO;

                        MAP CBS_CORE.CB_ADDRESS_XML, TARGET CBSOGG.CB_ADDRESS_XML;

                        MAP CLM_TT.WF_WORKFLOW,TARGET CBSOGG.WF_WORKFLOW;

                        MAP CLM_TT.TT_TICKETINCIDENT,TARGET CBSOGG.TT_TICKETINCIDENT;

                        MAP CBS_CORE.CB_SUB_AR_AP,TARGET CBSOGG.CB_SUB_AR_AP;

                        MAP CLM_TT.TT_TICKET_ADDNL_INFO,TARGET CBSOGG.TT_TICKET_ADDNL_INFO,keycols(DOCKET_NUMBER_N);

                        MAP CBS_CORE.CB_INVOICE_DETAILS,TARGET CBSOGG.CB_INVOICE_DETAILS;

                        MAP CBS_CORE.CB_SUB_INVOICE,TARGET CBSOGG.CB_SUB_INVOICE;

                        MAP CBS_CORE.CB_ACCOUNT_RECEIVE_PAY,TARGET CBSOGG.CB_ACCOUNT_RECEIVE_PAY;

                        MAP CBS_CORE.CB_RECEIPTS,TARGET CBSOGG.CB_RECEIPTS;

                        MAP CBS_CORE.CB_INVOICE,TARGET CBSOGG.CB_INVOICE;

                        MAP CBS_CORE.CB_PAY_MODE_DTLS,TARGET CBSOGG.CB_PAY_MODE_DTLS;

                        MAP CBS_CUST.CB_POS_TRANS_DTLS,TARGET CBSOGG.CB_POS_TRANS_DTLS;

                        MAP CBS_CUST.CB_POS_TRANSACTIONS,TARGET CBSOGG.CB_POS_TRANSACTIONS;

                        MAP CBS_CORE.CB_RECEIPTS_ADJUST,TARGET CBSOGG.CB_RECEIPTS_ADJUST ;

                        MAP CBS_CORE.fxl_cycle_summary_details,TARGET CBSOGG.fxl_cycle_summary_details;

                        MAP CBS_CORE.GSM_SERVICE_MAST,TARGET CBSOGG.GSM_SERVICE_MAST ;

                        MAP CBS_CORE.CB_SUBS_REFUND,TARGET CBSOGG.CB_SUBS_REFUND ;

                        MAP CBS_CORE.CB_ACCS_RECEIVE_PAY_ADJUST,TARGET CBSOGG.CB_ACCS_RECEIVE_PAY_ADJUST  ;

                        MAP CBS_CORE.CB_ACCOUNT_MASTER,TARGET CBSOGG.CB_ACCOUNT_MASTER ;

                        MAP CBS_CORE.CB_ACCOUNT_SERVICE_LIST,TARGET CBSOGG.CB_ACCOUNT_SERVICE_LIST  ;

                        MAP CBS_CORE.CB_SUBS_POS_SERVICES,target cbsogg.CB_SUBS_POS_SERVICES;

                        MAP CBS_CORE.CB_SUBSCRIBER_MASTER,target cbsogg.CB_SUBSCRIBER_MASTER;

                        MAP CBS_CORE.CB_CR_DB_NOTES,target cbsogg.CB_CR_DB_NOTES;

                        MAP CLM_TT.WF_WORKASSIGNMENT_HISTORY,TARGET CBSOGG.WF_WORKASSIGNMENT_HISTORY;

                        MAP CLM_TT.CB_FAULT_TYPES,TARGET CBSOGG.CB_FAULT_TYPES;

                        MAP CLM_TT.WF_WORKASSIGNMENT,TARGET CBSOGG.WF_WORKASSIGNMENT;

                        MAP CLM_TT.WF_TODOITEM,TARGET CBSOGG.WF_TODOITEM;

                        MAP CLM_TT.WF_TODOITEM_HISTORY,TARGET CBSOGG.WF_TODOITEM_HISTORY;

                        MAP CLM_TT.TT_CATEGORY_MASTER,TARGET CBSOGG.TT_CATEGORY_MASTER;

                        MAP CBS_CORE.WF_USERGROUP,TARGET CBSOGG.WF_USERGROUP ;

                        MAP CBS_CORE.CB_USERS,TARGET CBSOGG.CB_USERS ;

                        MAP CBS_CORE.CB_SUB_SERVICES,TARGET CBSOGG.CB_SUB_SERVICES ;

                        MAP CBS_CORE.CB_BANK_MASTER,TARGET CBSOGG.CB_BANK_MASTER ;

                        MAP CBS_CORE.CB_POS_SERVICES,TARGET CBSOGG.CB_POS_SERVICES  ;

                        MAP CBS_CORE.CB_WORK_ORDER_PRODUCT_DTLS,TARGET CBSOGG.CB_WORK_ORDER_PRODUCT_DTLS  ;

                        MAP CBS_CORE.CB_REASON_MASTER,TARGET CBSOGG.CB_REASON_MASTER  ;

                        MAP CBS_CORE.CB_POS_SERVICES_PARAMS,TARGET CBSOGG.CB_POS_SERVICES_PARAMS  ;

                        MAP CBS_CORE.CB_SUBS_PAID_ADV_DTLS,TARGET CBSOGG.CB_SUBS_PAID_ADV_DTLS ;

                        MAP CBS_CORE.CB_SUBSCRIBER_SUB_CATEGORY,TARGET CBSOGG.CB_SUBSCRIBER_SUB_CATEGORY ;

                        MAP CBS_CORE.CB_SUBSCRIBER_CATEGORY,TARGET CBSOGG.CB_SUBSCRIBER_CATEGORY ;

                        MAP CBS_CORE.CB_RETAIL_OUTLETS,TARGET CBSOGG.CB_RETAIL_OUTLETS ;

                        MAP CBS_CORE.CB_ADVANCE_RENTAL,TARGET CBSOGG.CB_ADVANCE_RENTAL ;

                        MAP CBS_CORE.CB_PACKAGE,TARGET CBSOGG.CB_PACKAGE ;

                        MAP CBS_CORE.CB_OFFERS,TARGET CBSOGG.CB_OFFERS ;

                        MAP CBS_CORE.CB_DEALER_MASTER,TARGET CBSOGG.CB_DEALER_MASTER ;

                        MAP CBS_CORE.CB_ARTICLE_GROUPS,TARGET CBSOGG.CB_ARTICLE_GROUPS ;

                        MAP CBS_CORE.CB_ARTICLES,TARGET CBSOGG.CB_ARTICLES ;

                        MAP CBS_CORE.PS_ACTION,TARGET CBSOGG.PS_ACTION ;

                        MAP CBS_CORE.CB_STATUS_MASTER,TARGET CBSOGG.CB_STATUS_MASTER ;

                        MAP CBS_CORE.CB_SERVICES,TARGET CBSOGG.CB_SERVICES ;

                        MAP CBS_CORE.CB_PAYMENT_METHODS,TARGET CBSOGG.CB_PAYMENT_METHODS ;

                        MAP CBS_CORE.CB_SCHEME_REFERENCE,TARGET CBSOGG.CB_SCHEME_REFERENCE ;

                        MAP CBS_CORE.CB_CANCEL_RECEIPTS,TARGET CBSOGG.CB_CANCEL_RECEIPTS ;

                        MAP CBS_CORE.FXL_SERVICE_MAST,TARGET CBSOGG.FXL_SERVICE_MAST ;

                        MAP CBS_CORE.CB_SUBS_PROVISIONING,TARGET CBSOGG.CB_SUBS_PROVISIONING;

                        MAP CBS_CORE.cb_order_request_dtls,TARGET CBSOGG.cb_order_request_dtls;

                        MAP CBS_CORE.cb_work_order,TARGET CBSOGG.cb_work_order;

                        MAP CBS_CORE.INV_ITEM_MASTER,TARGET CBSOGG.INV_ITEM_MASTER;

                        MAP CBS_CORE.WF_WRKFLWMGR,CBSOGG.WF_WRKFLWMGR;

                         

                        Thanks,

                         

                        Joe

                        • 9. Re: ORA-00001 ORA-00902
                          ORASCN

                          Hi Joe,

                           

                          Is the same KEYCOLS below used in the source as well?

                           

                          MAP CBS_CORE.CB_SUBS_OFFER_DETAILS,TARGET CBSOGG.CB_SUBS_OFFER_DETAILS,KEYCOLS(ACCOUNT_LINK_CODE_N,FACILITY_REF_ID_V,OFFER_CODE_V);

                           

                          Please provide the CREATE TABLE ddl from both source and target.

                           

                          In the Target, open the trail file sequence 120 using the Logdump utility, and execute the below command,

                           

                          OS >./logdump

                          Logdump >open trail file seq# with full path /u01/app/oracle/OGG/dirdat/cd000000120

                          Logdump >ghdr on

                          Logdump >detail data on

                          Logdump >ggstoken detail

                          Logdump >usertoken detail

                          Logdump >pos 97295300

                          Logdump >n

                          Logdump >n

                           

                          Provide the output.

                           

                          Regards,

                          Veera

                          • 10. Re: ORA-00001 ORA-00902
                            ORASCN

                            Also, try to create Classic Replicat or downgrade this Integrated Replicat to Classic. Use the parameter

                             

                            DBOPTIONS SUPPRESSTRIGGERS

                             

                            And then position the Classic replicat to the problematic seq# and RBA. Start the Classic Replicat process. Check if that is moving?

                             

                            Do you have any triggers in the Target database?

                             

                            Regards,

                            Veera

                            • 11. Re: ORA-00001 ORA-00902
                              Robeen

                              Hi Veera,

                               

                              no, I will not be using triggers on the target.

                               

                              I did an import from source again and till now it is fine. In case the error occurs again I will provide the logdump output.

                               

                              Regards,

                               

                              Joe