IBM Support

JR40495: IN A COLLABORATION AREA, WHEN SAVING AN ITEM WITH MANY UPDATED ATTRIBUTES,A "TOO LARGE FOR DATABASE COLUMN" ERROR IS THROWN.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In a collaboration Area, when saving an item with many updated
    attributes, the 'EntryDifferencesXML' cannot be written in the
    database.
    The error is:
    ERROR - XML ENTRY DIFFS STRING REPRESENTATION REQUIRED MORE THAN
    3000
    CHARACTERS; TOO LARGE FOR DATABASE COLUMN, DISCARDED
    
    Here is the stack trace:
    
    [jsp_14751: saveColAreaEntries.wpc] ERROR
    com.ibm.ccd.common.error.AustinException - CWPCM0002E:Generic
    error /
    Exception: DB2 SQL Error: SQLCODE=-302,
    SQLSTATE=22001, SQLERRMC=null, DRIVER=3.57.82
    com.ibm.db2.jcc.am.co: DB2 SQL Error: SQLCODE=-302,
    SQLSTATE=22001,
    SQLERRMC=null, DRIVER=3.57.82
            at com.ibm.db2.jcc.am.bd.a(bd.java:668)
            at com.ibm.db2.jcc.am.bd.a(bd.java:60)
            at com.ibm.db2.jcc.am.bd.a(bd.java:127)
            at com.ibm.db2.jcc.am.km.b(km.java:2164)
            at com.ibm.db2.jcc.am.km.c(km.java:2147)
            at com.ibm.db2.jcc.t4.db.k(db.java:354)
            at com.ibm.db2.jcc.t4.db.a(db.java:60)
            at com.ibm.db2.jcc.t4.t.a(t.java:50)
            at com.ibm.db2.jcc.t4.tb.b(tb.java:218)
            at com.ibm.db2.jcc.am.lm.ec(lm.java:2692)
            at com.ibm.db2.jcc.am.lm.b(lm.java:3225)
            at com.ibm.db2.jcc.am.lm.b(lm.java:3697)
            at com.ibm.db2.jcc.am.lm.Wb(lm.java:690)
            at com.ibm.db2.jcc.am.lm.executeUpdate(lm.java:673)
            at
    org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdat
    e(Delega
    tingPreparedStatement.java:233)
            at com.ibm.ccd.common.db.Query.executeUpdate(Unknown
    Source)
            at
    com.ibm.ccd.common.context.common.DBContext.executeUpdate(Unknow
    n
    Source)
    

Local fix

  • Truncate attribute content
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All Master Data Management Server for Product Information
    Management implementations are affected by this issue.
    ****************************************************************
    PROBLEM DESCRIPTION:
    [P0] IN A COLLABORATION AREA, WHEN SAVING AN ITEM WITH MANY
    UPDATED ATTRIBUTES, A "TOO LARGE FOR DATABASE COLUMN" ERROR
    IS THROWN.
    ****************************************************************
    RECOMMENDATION:
    IBM recommends that customers facing the issue reported by this
    APAR apply  Master Data Management Server for Product
    Information Management version 9.1.0-FP2 to gain resolution to
    this problem
    ****************************************************************
    

Problem conclusion

  • A fix for this problem has been included in Master Data
    Management Server for Product Information Management version
    9.1.0-FP2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR40495

  • Reported component name

    MDM SERVER FOR

  • Reported component ID

    5724V5100

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-29

  • Closed date

    2012-01-24

  • Last modified date

    2012-01-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    MDM SERVER FOR

  • Fixed component ID

    5724V5100

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS2U2U","label":"InfoSphere Master Data Management Collaboration Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
24 January 2012