LinuxWindowsDB2

Troubleshooting: Error when deleting a member group or removing an approval type from an organization in Organization Administration Console

Review this document which describes three problems encountered when deleting a member group or removing an approval type.

Problem 1

When you try to delete a member group or remove an approval type from an organization in 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

  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
    
  2. Restart the DB2 server.

Problem 2

When you try to delete a member group or remove an approval type from an organization in 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 while 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

  1. Increase the SQL statement heap to 240000 (in 4 KB pages) or more, using the following SQL statement:
    
    db2 update database configuration for database_name using stmtheap 240000
    

    If you have increased the statement heap to the maximum and the problem still exists, and this is occurring on the staging server, follow the steps in option 3 of Troubleshooting: Errors when loading or deleting MEMBER data on staging server .

  2. Restart the DB2 server.

Problem 3

When you try to delete a member group or remove an approval type from an organization in Organization Administration Console, you receive the following error in the SystemOut.log file:


[8/21/08 0:45:07:468 EDT] 00000032 ExceptionUtil E CNTR0020E:
EJB threw an unexpected (non-declared) exception during invocation of method "remove" on bean
"BeanId(WC_demo#Member-MemberManagementData.jar#MemberGroup, MemberId=8000000100000005013 )".
Exception data: com.ibm.websphere.cpi.CPIException: ; nested exception is:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0954C
Not enough storage is available in the application heap to process the statement. SQLSTATE=57011

Solution 3

  1. Increase the SQL application heap to 3000 (in 4 KB pages) or more, using the following SQL statement:
    
    db2 update database configuration for database_name using applheapsz 3000
    
  2. Restart the DB2 server.