value too large for column

, ,
1

Hello-

We’ve been seeing this error for a couple days, from what I’ve found in similar errors the suggested options are often to have a DBA extend the table/column in question.

I’m hesitant to do this without some input on the specific error…

Anyone input is appreciated.

[560]2011-05-02 13:44:08 GMT [ISU.0000.9999W] java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column “WMTN61”.“ACTIVITYLOG”.“RELATEDDOCID” (actual: 45, maximum: 24)
[559]2011-05-02 13:44:08 GMT [ISU.0000.9999W] Error logging database event [TRNSERV.000016.000005]

2

Did you check TN and table whats logging that time…Yes probably there should be a wM6.1 fix that old days check the empower.

But Increasing the column length TN built-in tables at your own risk:

HTH,
RMG

3

we are actually using 6.5… the table name was never updated when last upgraded.

4

It sounds resolved now?

5

Not resolved.

The issue is still occurring… I’m unable to see transactions or partners from my TNweb view. I’m also not seeing a specific transaction on the same timestamp as the error…

Where should I be looking outside of TN console?

6

You have to trouble shoot comparing logs timestamp and TN activity log/DBA for help further: