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