Replicat Abends with OGG-1163 (maximum allowable length is 4000) for LONG/ LONG RAW Columns (Doc ID 1382673.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Symptoms

Replicat would abend with "bad column length" and the reported length would be greater than 4000
for a LONG/ LONG RAW datatype column

2011-10-25 23:19:05 ERROR OGG-01163 Bad column length (4080) specified for column EMAIL_BODY in table SIEBEL.S_EVT_MAIL, maximum allowable length is 4000.


Trail file would show the column value present in the base record rather than as 2K chunks

2011/10/25 19:18:55.999.712 FieldComp Len 4155 RBA 6290989
Name: SIEBEL.S_EVT_MAIL
...
Column 22 (x0016), Len 4080 (x0ff0)
0000 0fec 5b54 6869 7320 626c 6f63 6b20 6973 2039 | ....[This block is 9

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