Troubleshoot and support > Migrate > Database tier migration issues
Troubleshoot: 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
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 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
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 Troubleshoot: Errors when loading or deleting MEMBER data on staging 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
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