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
Back to discussions
Expand all | Collapse all

value too large for column "WM7"."PRTUUIDPIDXREF"."UUID"

  • 1.  value too large for column "WM7"."PRTUUIDPIDXREF"."UUID"

    Posted Tue September 21, 2010 11:35 AM

    Hi,
    Can you please help us with below error…

    com.wm.app.prt.ProcessException: [PRT.0101.9358] Exception while executing SQL statement java.sql.SQLException: [wm-cjdbc36-0039][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column “WM7”.“PRTUUIDPIDXREF”.“UUID” (actual: 56, maximum: 38) at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source) at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source) at

    :p:Venkata Vidya Sagar Pokuru


    #webMethods
    #BPM
    #webMethods-BPMS


  • 2.  RE: value too large for column "WM7"."PRTUUIDPIDXREF"."UUID"

    Posted Tue September 21, 2010 05:10 PM

    Hi, I assume “WM7”.“PRTUUIDPIDXREF”.“UUID” is a table in a database, if I’m not wrong you have two ways to solve, contact to the DBA guy to expand the column or tokenize your data at 38 before insert it.
    Regards.
    Alex.


    #webMethods
    #webMethods-BPMS
    #BPM


  • 3.  RE: value too large for column "WM7"."PRTUUIDPIDXREF"."UUID"

    Posted Tue September 21, 2010 05:12 PM

    Sorry for my mistake, when I wrote Tokenize I mean Substring.


    #webMethods-BPMS
    #BPM
    #webMethods


  • 4.  RE: value too large for column "WM7"."PRTUUIDPIDXREF"."UUID"

    Posted Tue September 21, 2010 05:31 PM

    It’s not recommended to fiddle with the application tablespace schema unless you are left with no other options.

    WM7".“PRTUUIDPIDXREF”.“UUID” UUID field contains the identifier for the document published for either to invoke or transition within process for duplicate detection. Check if you can suppress this key field which you are logging under UUID for the specified length.


    #webMethods
    #BPM
    #webMethods-BPMS


  • 5.  RE: value too large for column "WM7"."PRTUUIDPIDXREF"."UUID"

    Posted Thu September 23, 2010 07:30 AM

    Hi All,
    We could fix :confused: this issue in our environment …
    Thanks to all who responded to this thread…

    The cause for this issue we have enabled duplicate detection on WMPRT package for other requirement,now this is causing this error.

    Why this is causing problem?
    As per the documentation the table “PRTUUIDPIDXREF”

    “This table provides persistent storage of document identifiers that Process Engine uses to detect duplicate published input or transition documents. The key for this table is the document UUID. The Process Engine inserts entries into this table when it receives an input or transition document and the user has enabled the duplicate event detection feature.”

    The table PRTUUIDPIDXREF is to maintain a cross reference between a documents UUID and Process Instance ID(PID) for the Process engine(PRT).

    We have unchecked this option on WMPRT and reloaded the WMPRT package to fix this issue.

    Thanks to all…:happy:
    Venkata Vidya Sagar Pokuru.


    #webMethods
    #webMethods-BPMS
    #BPM


Related Content