Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

problem in migration from wps cloudscape to oracle 9i(Release 2)

0 views
Skip to first unread message

svir...@ggn.hcltech.com

unread,
Jan 28, 2007, 5:15:01 AM1/28/07
to
Hi,


Can anyone let me know what the problem with migration is, when migrating the websphere portal cloudsape databases to Oracle 9i.

The steps is followed:

I created database with the name wmmdb for the databases(release,comm,cust,wmmdb). I created users as releaseusr, communityusr, customizationusr, wmmdbusr for wmmdb database. For all the remaining (jdrdb,fdbkdb,lmdb), I created another database with the name oracle.

The users have been created with sufficient privilages as provided in the document. After that Configuration Wizard has been started for migrating. While in the process of migration of wmmdb(Member Manager data), it showing the errors.

The following log details has been shown in portal-database-transfer.log( I am attaching the log file also)


Transfer Data :: MaxMemory is 512M
[java] [01/28/07 15:18:44.594 IST] Attempting to make connection using: jdbc:oracle:thin:@10.112.77.250:1521:wmmdb :: system :: PASSWORD_REMOVED
[java] [01/28/07 15:18:44.860 IST] Connection successfully made
[java] [01/28/07 15:18:44.860 IST] Attempting to make connection using: jdbc:db2j:wpsdb;create=true :: db2admin :: PASSWORD_REMOVED
[java] [01/28/07 15:18:45.204 IST] Connection successfully made
[java] [01/28/07 15:18:45.204 IST] Transfer started
[java] [01/28/07 15:18:59.938 IST] Transferring table --{ DB2ADMIN.WMMLAADTYP}-- to table --{SYSTEM.WMMLAADTYP }--
[java] [01/28/07 15:19:00.001 IST] error.executing.transfer
[java] java.lang.NullPointerException
[java] at oracle.jdbc.dbaccess.DBData.clearItem(DBData.java:431)
[java] at oracle.jdbc.dbaccess.DBDataSetImpl.clearItem(DBDataSetImpl.java:3528)
[java] at oracle.jdbc.driver.OraclePreparedStatement.clearParameters(OraclePreparedStatement.java:3401)
[java] at com.ibm.wps.config.db.util.RowHelper.updatePreparedStatement(RowHelper.java:211)
[java] at com.ibm.wps.config.db.transfer.DefaultTableHandler.execute(DefaultTableHandler.java:101)
[java] at com.ibm.wps.config.db.transfer.TransferEngine.execute(TransferEngine.java:57)
[java] at com.ibm.wps.config.db.transfer.CmdLineTransfer.execute(CmdLineTransfer.java:93)
[java] at com.ibm.wps.config.db.transfer.CmdLineTransfer.main(CmdLineTransfer.java:43)



Thanks

0 new messages