OGG-00918

[Roshan]

Oracle DB 12.1.0.2

Solaris 18.1



Hello Erman,



we are getting error below during replication of GoldenGate. I noticed some fields were added in the exceptions table. How is this possible?



Kindly guide me.



MACRO #exception_handler

BEGIN

TARGET BIREPORT.GGS_EXCEPTIONS

,COLMAP(

excp_date = @DATENOW(), &

rep_name = @GETENV ('GGENVIRONMENT', 'GROUPNAME'), &

table_name = @GETENV ('GGHEADER', 'TABLENAME'), &

errno = @GETENV ('LASTERR', 'DBERRNUM'), &

errtype = @GETENV ('LASTERR', 'ERRTYPE'), &

optype = @GETENV ('LASTERR', 'OPTYPE'), &

transind = @GETENV ('GGHEADER', 'TRANSACTIONINDICATOR'), &

transimgind = @GETENV ('GGHEADER', 'BEFOREAFTERINDICATOR'), &

committimestamp = @GETENV ('GGHEADER', 'COMMITTIMESTAMP'), &

reccsn = @GETENV ('TRANSACTION', 'CSN'), &

recseqno = @GETENV ('RECORD', 'FILESEQNO'), &

recrba = @GETENV ('RECORD', 'FILERBA'), &

rectranspos = @GETENV ('RECORD', 'RSN'), &

reclength = @GETENV ('GGHEADAER', 'RECORDLENGTH'), &

logrba = @GETENV ('GGHEADER', 'LOGRBA'), &

logposition = @GETENV ('GGHEADER', 'LOGPOSITION'), &

grouptype = @GETENV ('GGENVIRONMENT', 'GROUPTYPE'), &

filename = @GETENV ('GGFILEHEADER', 'FILENAME'), &

fileno = @GETENV ('GGFILEHEADER', 'FILESEQNO'), &

srcrowid = @GETENV ('TRANSACTION', 'CSN'), &

srcdbcharset = @GETENV ('GGFILEHEADER', 'DBCHARSET'), &

replag = @GETENV ('LAG', 'SEC'), &

cnt_cdr_conflicts = @GETENV ('DELTASTATS','TABLE', @GETENV ('GGHEADER', 'TABLENAME'),'CDR_CONFLICTS'), &

cnt_cdr_resolutions = @GETENV ('DELTASTATS','TABLE', @GETENV ('GGHEADER', 'TABLENAME'),'CDR_RESOLUTIONS_SUCCEEDED'), &

cnt_cdr_failed = @GETENV ('DELTASTATS','TABLE', @GETENV ('GGHEADER', 'TABLENAME'),'CDR_RESOLUTIONS_FAILED'))

EXCEPTIONSONLY,

INSERTALLRECORDS

;

END;





REPORT file:



2020-12-11 01:26:49 INFO  OGG-06506 Wildcard MAP resolved (entry CBS_CORE.*): MAP "CBS_CORE"."CB_USERS" TARGET BIREPORT.GGS_EXCEPTIONS ,COLMAP( excp_date = @DATENOW(), rep_name = @GETENV ('GGENVIRONMENT', 'GROUPNAME'), table_name = @GETENV ('GGHEADER', 'TABLENAME'), errno = @GETENV ('LASTERR', 'DBERRNUM'), errtype = @GETENV ('LASTERR', 'ERRTYPE'), optype = @GETENV ('LASTERR', 'OPTYPE'), transind = @GETENV ('GGHEADER', 'TRANSACTIONINDICATOR'), transimgind = @GETENV ('GGHEADER', 'BEFOREAFTERINDICATOR'), committimestamp = @GETENV ('GGHEADER', 'COMMITTIMESTAMP'), reccsn = @GETENV ('TRANSACTION', 'CSN'), recseqno = @GETENV ('RECORD', 'FILESEQNO'), recrba = @GETENV ('RECORD', 'FILERBA'), rectranspos = @GETENV ('RECORD', 'RSN'), reclength = @GETENV ('GGHEADAER', 'RECORDLENGTH'), logrba = @GETENV ('GGHEADER', 'LOGRBA'), logposition = @GETENV ('GGHEADER', 'LOGPOSITION'), grouptype = @GETENV ('GGENVIRONMENT', 'GROUPTYPE'), filename = @GETENV ('GGFILEHEADER', 'FILENAME'), fileno = @GETENV ('GGFILEHEADER', 'FILESEQNO'), srcrowid = @GETENV ('TRANSACTION', 'CSN'), srcdbcharset = @GETENV ('GGFILEHEADER', 'DBCHARSET'), replag = @GETENV ('LAG', 'SEC'), cnt_cdr_conflicts = @GETENV ('DELTASTATS','TABLE', @GETENV ('GGHEADER', 'TABLENAME'),'CDR_CONFLICTS'), cnt_cdr_resolutions = @GETENV ('DELTASTATS','TABLE', @GETENV ('GGHEADER', 'TABLENAME'),'CDR_RESOLUTIONS_SUCCEEDED'), cnt_cdr_failed = @GETENV ('DELTASTATS','TABLE', @GETENV ('GGHEADER', 'TABLENAME'),'CDR_RESOLUTIONS_FAILED')) EXCEPTIONSONLY, INSERTALLRECORDS.



