Troubleshooting: WebSphere Commerce Portal Configuration Wizard fails
The configuration wizard fails and you see errors in the log file (wcportalconfig_timestamp.log) related to the updatedbforldap.sql script. For example: RunSQLFile: [sql] Executing file: <WC>/temp/updatedbforldap.sql [sql] Failed to execute: ...
Cause
When the Derby database script processes CLOB columns, the maximum data it can handle is 32 KB. If any of the following CLOB columns contain more than 32 KB of data, it can 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 the DB2 database script processes CLOB columns, the maximum data it can handle is 1 MB of data. Therefore if any of the following CLOB columns contain more than 1 MB of data, it can cause an error in the script:
- PX_PROMOTION.XMLPARAM
Solution
If errors occur due to the size limitations, you must remove the problematic tables from the WC_installdir/temp/updatedbforldap.sql or WCDE_installdir/temp/updatedbforldap.sql script and then rerun the script. You must manually change the removed tables, for example using the database export and import tools.