Troubleshoot and support > Utilities
Troubleshoot: Errors when loading or deleting MEMBER data on staging server
In a production server, the MEMBER table contains organizations, member groups, administrative users, and shoppers. In a staging server, the MEMBER table contains these organizations and member groups, but only the -1000 user is staged. Other test administrators and test shoppers can be created on the staging server, but they are not propagated to the production server.
Problem
When you insert, update, or delete MEMBER data on a staging server you see following error:
SQL3015N An SQL error "-101" occurred during processing. SQL0101N The statement is too long or too complex. SQLSTATE=54001
Solution
Start from option 1 and continue until you resolve the problem:
- Option 1 (insert or update actions)
Use the sqlimport option.
If you are trying a delete method see option 3.
- Option 2
- Increase the DB2 database statement heap size, stmtheap - Statement heap size configuration parameter
- Restart the DB2 server.
- Rerun massload.
- Option 3 (insert, update, or delete actions)
A massload delete method is not recommended for the MEMBER table. If a delete method is used, complete the steps in this option.
- Drop the staging triggers from the staging server by running the following script:
- WC_INSTALL/schema/db2/wcs.droptrigger.sql
- Run the massload utility to load MEMBER data.
- Create the staging triggers again by running the following script:
- WC_INSTALL/schema/db2/wcs.stage.trigger.sql
After completing option 3, all massload data is not logged in the staging server and data is not be propagated to the production server.
To ensure that MEMBER data is available in the production server, massload the data directly to the production server.
Related concepts
Database (DB2) performance considerations
Related tasks
Update the DB2 database configuration