How to fix error goldengate: Bad column length, Bad column index ...
MdhtMar 26 2012 — edited Apr 6 2012Hi 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!