Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
GG error handling

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
Answers
-
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.
Regards,
Veera
-
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
-
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