IO22233: Update attribute value of ICM$NAME to NULL returns 'DB2 SQL Error: SQLCODE=-1131' or 'ORA-28579'

CM V8.5 FP2 for Linux zSeries
CM V8.5 FP2 for Windows
CM V8.5 FP2 for Solaris 64-bit, SPARC
CM V8.5 FP2 for Linux
CM V8.5 FP2 for AIX
IBM Content Manager Enterprise Edition V8.5 Fix Pack 2

APAR status

• Closed as program error.

Error description

• When you update the attribute value for ICM$NAME to NULL, you
  might receive following error.
  If your library server database is on Oracle:
  com.ibm.mm.sdk.common.DKUsageError: DGL3616A: An unexpected SQL
  error occurred;  ICM7015: During an SQL operation in the library
  server, an unexpected error occurred.  For details on the error,
  refer to the database document. (STATE) : [LS RC = 7015, LS
  reasonCode = 27000, SQL RC = -28579]
  
  If your library server database is on DB2:
  com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-1131,
  SQLSTATE=38503, SQLERRMC=-2029060040;*;*;*;*;;SEMAPHORE WAIT;,
  DRIVER=3.63.81
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * 999                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Updating the value for attribute ICM$NAME to a NULL value    *
  * might cause the library server stored procedure to terminate *
  * abnormally. You might receive the error 'DB2 SQL Error:      *
  * SQLCODE=-1131' if your library server database is on DB2, or *
  * the error of '[LS RC = 7015, LS reasonCode = 27000, SQL RC = *
  * -28579]' if your library server database is on Oracle. This  *
  * error occurs because the library server stored procedure     *
  * doesn't correctly handle the update to a NULL value for the  *
  * attribute ICM$NAME.                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * No                                                           *
  ****************************************************************
  

Problem conclusion

• The problem is now fixed in IBM Content Manager Version 8.5 Fix
  pack 2
  

Temporary fix

Comments

APAR Information

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

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

  IO22236

Modules/Macros

• 999
  

Fix information

• Fixed component name

  LIBRARY SERVER

• Fixed component ID

  5724B1907

Applicable component levels

• R850 PSY

     UP