APAR status
Closed as program error.
Error description
CM 8.3 or 8.4. When ACL user exit is enabled, a user getting the following error in Library Server log when accessing worklists: SQL0433N Value "ICMADMIN.ICMGETWORKLIST" is too long. SQLSTATE=22001 This is because the definition of function ICMACLPrivExit has VARCHAR(20) as the fifth parameter and length of "ICMADMIN.ICMGETWORKLIST" exceeds that limit.
Local fix
A user may drop the old definition of function ICMACLPrivExit and create it again: create function ICMACLPrivExit ( VARCHAR(33), VARCHAR(32670), VARCHAR(151), INTEGER, VARCHAR(28), INTEGER, CHAR(26), INTEGER, INTEGER ) RETURNS INTEGER EXTERNAL NAME 'ICMACLXT!ICMACLPrivExit' LANGUAGE C PARAMETER STYLE DB2SQL FENCED NO SQL; Rebind the database after the creation.
Problem summary
When the library server is enabled to use ACL user exits, a user who is viewing a worklist might encounter the following error from the client: com.ibm.mm.beans.CMBException: DGL4057A: Unable to get worklist; 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, SQL RC = -433] In addition, the library server log contains the following error: <SQL0433N Value "ICMADMIN.ICMGETWORKLIST" is too long. SQLSTATE=22001> with error return code rc=7015 reason=0 extrc=-433 The errors happen because the fifth parameter (VARCHAR(20)) of UDF ICMACLPRIVEXIT exceeds the length limitation.
Problem conclusion
This problem was fixed in DB2 Content Manager Version 8.3 Fix Pack 10.
Temporary fix
As a workaround, you can drop and then recreate the ICMACLPrivExit function as shown: drop function ICMACLPrivExit; create function ICMACLPrivExit ( VARCHAR(33), VARCHAR(32670), VARCHAR(151), INTEGER, VARCHAR(28), INTEGER, CHAR(26), INTEGER, INTEGER ) RETURNS INTEGER EXTERNAL NAME 'ICMACLXT!ICMACLPrivExit' LANGUAGE C PARAMETER STYLE DB2SQL FENCED NO SQL;
Comments
APAR Information
APAR number
IO09367
Reported component name
LIBRARY SERVER
Reported component ID
5724B1907
Reported release
830
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2008-08-22
Closed date
2008-12-23
Last modified date
2008-12-23
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
LIBRARY SERVER
Fixed component ID
5724B1907
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSRS7Z","label":"IBM Content Manager Enterprise Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"830","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
23 December 2008