Troubleshooting: 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.
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, you must manually remove the problematic tables from the WC_installdir/temp/updatedbforldap.sql file, and then re-run the script. After you have removed the tables from the script, you must manually change the removed tables in your database by using the database export and import tools.