|
Home > Archive > WebSphere Portal Server > May 2007 > Cloudscape to DB2 migration issue
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cloudscape to DB2 migration issue
|
|
|
| Hi all.
I'm trying to convert our V5.1.0.2 Portal from Cloudscape to DB2 and I'm having
problems. Although it still seems to work (although the WPSConfig file says
"BUILD FAILED" upon hitting this point) I can't be sure that everything is
working properly.
Here is a short snippet of the log file showing the error:
action-create-jcrrm-tables:
[echo] Calling cmcfgdbu to create RM tables
[echo] In case of error, refer to /db2/WebSphere/PortalServer/log/jcr51.log
iseries-switch-ccsid-specific:
iseries-switch-ccsid-default:
iseries-switch-ccsid:
iseries-switch-ccsid-original:
create-jcr-dynamic-tables:
action-create-jcr-dynamic-tables-db2:
action-process-jcr-dynamic-ddl:
[echo] DbDriver = COM.ibm.db2.jdbc.app.DB2Driver
[echo] JcrDbUrl = jdbc:db2:jcr51
[echo] JcrDbUser = db2inst1
[echo] DbLibrary = /home/db2inst1/sqllib/java/db2java.zip
iseries-switch-ccsid-specific:
iseries-switch-ccsid-default:
iseries-switch-ccsid:
[java] Connected to jdbc:db2:jcr51
[java] Reading file /db2/WebSphere/PortalServer/jcr/config/dynamic/icmjcrdb2.ddl
[java] ALTER TABLE ICMUT01082001 ADD ATTR0000001131 VARCHAR(252)
[java] Error during statement execution!
[java] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0204N "DB2INST1.ICMUT01082001" is an undefined name. SQLSTATE=42704
[java] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator. throw_SQLException(SQLExceptionGenerator
.java:281)
[java] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator. throw_SQLException(SQLExceptionGenerator
.java:218)
[java] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:448)
[java] at COM.ibm.db2.jdbc.app.DB2Statement.execute2(DB2Statement.java:840)
[java] at COM.ibm.db2.jdbc.app.DB2Statement.execute(DB2Statement.java:515)
[java] at com.ibm.wps.config.SqlProcessor.process(SqlProcessor.java:450)
[java] at com.ibm.wps.config.SqlProcessor.main(SqlProcessor.java:631)
[java] (ErrCode=-204, SqlState=42S02)
Any help would be greatly appreciated.
All the best,
| |
|
| > Hi all.
>
> I'm trying to convert our V5.1.0.2 Portal from
> Cloudscape to DB2 and I'm having
> problems. Although it still seems to work (although
> the WPSConfig file says
> "BUILD FAILED" upon hitting this point) I can't be
> sure that everything is
> working properly.
>
> Here is a short snippet of the log file showing the
> error:
>
> action-create-jcrrm-tables:
> [echo] Calling cmcfgdbu to create RM tables
> [echo] In case of error, refer to
> er to /db2/WebSphere/PortalServer/log/jcr51.log
>
> iseries-switch-ccsid-specific:
>
> iseries-switch-ccsid-default:
>
> iseries-switch-ccsid:
>
> iseries-switch-ccsid-original:
>
> create-jcr-dynamic-tables:
>
> action-create-jcr-dynamic-tables-db2:
>
> action-process-jcr-dynamic-ddl:
> [echo] DbDriver =
> ver = COM.ibm.db2.jdbc.app.DB2Driver
> [echo] JcrDbUrl = jdbc:db2:jcr51
> [echo] JcrDbUser = db2inst1
> [echo] DbLibrary =
> ary = /home/db2inst1/sqllib/java/db2java.zip
>
> iseries-switch-ccsid-specific:
>
> iseries-switch-ccsid-default:
>
> iseries-switch-ccsid:
> [java] Connected to jdbc:db2:jcr51
> [java] Reading file
> file
> /db2/WebSphere/PortalServer/jcr/config/dynamic/icmjcrd
> b2.ddl
> [java] ALTER TABLE ICMUT01082001 ADD
> 1 ADD ATTR0000001131 VARCHAR(252)
>
> [java] Error during statement execution!
> [java] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI
> ][CLI Driver][DB2/6000] SQL0204N
> "DB2INST1.ICMUT01082001" is an undefined name.
> . SQLSTATE=42704
>
> [java] at
> ] at
> COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLEx
> ception(SQLExceptionGenerator.java:281)
> [java] at
> ] at
> COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLEx
> ception(SQLExceptionGenerator.java:218)
> [java] at
> ] at
> COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_retur
> n_code(SQLExceptionGenerator.java:448)
> [java] at
> ] at
> COM.ibm.db2.jdbc.app.DB2Statement.execute2(DB2Statemen
> t.java:840)
> [java] at
> ] at
> COM.ibm.db2.jdbc.app.DB2Statement.execute(DB2Statement
> .java:515)
> [java] at
> ] at
> com.ibm.wps.config.SqlProcessor.process(SqlProcessor.j
> ava:450)
> [java] at
> ] at
> com.ibm.wps.config.SqlProcessor.main(SqlProcessor.java
> :631)
> [java] (ErrCode=-204, SqlState=42S02)
>
> Any help would be greatly appreciated.
>
> All the best,
Hi ..
Did u find any solution for this, because i'm too facing the same problem. Thanks in advance..
|
|
|
|
|