Cloudscape to DB2 -data transfer failed (for Websphere Portal 6.0.1.3)

[ak...@chrysler.com]

Guys

I have db2 server on AIX box & have created 7 databases wrt to the data move from cloudscape to db2.Websphere Portal 6.0.1.3 is installed on SOLARIS box & have all these 7 databases catalouged there.

I am now trying to transfer all the data from cloudscape to DB2 when i received this error:

action-add-constraints:

Fri May 23 14:24:20 EDT 2008

java Reading file /global/site/vendor/WAS/WebSphere6/PortalServer/config/DBTransfer/wps/enableConstraints.sql

java Setting database autocommit to:true

java Connected to jdbc:db2://53.231.196.171:12120/AWPSJCRD:returnAlias=0;

java ALTER TABLE CUSTOMIZATION.APPLICATION_ROLE ADD CONSTRAINT FK2230A FOREIGN KEY (PARENT_OID) REFERENCES CUSTOMIZATION.APPLICATION_ROLE (OID) ON DELETE CASCADE

java Error during statement execution!

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

java at com.ibm.db2.jcc.c.fg.e(fg.java:1596)

java at com.ibm.db2.jcc.c.fg.b(fg.java:1160)

java at com.ibm.db2.jcc.b.gb.h(gb.java:217)

java at com.ibm.db2.jcc.b.gb.b(gb.java:46)

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

java at com.ibm.db2.jcc.b.vb.f(vb.java:118)

java at com.ibm.db2.jcc.c.fg.m(fg.java:1155)

java at com.ibm.db2.jcc.c.fg.a(fg.java:1865)

java at com.ibm.db2.jcc.c.fg.e(fg.java:737)

java at com.ibm.db2.jcc.c.fg.execute(fg.java:721)

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

Total time: 25 minutes 43 seconds

Can someone throw some light on this ? What is the SQLCODE & SQLSTATE pointing to?

Regards

Abhi