WebSphere Process Server for z/OS hangs and then times out after you update the LDAP user registry and attempt to view human tasks

Technote (troubleshooting)


Problem(Abstract)

You added users to groups that control human task ownership or administration. You add users to groups that control human task ownership or administration. After you update the LDAP user registry, you cannot view the human tasks. After you review the log files, you notice a CWTKE0021W warning message.

Symptom

The following message is the complete warning message:

CWTKE0021W: Cannot refresh expired people assignment (staff query result)


In the stack trace, you see the following exceptions:

Exception = com.ibm.bpe.api.WorkItemManagerException                  
Source =  com.ibm.task.core.message.RefreshStaffQueryMessage.processMessage      
probeid = 109                                                          
Stack Dump = com.ibm.bpe.database.TomSQLException:                    
com.ibm.db2.jcc.am.SqlException: [jcc][50053][12311][3.59.83] T2zOS    
exception: [jcc][T2zos]T2zosResultSet.readFetch_:nativeFetch:3045: DB2 engine SQL error, SQLCODE = -904, SQLSTATE = 57011, error tokens =     00C90096;00000304;WPS01DB .WORKI01 .X'00373F' '.X'28' ERRORCODE=-904, SQLSTATE=57011

Cause

You exceeded the maximum number of locks that can be held per user The error tokens = 00C90096 for object WPS01DB .WORKI01 means you are using ROW level locking.

Diagnosing the problem

The page lock on the page or subpage that is identified by NAME in the DSNT500I message caused the total number of page locks concurrently held to reach the installation maximum number of page locks (NUMLKUS) that are allowed for a single agent in the system.

Resolving the problem

To resolve this issue, your database administrator can increase or decrease the NUMLKUS value. You need to either increase the number of locks that can be held by a user in zparm or decrease the number of locks that are held by the user. To take these actions, use the following statement:

ALTER ... LOCKSIZE TABLE SPACE  or LOCK  TABLE                                                      

Your database administrator can increase or decrease the numlkus values of the following entities:

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Process Server
Security

Software version:

7.0.0.4

Operating system(s):

z/OS

Reference #:

1598353

Modified date:

2013-01-02

Translate my page

Machine Translation

Content navigation