Troubleshoot: Error when deleting access group from Organization Administration Console
Review this document which describes two problems encountered when deleting an access group.
Problem 1
When you try to delete an access group from the WebSphere Commerce Organization Administration Console, you receive the following error in the SystemOut.log file:
[7/21/03 13:39:28:892 CST] 289b7b86 ExceptionUtil E CNTR0020E: Non-application exception occurred while processing method "remove" on bean "BeanId(WC_demo#Member-MemberManagementData.jar#MemberGroup, com.ibm.commerce.user.objects.MemberKey@5425b554)". Exception data: com.ibm.websphere.cpi.CPIException:; nested exception is: com.ibm.ejs.cm.portability.ResourceAllocationException: [IBM][CLI Driver][DB2/LINUX390] SQL0973N Not enough storage is available in the "PCKCACHESZ" heap to process the statement. SQLSTATE=57011
Solution 1
Increase the package cache size to 4096 (in 4 KB pages) or more, using the following SQL statement:
db2 update database configuration for database_name using pckcachesz 4096
Problem 2
When you try to delete an access group from the WebSphere Commerce Organization Administration Console, you receive the following error in the SystemOut.log file:
[8/21/03 0:31:41:413 PDT] 12264319 ExceptionUtil E CNTR0020E: Non-application exception occurred whi le processing method "remove" on bean "BeanId(WC_demo#Member-MemberManagementData.jar#MemberGroup, com.ibm.commerce.user.objects.MemberKey@5425b5ab)". Exception data: com.ibm.websphere.cpi.CPIException: ; nested exception is: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0101N The statement is too long or too complex. SQLSTATE=54001 COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0101N The statement is too long or too complex. SQLSTATE=54001
Solution 2
Increase the SQL statement heap to 60000 (in 4 KB pages) or more, using the following SQL statement:
db2 update database configuration for database_name using stmtheap 60000
Related Concepts