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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  value too large for column

    Posted 10/27/10 01:40 PM

    Hello,
    I am getting error on IS server log as

    2010-10-26 20:32:54 PDT [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column “B2BVTP_AUDIT”.“PRTPROCESS”.“CONTEXTSTACK” (actual: 3992, maximum: 3500)

    The CONTEXTSTACK is set to : CONTEXTSTACK VARCHAR2(3500 BYTES)

    Earlier it was set to CONTEXTSTACK CHAR(1000 BYTES) at that time I was getting error like

    [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column “B2BVTP_AUDIT”.“PRTPROCESS”.“CONTEXTSTACK” (actual: 1220, maximum: 1000)

    To resolve this problem I have set field valur to 3500, But still I am facing the above error.

    Could anyone help me for the same.

    Thanks in advance,
    Archana


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-Archive


  • 2.  RE: value too large for column

    Posted 10/27/10 11:43 PM

    which PRT version you are on… i recall SAG provided a fix for this problem…


    #webMethods
    #webMethods-Archive
    #Integration-Server-and-ESB


  • 3.  RE: value too large for column

    Posted 10/28/10 10:48 AM

    Thanks for your reply.

    We are using webMethods 7.1.1 version


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-Archive


  • 4.  RE: value too large for column

    Posted 11/12/10 08:03 AM

    You will have to apply DCC_7.1.2_Fix3


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-Archive