Database transfer to Oracle fails during ACTION-TRANSFER-JCR
Problem
The database transfer to Oracle fails during the ACTION-TRANSFER-JCR sub-task. The following error is captured in the ConfigTrace.log:
[Java] 15:05:22.944 com.ibm.wps.config.db.transfer.TransferDatabase
Process Main
[Java] Adding DB Item 6 icmadmin. " Icmstresourcemgr "(Columns)
To work queue.
[Java] 15:05:23.012
Com.ibm.wps.config.db.transfer.TransferDatabaseTable
Createpreparedstatement Main
[Java] java.lang.ClassCastException:General Exception caught while
Processing this column
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabaseRow.updatePreparedStateme
NT (transferdatabaserow.java:440)
[Java] INSERT into Icmadm. Icmstresourcemgr
(Rmcode,rmplatform,userid,changed,rmflags,tokenduration,domainid,rmuseri
D,rmpassword,rmname,inetaddr,currentversion,cacheobjsizelimit) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabaseRow.writeDatabaseRow (Tran
sferdatabaserow.java:569)
[Java] 15:05:23.012
Com.ibm.wps.config.db.transfer.TransferDatabaseTable
Transferdatabasetable Main
[Java] Transferring table--{Icmstresourcemgr}--
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabaseTable.populateDatabaseRow
(transferdatabasetable.java:188)
[Java] 15:05:23.016
Com.ibm.wps.config.db.transfer.TransferDatabaseRow
Updatepreparedstatement Main
[Java] ERROR--Original Type is:timestamp:93
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabaseTable.transferDatabaseTab
Le (transferdatabasetable.java:166)
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabase.process (TransferDatabase
. java:400)
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabase.initiate (Transferdatabas
e.java:167)
[Java] 15:05:23.017
Com.ibm.wps.config.db.transfer.TransferDatabaseRow
Updatepreparedstatement Main
[Java] ERROR--Value is 2005-07-21 17:50:25.315 (class
Java.sql.Timestamp)
[Java] 15:05:23.017
Com.ibm.wps.config.db.transfer.TransferDatabaseRow
Updatepreparedstatement Main
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabase.main (Transferdatabase.ja
va:458)
[Java] Exception in thread "main" Java.lang.Error
[Java] ERROR--New Type Is:timestamp (6): 1111
[Java] 15:05:23.018
Com.ibm.wps.config.db.transfer.TransferDatabaseRow
Updatepreparedstatement Main
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabaseTable.populateDatabaseRow
(transferdatabasetable.java:200)
[Java] ERROR--Column name:changed
[Java] 15:05:23.018
Com.ibm.wps.config.db.transfer.TransferDatabaseTable Populatedatabaserow
Main
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabaseTable.transferDatabaseTab
Le (transferdatabasetable.java:166)
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabase.process (TransferDatabase
. java:400)
[Java] ERROR 1288--Transferring data of table
--icmstresourcemgr--FAILED
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabase.initiate (Transferdatabas
e.java:167)
[Java] at
Com.ibm.wps.config.db.transfer.TransferDatabase.main (Transferdatabase.ja
va:458)
Target FINISHED:ACTION-TRANSFER-JCR
Target finished:database-transfer-jcr-populate-oracle
Target finished:action-database-transfer-jcr-populate
Target FINISHED:DATABASE-TRANSFER-JCR
Target finished:action-transfer-content-management
Target Finished:database-transfer
Build failed
cause
This issue is caused by a Oracle driver mismatch between The Oracle server and the local JDBC driver.
Solution
The drivers. Same and May is the same level, but something has caused a driver mismatch. You should contacts Oracle support for more information.
In some cases, the issue has been resolved by downloading a new Oracle 32-bit driver The Oracle Web site and REPL Ace the existing drivers.