IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  value too large for column

    Posted Mon May 02, 2011 05:45 PM

    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]


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 2.  RE: value too large for column

    Posted Mon May 02, 2011 05:51 PM

    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


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: value too large for column

    Posted Mon May 02, 2011 07:27 PM

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


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 4.  RE: value too large for column

    Posted Mon May 02, 2011 08:23 PM

    It sounds resolved now?


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 5.  RE: value too large for column

    Posted Tue May 03, 2011 04:29 PM

    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?


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods


  • 6.  RE: value too large for column

    Posted Tue May 03, 2011 05:29 PM

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


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


Related Content