Technote

(troubleshooting)
idresgen utility fails with error CMN6202E during store publishing
Problem(Abstract)
Your idresgen utility fails with error CMN6202E when publishing the WebSphere Commerce extended sites sample store.
Symptom
[2/5/08 15:44:11:392 EST] 00000042 CommerceSrvr E com.ibm.commerce.tools.devtools.publish.ErrorDocHandler parseErrorDoc CMN6202E: The file "/tmp/WCS41344/SARS/Stores.war/WEB-INF/stores/ExtendedSites/data/store-data-assets.error.xml" could not be located.
[2/5/08 15:44:11:420 EST] 00000042 CommerceSrvr A com.ibm.commerce.tools.devtools.publish.tasks.idresolve.IdResolverTaskCmdImpl performExecute CMN4512I:
[2/5/08 15:44:11:477 EST] 00000042 CommerceSrvr E com.ibm.commerce.tools.devtools.publish.tasks.idresolve.IdResolverTaskCmdImpl performExecute IdResolver failed to resolve the input file /tmp/WCS41344/SARS/Stores.war/WEB-INF/stores/ExtendedSites/data/store-data-assets.xml. Ensure the data contained in the input file correctly matches the database schema.
Cause Incorrect JDBC driver. Resolving the problem Verify that you are using a type 2 JDBC driver for your WebSphere Commerce datasource. You can verify what JDBC driver type you are using by checking your SystemOut.log file. The following is an example of an incorrect setup using a type 4 JDBC driver:
[2/1/08 16:14:17:300 EST] 0000001e InternalGener I DSRA8203I: Database product name : DB2/6000
[2/1/08 16:14:17:313 EST] 0000001e InternalGener I DSRA8204I: Database product version : SQL08028
[2/1/08 16:14:17:325 EST] 0000001e InternalGener I DSRA8205I: JDBC driver name : IBM DB2 JDBC Universal Driver Architecture
[2/1/08 16:14:17:343 EST] 0000001e InternalGener I DSRA8206I: JDBC driver version : 2.7.58
[2/1/08 16:14:17:355 EST] 0000001e WSRdbDataSour I DSRA8208I: JDBC driver type : 4

In the above example, the type 4 JDBC driver was used instead of the type 2 driver. A correct JDBC driver configuration should result in the following trace instead:

[12/22/07 12:11:08:344 EST] 00000017 InternalGener I DSRA8203I: Database product name : DB2/NT
[12/22/07 12:11:08:359 EST] 00000017 InternalGener I DSRA8204I: Database product version : 08.02.0003
[12/22/07 12:11:08:359 EST] 00000017 InternalGener I DSRA8205I: JDBC driver name : IBM DB2 JDBC 2.0 Type 2

Ensure that in your WAS administrative server, you are using db2java.zip as your JDBC driver.



NOTE: There may also be other reasons for this error. The recommendation provided here refers to the most common case. If you still experience a problem after verifying the JDBC driver, contact IBM support for assistance.
Cross Reference information
Segment Product Component Platform Version Edition
Commerce WebSphere Commerce Professional Edition Configuration AIX, i5/OS, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4 Professional Edition
Commerce WebSphere Commerce - Express Configuration i5/OS, Linux, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4 Express
Commerce WebSphere Commerce Business Edition Configuration AIX, i5/OS, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4 Business Edition
Commerce WebSphere Commerce Developer Enterprise Configuration Windows 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4 Enterprise
Commerce WebSphere Commerce Developer Professional Edition Configuration Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4 Developer Professional Edition
Commerce WebSphere Commerce Developer Express Configuration Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4 Developer Express
   

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21296051