TS 6.5
OD 6.2.1
Solaris 9
Oracle 10g
We have decided to upgrade all of our Interwoven suite, TS and OD. So, we started with OD first. The install seemed to go fine and I was able to get our workflows to deploy jsp files. To test the datadeploy aspect, I'm running a deployment fromt he command line. It's not working, throwing an error that seems to point to it being a driver issue. But I did upgrade the driver with the latest ojdbc14.jar from Oracle. Here is the command:
/usr/iw-home/OpenDeployNG/bin/iwodcmd start iw_newsletters_dd -k iwdd=DCR-TO-DB -k ddhome=/usr/iw-home/OpenDeployNG -k filelist=/var/tmp/datadeploy41555.txt -k server=webd1 -k area=//ken-inwdev01.ii-corpnet.com/default/main/ecommerce/WORKAREA/Common/ -k date=2009-09-30 -k val=modify
and the resulting log file error:
ENG: 2009-10-01 12:06:39 EDT GMT-04:00 Begin logfile [/usr/iw-home/OpenDeployNG/log/src.iw_newsletters_dd.DCR-TO-DB.ken-inwdev01.to.database.log] ---------
ENG: 2009-10-01 12:06:39 EDT GMT-04:00 Job ID=m2 Deployment=iw_newsletters_dd
ENG: 2009-10-01 12:06:39 EDT GMT-04:00 DataDeploy Version is 6.2.1.0.0
ENG: 2009-10-01 12:06:39 EDT GMT-04:00 Owner started the deployment is root
ENG: 2009-10-01 12:06:39 EDT GMT-04:00 DD args iwdd="DCR-TO-DB" date="2009-09-30" ddhome="/usr/iw-home/OpenDeployNG" area="//ken-inwdev01.ii-corpnet.com/default/main/ecommerce/WORKAREA/Common/" filelist="/var/tmp/datadeploy41555.txt" server="webd1" val="modify" cfg=/usr/iw-home/OpenDeployNG/conf/iw_newsletters_dd.xml need-result=yes depuuid=66feae90-aea4-11de-98e0-9f22be7578aa leglabel=database
ENG: 2009-10-01 12:06:39 EDT GMT-04:00 Proceed to execute the database deployment
DBD: Deployment : DCR-TO-DB
DBD: Database Vendor set to oracle
DBD: SQL datatype for column PATH is VARCHAR(40)
DBD: SQL datatype for column STATE is VARCHAR(40)
DBD: SQL datatype for column CONTENT_ID is VARCHAR(40)
DBD: SQL datatype for column NEWSLETTER_TYPE is VARCHAR(40)
DBD: SQL datatype for column COUNTRY_CODE is VARCHAR(2)
DBD: SQL datatype for column PUBLISH_DATE is DATE
DBD: SQL datatype for column DESCRIPTION is VARCHAR(250)
DBD: # of columns: 7
DBD: # of primary key columns specified: 1
DBD: # of groups defined in element: 1
DBD: [Thu Oct 01 12:06:39 EDT 2009] Begin executing DCR-TO-DB
DBD: Area VPath://ken-inwdev01.ii-corpnet.com/default/main/ecommerce/WORKAREA/Common/
DBD: Setting up TDbSchemaAgent.
DBD: >>> Loading drivers <<<
DBD: Loading com.informix.jdbc.IfxDriver
DBD: Loading oracle.jdbc.driver.OracleDriver
DBD: ERROR
BD07001:JDBC jar/zip not found in the drivers directory
DBD: ERROR:ERROR: Loading drivers : oracle.jdbc.driver.OracleDriver
DBD: ERROR:ClassNotFoundException: oracle.jdbc.driver.OracleDriver
DBD: ERROR:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at com.interwoven.deploy.cdmain.IWCDClassLoader.loadClass(IWCDClassLoader.java:577)
at com.interwoven.deploy.cdmain.IWCDClassLoader.loadClass(IWCDClassLoader.java:448)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at com.interwoven.dd100.dd.JdbcCheckup.registerDriverWithDriverManager(JdbcCheckup.java:165)
at com.interwoven.dd100.dd.JdbcCheckup.LoadDrivers(JdbcCheckup.java:231)
at com.interwoven.dd100.dd.TDbAgent.(TDbAgent.java:264)
at com.interwoven.dd100.dd.TDbSchemaAgent.(TDbSchemaAgent.java:64)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:514)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:192)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
DBD: Loading com.sybase.jdbc2.jdbc.SybDriver
DBD: Loading COM.ibm.db2.jdbc.net.DB2Driver
DBD: Loading sun.jdbc.odbc.JdbcOdbcDriver
DBD: Assuming TNS name has been specified for "db" attribute.
DBD: url : jdbc
racle
ci8:
@webd1DBD: login : interwoven
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc
racle
ci8:
@webd1...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc
racle
ci8:
@webd1]DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: No suitable driver
DBD: Vendor Error Code: 0
DBD: SQL state: 08001
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.interwoven.dd100.dd.JdbcCheckup.MakeConnection(JdbcCheckup.java:447)
at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:580)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnectionManager.java:78)
at com.interwoven.dd100.dd.TDbAgent.EstablishConnection(TDbAgent.java:550)
at com.interwoven.dd100.dd.TDbAgent.(TDbAgent.java:272)
at com.interwoven.dd100.dd.TDbSchemaAgent.(TDbSchemaAgent.java:64)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:514)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:192)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
DBD: ERROR:Could not connect to [webd1]
DBD: ERROR:Unable to connect to webd1
DBD: ERROR:TDbAgent constructor failed.
DBD: Error occured in TDbSchemaAgent
DBD: Stat for group [IW_NEWSLETTER]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Rollback database [webd1]...
DBD: Deployment[DCR-TO-DB]
DBD: ERROR:TDbSchemaAgent create failure.
DBD: Started : Thu Oct 01 12:06:39 EDT 2009
DBD: Finished: Thu Oct 01 12:06:39 EDT 2009
DBD:
### IWDataDeploy FAILED ###
DBD:
### Sending result ###
ENG: 2009-10-01 12:06:39 EDT GMT-04:00 Database deployment execution returned 1
ENG: 2009-10-01 12:06:39 EDT GMT-04:00 <<< Completed database deployment Invocation>>>
ENG: 2009-10-01 12:06:39 EDT GMT-04:00 Job ID=m2 Deployment leg=database Elapsed Time=171 ms <<<
ENG: 2009-10-01 12:06:39 EDT GMT-04:00 End logfile [/usr/iw-home/OpenDeployNG/log/src.iw_newsletters_dd.DCR-TO-DB.ken-inwdev01.to.database.log]
I'm following the install guide, and don't believe I've missed any steps. We have a support ticket open, but no solution so far. Any ideas? Thanks.
