GG error handling

user10126973

HI All,

I am trying to implement whatever errors comes i want insert into error handling table before image and after image, ca you please share thoughts how to implement in GG

My GG version 19c

DB version 12.2

regards

DR

ORASCN

Hi,

You can use the exception table for this. Each and every error in OGG, will be reported in Exception.

Also, it will be recorded in Discard File.

https://docs.oracle.com/en/cloud/paas/goldengate-cloud/gwuad/handling-replicat-errors-dml-operations.html#GUID-876CB579-68D5-4BEB-81CB-3913F2F4FE51

Regards,

Veera

user10126973

Hi Veera

I am not the error record info into my exception handling tale , I just getting no data found

I am using this column DBERRMSG to capture error message full what we get report file

Please help me out how to get full record (problematic record into this Column DBERRMSG ?

DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG')

Regards,

DR

user10126973

HI Veera,

I am not getting complete error message into exception table I just getting no data found

I am using this column DBERRMSG to capture the error message

Please help me out how to get full record (problematic record into this Column DBERRMSG ?

DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG')

regards,

DR