Skip to Main Content
Forums

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error OGG-02092 indexOutOfRangeError reported GG big Data to HDFS

Mich TalebzadehMay 11 2017 — edited May 11 2017

Hi,

I would like to see if there is anyway one can reset the reading of trail files. When I start replicat to HDFS I get this in GG log:

2017-05-11 09:58:26  INFO    OGG-06510  Oracle GoldenGate Delivery, rhdfs.prm:  Using the following key columns for target table scratchpad.bigtab: ID.

2017-05-11 09:58:26  INFO    OGG-02232  Oracle GoldenGate Delivery, rhdfs.prm:  Switching to next trail file dirdat/kf000000009 at 2017-05-11 09:58:26.103734 due to EOF. with current RBA 3608.

2017-05-11 09:58:26  WARNING OGG-01003  Oracle GoldenGate Delivery, rhdfs.prm:  Repositioning to rba 3422 in seqno 2.

2017-05-11 09:58:26  INFO    OGG-02232  Oracle GoldenGate Delivery, rhdfs.prm:  Switching to next trail file dirdat/kf000000003 at 2017-05-11 09:58:26.159191 due to EOF. with current RBA 107208.

2017-05-11 09:58:26  INFO    OGG-02232  Oracle GoldenGate Delivery, rhdfs.prm:  Switching to next trail file dirdat/kf000000004 at 2017-05-11 09:58:26.516346 due to EOF. with current RBA 664367.

2017-05-11 09:58:27  INFO    OGG-02232  Oracle GoldenGate Delivery, rhdfs.prm:  Switching to next trail file dirdat/kf000000005 at 2017-05-11 09:58:27.783490 due to EOF. with current RBA 361441.

2017-05-11 09:58:28  INFO    OGG-02232  Oracle GoldenGate Delivery, rhdfs.prm:  Switching to next trail file dirdat/kf000000006 at 2017-05-11 09:58:28.913357 due to EOF. with current RBA 1182633.

2017-05-11 09:58:28  INFO    OGG-02232  Oracle GoldenGate Delivery, rhdfs.prm:  Switching to next trail file dirdat/kf000000007 at 2017-05-11 09:58:28.943509 due to EOF. with current RBA 4265.

2017-05-11 09:58:28  INFO    OGG-03010  Oracle GoldenGate Delivery, rhdfs.prm:  Performing implicit conversion of column data from character set we8mswin1252 to US-ASCII.

2017-05-11 09:58:28  ERROR   OGG-02092  Oracle GoldenGate Delivery, rhdfs.prm:  Unexpected condition in indexOutOfRangeError at line 48. Index 113 out of range. Number of elements: 4.

2017-05-11 09:58:28  ERROR   OGG-01668  Oracle GoldenGate Delivery, rhdfs.prm:  PROCESS ABENDING.

Is there anyway one can reset the trail file?

The error description from manual is pretty useless

OGG-02092: Unexpected condition in {0} at line {1,number,0}. Index {2} out of range.

Number of elements: {3}.

Cause: An internal error occurred. Index specified is out of range.

Action: Contact Oracle Support.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2017
Added on May 11 2017
#goldengate
1 comment
1,217 views