IO09367: When using the ACL user exit (ICMACLXT) to view a worklist, the errors rc=7015 and extRC=-443 are returned.

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 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