Troubleshooting: Problems encountered when running the WebSphere Commerce Portal configuration tool

The WebSphere Commerce Portal configuration tool fails and the following error is logged in the WC_installdir/instances/ instance_name/logs/wcportalconfig_timestamp.log:

RunSQLFile: [sql] Executing file: /usr/WebSphere/CommerceServer60/temp/updatedbforldap.sql [sql] Failed to execute: update px_group set xmlparam = replace(xmlparam,'o=root organization','o=wcsp.hostname.com') where xmlparam like '%o=root organization%'

BUILD FAILED

file:/usr/WebSphere/CommerceServer60/components/wcportal/xml/DBTasks.xml:23: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0443N Routine "SYSFUN.REPLACE" (specific name "REPLACE2C") has returned an error SQLSTATE with diagnostic text "SYSFUN:10". SQLSTATE=38552 Solution

Apply the DB2 UDB V8.1 FixPak 11 (also known as V8.2 FixPak 4) and run the WebSphere Commerce Portal Configuration tool again. - - -