Troubleshoot and support > WebSphere Commerce Portals
Troubleshoot: SQL errors in the wcportalconfig_timestamp.log
The WebSphere Commerce Portal configuration tool fails and errors similar to the following are logged in the wcportalconfig_timestamp.log file.
RunSQLFile: [sql] Executing file: WC/temp/updatedbforldap.sql [sql] Failed to execute: ...
This is caused by the following limitations:
- When the Derby database script processes CLOB columns, the maximum data that it can handle is 32 KB. If any of the following CLOB columns contain more than 32 KB of data, it will cause an error in the script:
- MBRGRPCOND.CONDITIONS
- PRODUCTSET.XMLDEFINITION
- CNTRSTORE.STOREXML
- TCATTR.XMLDEFINITION
- TRDPSCNXML.XMLDEFINITION
- EXPERIMENT.RULEXML
- INITIATIVE.RULE
- PX_DYNATTR.XMLPARAM
- PX_GROUP.XMLPARAM
- PX_POLICY.XMLPARAM
- PX_PROMOARG.DETAIL
- PX_PROMOTION.XMLPARAM
- When a DB2 database script processes the CLOB columns, the maximum data it can handle is 1 MB. If any of the following CLOB columns contain more than 1 MB of data, it will cause an error in the script:
- PX_PROMOTION.XMLPARAM
Solution
If these errors occur, manually remove the problematic tables from the WC_INSTALL/temp/updatedbforldap.sql file, and then re-run the script. After you have removed the tables from the script, manually change the removed tables in the database by using the database export and import tools.