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.

RunSQLFile: [sql] Executing file: WC/temp/updatedbforldap.sql [sql] Failed to execute: ...

This is caused by the following limitations:

  • Apache Derby 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
  • DB2 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.