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 Wed October 27, 2010 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 Wed October 27, 2010 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 Thu October 28, 2010 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 Fri November 12, 2010 08:03 AM

    You will have to apply DCC_7.1.2_Fix3


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