Skip to Main Content

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!

How to fix error goldengate: Bad column length, Bad column index ...

MdhtMar 26 2012 — edited Apr 6 2012
Hi all,
I setup Golden gate and configured replicate run in about some hour, but now I see many error replicat abended. I deliver to 5 group, they had error.They are:

2012-03-24 14:09:50 ERROR OGG-01161 Oracle GoldenGate Delivery for Oracle, xxx1.prm: Bad column index (-2413) specified for table xxx1, max columns = 84.

2012-03-24 14:09:59 ERROR OGG-01162 Oracle GoldenGate Delivery for Oracle, xxx2.prm: Total data length (294) specified for table xxx2 exceeds record length (106).

2012-03-26 09:10:19 ERROR OGG-01163 Oracle GoldenGate Delivery for Oracle, xxx3.prm: Bad column length (65533) specified for column xxx3 in table xxx3, maximum allowable length is 15.

2012-03-26 08:37:48 ERROR OGG-01161 Oracle GoldenGate Delivery for Oracle, xxx4.prm: Bad column index (28019) specified for table xxx4, max columns = 14.

REPLICAT REPCUSPA
2012-03-26 08:37:54 ERROR OGG-01164 Oracle GoldenGate Delivery for Oracle, xxx5.prm: Column index (0) out of sequence for table xxx5, last column index = 6.

I set NLS_LANG
in source : SETENV (NLS_LANG = AMERICAN_AMERICA.UTF8)
in target :SETENV (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)

at moment I set they are same, then restart replicat, but still same error.

I thinks all of them have a same problem when I configured. Because they have error about length in trail file different from structure target. I checked structure both source and target are same. But I don't know where is problem.
Please tell me if you know where is problem?
THanks so much!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2012
Added on Mar 26 2012
12 comments
8,279 views