|
|
OGG 18.0
DB: 12.2.0
RHEL 7.4
Hi Erman,
when I added 2 new tables for replication, I am getting error shown below
ed to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-06-21T01:52:33.195+0400 INFO OGG-02756 Oracle GoldenGate Delivery for Oracle, reploggt.prm: The definition for table CLM_TT.TT_TICKET_ADDNL_INFO is obtained from the trail file.
2019-06-21T01:52:33.195+0400 INFO OGG-06511 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Using following columns in default map by name: DOCKET_NUMBER_N, FAQ_V, SEND_SMS_V, MISTAKE_V, FEEDBACK_V, COMMENTS_V, CONTACT_CHECK_V, CONTACT_CALL_CHECK_V, LINES_MEN_FLAG_V, LINES_MEN_CODE_N, LINES_MEN_ALLOC_DATE_D, REF_DOCKET_NUMBER_V, COVERAGE_ENTRY_FLAG_V, GOVERNATE_V, AREA_V, STREET_V, TEXT1_V, TEXT2_V, TEXT3_V, LINES_MEN_DTLS_N, SMS_LANG_V, FAULT_CODE_V, REMINDER_D, REMINDER_FLAG_V.
2019-06-21T01:52:33.195+0400 INFO OGG-01298 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Column function diagnostic message: could not find column "TRANSACTION".
2019-06-21T01:52:33.197+0400 ERROR OGG-00375 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Error in FILTER clause.
2019-06-21T01:52:38.405+0400 INFO OGG-02333 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Reading /u01/app/oracle/OGG/dirdat/cd000000036, current RBA 9,483, 1 records, m_file_seqno = 36, m_file_rba = 9,828.
2019-06-21T01:52:38.411+0400 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, reploggt.prm: PROCESS ABENDING.
My extract parameter file for the 2 new tables is shown below
MAP CLM_TT.TT_TICKET_ADDNL_INFO,TARGET CBSOGG.TT_TICKET_ADDNL_INFO,FILTER ( @GETENV ("TRANSACTION", "CSN") > 257932251918);
MAP CLM_TT.cb_fault_types,TARGET CBSOGG.cb_fault_types,FILTER ( @GETENV ("TRANSACTION", "CSN") > 257932251918);
Can I start the replicat without the filters?
Pls advise,
Roshan
|
Locked
