Portal to 6.0.1.3 Database transfer fail in action-add-constraints

[Gustavo Rojas]

I upgrade the Portal to 6.0.1.3 and WAS 6.0.2.27 with JDK for WAS WAS 6.0.2.27. When I try to transfer all domains to DB2 9.1.3 with ODBC Client Type 4 give that error.

tks a lot for your help.

action-add-constraints:

Thu May 15 18:49:41 GMT-06:00 2008

java Reading file C:\IBM\WEBSPH~1\PORTAL~1\config\DBTransfer\wps\enableConstraints.sql

java Connected to jdbc:db2://levan.paradise.gar:50000/jcrdb:returnAlias=0;

java Setting database autocommit to:true

java ALTER TABLE CUSTOMIZATION.APPLICATION_ROLE ADD CONSTRAINT FK2230A FO

REIGN KEY (PARENT_OID) REFERENCES CUSTOMIZATION.APPLICATION_ROLE (OID) ON DELETE CASCADE

java Error during statement execution!

java com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: CUSTOMIZATION.APPLICATION_ROLE

java at com.ibm.db2.jcc.b.tf.e(tf.java:1681)

java at com.ibm.db2.jcc.b.tf.b(tf.java:1208)

java at com.ibm.db2.jcc.c.jb.i(jb.java:225)

java at com.ibm.db2.jcc.c.jb.b(jb.java:50)

java at com.ibm.db2.jcc.c.w.b(w.java:36)

java at com.ibm.db2.jcc.c.cc.e(cc.java:150)

java at com.ibm.db2.jcc.b.tf.m(tf.java:1205)

java at com.ibm.db2.jcc.b.tf.a(tf.java:1994)

java at com.ibm.db2.jcc.b.tf.e(tf.java:810)

java at com.ibm.db2.jcc.b.tf.execute(tf.java:794)

java at com.ibm.wps.config.SqlProcessor.process(SqlProcessor.java:591)

java at com.ibm.wps.config.SqlProcessor.process(SqlProcessor.java:146)

java at com.ibm.wps.config.SqlProcessor.process(SqlProcessor.java:84)

java at com.ibm.wps.config.SqlProcessor.main(SqlProcessor.java:945)

java (ErrCode=-204, SqlState=42704)

BUILD FAILED

file:../config/actions/dbt_dbcfg.xml:481: Java returned: 4

[Gustavo Rojas]

The problem was a misconfiguration in the file separator (the class and license info ODBC Client type 4)

I used ":" but in Windows you need to use ";"

I change that and the transfer was successful.