APAR status
Closed as program error.
Error description
MOVING A SITE OR SITE AREA WITH LOTS OF CHILDREN RETURNS THE DB ERROR "THE STATEMENT IS TOO LONG OR TOO COMPLEX"
Local fix
Problem summary
Problem Summary: Moving a Site or Site Area with lots of children returns the DB Error 'The statement is too long or too complex' Detailed Problem Description: Attempting to move a Site or SiteArea with lots of children will return the DB error 'The statement is too long or too complex', SQL0101N under DB2. This error actually occurs during the final phase of the move which clears the render caches and thus doesn't mean that the move has failed, but rather that the rendering caches are out of sync. Restarting the server is a valid workaround to fix the render caches
Problem conclusion
Problem Analysis: The moving engine is attempting to optimise the clearing of the rendering caches by finding all nested children of the moved item and only removing those from the rendering caches. This optimisation won't scale with large repositories and in medium to large repositories is slower than simply clearing the entire cache Failing Module: WCM - Web Content Management (General) Problem Solution: The moving engine was modified to simply clear the render cache instead of trying to remove selected items, which is faster and doesn't have the above mentioned problem. Affected Users: Content Authors An interim fix is available for this APAR from Fix Central at: http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde r?brandid=2&productid=Workplace%20Web%20Content%20Management&fix es=6.0.1.2-WCM-PK57049 You will need to cut/paste the entire URL into a browser to resolve the address.
Temporary fix
Comments
APAR Information
APAR number
PK57049
Reported component name
WRKPLC WEB CON
Reported component ID
5724I2900
Reported release
60E
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-11-26
Closed date
2008-03-05
Last modified date
2008-05-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WRKPLC WEB CON
Fixed component ID
5724I2900
Applicable component levels
R60F PSY
UP
R60G PSY
UP
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.1.1","Edition":"","Line of Business":{"code":null,"label":null}}]
Document Information
Modified date:
10 September 2020