2020-12-11 01:26:49 WARNING OGG-06439 No unique key is defined for table GGS_EXCEPTIONS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

The following target columns were not mapped:

 DUMMY_ENTITY_ID_N



Source Context :

 SourceModule      : [er.mapping]

 SourceID        : [/scratch/jkrath/view_storage/jkrath_ogg1810rc4vw/oggcore/OpenSys/src/app/er/mapping.cpp]

 SourceMethod      : [get_map_entry]

 SourceLine       : [3468]



2020-12-11 01:26:49 ERROR  OGG-00918 Key column DUMMY_ENTITY_ID_N is missing from map.



***********************************************************************

*          ** Run Time Statistics **             *

***********************************************************************





2020-12-11 01:26:54 INFO  OGG-02333 Reading /ogg/ora12c/dirdat/cd000006797, current RBA 359,111,322, 0 records, m_file_seqno = 6,797, m_file_rba = 359,111,502.



EXCEPTIONS table:

GGS_EXCEPTIONS table with extra fields:

EXCP_DATE TIMESTAMP(6)

REP_NAME VARCHAR2(10 BYTE)

TABLE_NAME VARCHAR2(56 BYTE)

ERRNO NUMBER

ERRTYPE VARCHAR2(6 BYTE)

OPTYPE VARCHAR2(24 BYTE)

TRANSIND VARCHAR2(12 BYTE)

TRANSIMGIND VARCHAR2(8 BYTE)

COMMITTIMESTAMP VARCHAR2(26 BYTE)

RECCSN NUMBER

RECSEQNO NUMBER

RECRBA NUMBER

RECTRANSPOS NUMBER

RECLENGTH NUMBER

LOGRBA NUMBER

LOGPOSITION NUMBER

GROUPTYPE VARCHAR2(12 BYTE)

FILENAME VARCHAR2(50 BYTE)

FILENO NUMBER

SRCROWID VARCHAR2(40 BYTE)

SRCDBCHARSET VARCHAR2(40 BYTE)

REPLAG NUMBER

CNT_CDR_CONFLICTS NUMBER

CNT_CDR_RESOLUTIONS NUMBER

CNT_CDR_FAILED NUMBER

RANDOM_ACCOUNT_UPLOAD_V CLOB <----------

INVOICES_C CLOB <---------------------

TRANS_NUM_V VARCHAR2(20 BYTE) <----------------

REFUND_TYPE_V VARCHAR2(1 BYTE) <---------------



Thanks,



Roshan

[ErmanArslansOracleBlog]

I think you ask , how can I see rows replicated in the tables where Goldengate reports a warning..

Well, if no PK or unique key is defined in the table, OGG constructs a pseudo key of all columns.

Check this note -> https://www.ateam-oracle.com/oracle-goldengate-tables-without-keys