IBM iSeries Extract Abends OGG-05500 Detected Database Metadata Mismatch When Reading Trail Files (Doc ID 1926684.1)

Last updated on JANUARY 25, 2017

Applies to:

Oracle GoldenGate - Version 11.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Replicating from IBM iSeries the extract will sometimes abend with the error -

Starting at 2014-08-18 06:30:07

Operating system character set identified as ISO-8859-1. Locale: en_US, LC_ALL:.

Switching to next trail file /OGG_PY/trails/p1000031

2014-08-18 06:30:14 ERROR OGG-05500 Detected database metadata mismatch between current trail file /OGG_PY/trails/p1000031 and the previous sequence.
DBNAME: - unreadable characters
*DBLOCALE: [en_US]/[en_US_POSIX].

other times it reads the trail files successfully -

Starting at 2014-08-16 20:27:40

Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.

Opened trail file /OGG_PY/trails/p1000029 at 2014-08-16 20:27:47
Switching to next trail file /OGG_PY/trails/p1000030 at 2014-08-16 20:27:47 due to EOF, with current RBA 943

The extract abends when rolling over from one trail to the next.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms