nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DataDeploy deployment Error

cute_guy

I am trying to do a deployment from my teamsite server to the database server.While doing so i get the error...It says problem with the driver . So i have replaced the driver in /opt/opendeploy6.0/AdminServer/odadmin/drivers/classes12.zip with the one that comes with the oracle installation.Even then the same error is thrown.

DAS:[Sat May 14 03:58:25 PDT 2005] Begin executing master-edition
DAS Smiley Frustrated

etting up TDbSchemaAgent.
DAS:url : jdbc Smiley Surprised

racle:thin:@targetserver:1521 Smiley Frustrated

ID
DAS:login : db_user
DAS:login timeout=3
DAS:Connecting to the database...
DAS:Try connecting using jdbc Smiley Surprised

racle:thin:@targetserver:1521 Smiley Frustrated

ID...
DAS:Connect attempt Failed:Reason:7
java.lang.ArrayIndexOutOfBoundsException: 7
at oracle.security.o3logon.C0.r(C0)
at oracle.security.o3logon.C0.l(C0)
at oracle.security.o3logon.C1.c(C1)
at oracle.security.o3logon.O3LoginClientHelper.getEPasswd(O3LoginClientHelper)
at oracle.jdbc.ttc7.O3log.<init>(O3log.java:289)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:251)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:246)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.interwoven.dd100.dd.JdbcCheckup.MakeConnection(JdbcCheckup.java:400)
at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:539)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnectionManager.java:78)
at com.interwoven.dd100.dd.TDbAgent.EstablishConnection(TDbAgent.java:548)
at com.interwoven.dd100.dd.TDbAgent.<init>(TDbAgent.java:271)
at com.interwoven.dd100.dd.TDbSchemaAgent.<init>(TDbSchemaAgent.java:63)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:513)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:586)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:191)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForMultiDeployment(TConsumerManager.java:149)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:129)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:97)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:512)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:202)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:127)
DAS:Attempt to connect using jdbc Smiley Surprised

racle:thin:@targetserver:1521 Smiley Frustrated

ID failed.
DAS:ERROR:Unable to connect to targetserver:1521 Smiley Frustrated

ID
DAS:ERROR:TDbAgent constructor failed.
DAS:Error occured in TDbSchemaAgent
DAS:ERROR:TDbSchemaAgent create failure.
DAS:ERROR:Consumer setup for deployment [edition] FAILED
DAS Smiley Frustrated

tarted : Sat May 14 03:58:25 PDT 2005
DAS:Finished: Sat May 14 03:58:25 PDT 2005
DAS:
### IWDataDeploy FAILED ###

DAS:
### Sending result ###

ENG: 2005-05-14 03:58:25 PDT GMT-07:00 Database deployment execution returned 1

ENG: 2005-05-14 03:58:25 PDT GMT-07:00 <<< Completed database deployment Invocation>>>

I am using OD 6.0 with TS 6.5
Any help would be appreciated

Find more posts tagged with

Comments

jed

Don't drivers go here:
$ODHOME/OpenDeployNG/drivers

Also, can you connect from the ts server to the db server using other means? For example:

perl DBI

or

telnet dbhost 1521

or

sqlplus

--
Jed Michnowicz
jedm@sun.com
Content Management Engineer
Sun Microsystems

cute_guy

The DB server is getting connected using sqlplus and also telnet dbhost 1521.....

fiquebem

Were you able to resolve the problem? We're experiencing the same difficulty. I'm able to telnet to the Oracle port alright, but I get:

DAS: Try connecting using jdbc Smiley Surprised

racle:thin:@myhost:1526:datdep01...
DAS: Connect attempt Failed:Reason:7
java.lang.ArrayIndexOutOfBoundsException: 7

Environment: OD 6.0.2. + Patch 1573 on Solaris 9. Also, TS 6.5 SP1.

S.

fiquebem

I stopped OD and installed classes12.zip (downloaded from http://otn.oracle.com) into OpenDeployNG/drivers. I restarted OD and re-tried my deployment. It worked like a charm.

S.

cute_guy

I too did the same , downloaded the oracle driver from the oracle website and copied to <od-home>/drivers directory.
I believe the driver(classes12.zip) that come with the Opendeploy installation is very old.

Regards,
Ganesh

Migrateduser

Hi,

I am trying to run the database deployments to Oracle Database and I am getting following error message.
My environment is TeamSite 6.5, OD 6.0.2. I Just installed TS 6.5 and trying out the DD.

Deployment : xml-to-db
DAS: Database Vendor set to oracle
DAS: SQL datatype for column PKTIMESTAMP is VARCHAR2(100)
DAS: SQL datatype for column START_DATE is DATE
DAS: SQL datatype for column EXP_DATE is DATE
DAS: SQL datatype for column DESCRIPTION is VARCHAR2(1000)
DAS: SQL datatype for column CATEGORY is VARCHAR2(255)
DAS: SQL datatype for column PRIORITY is NUMBER(25)
DAS: SQL datatype for column ARCH_FLAG is CHAR(1)
DAS: # of columns: 7
DAS: # of primary key columns specified: 1
DAS: WARNING:Assuming group name as the table name for [NEWS].
DAS: # of groups defined in <dbschema> element: 1
DAS: [Mon Dec 05 16:06:56 GMT+00:00 2005] Begin executing xml-to-db
DAS: Area VPath:/iwmnt/ART/main/ESC/WORKAREA/load
DAS: Setting up TDbSchemaAgent.
DAS: >>> Loading drivers <<<
DAS: Assuming TNS name has been specified for "db" attribute.
DAS: url : jdbc Smiley Surprised

racle

ci8:@ecom9i
DAS: login : essdev1
DAS: login timeout=3
DAS: Connecting to the database...
DAS: Try connecting using jdbc Smiley Surprised

racle

ci8:@ecom9i...
DAS: Link failure
DAS: Attempt to connect using jdbc Smiley Surprised

racle

ci8:@ecom9i failed.
DAS: You must fix the problem before proceeding, because Oracle specific data types are being used.
DAS: ERROR:Unable to connect to ecom9i
DAS: ERROR:TDbAgent constructor failed.
DAS: Error occured in TDbSchemaAgent

I downloaded the latest classes12.zip from Oracle site as suggested, but still I am getting same error message. Any Help?

Thanks

Migrateduser

What version of oracle.... starting in OD602SP1, we started shipping ojdbc14.jar instead of classes12.zip.

Mariam

Migrateduser

Prior to the release that Mariam is referring to, there were/are some issues with the drivers that ship with DD and Oracle 9i and later. I didn't have the specific problem you're having but a similar one -- after replacing DD's classes12.zip with an updated copy (from Oracle), life was good again.

Environments:
(1,2) TS6.5, TS6.5SP1 on W2K3
(3) Vignette V7 Portal on Solaris 9

motlnt

Hi All,
I faced similar issue yesterday while deploying to a new DB instance.
Updating the classe12.zip resolved it.

Regards,
JM

RajatChopra

Hi, I am recieving the same Link failure Error.

What should i do to resolve this? I have tried using the classes12.zip, but it hasnt worked. Do i have to replace the ojdbc14.jar as well? Should i get an updated one from the Oracle website?

using - OD 6.1

Log is showing as follows

ENG: 2006-04-24 15:05:37 PDT GMT-07:00 Begin logfile [D:\Programs\Interwoven\OpenDeployNG\log\Web\Articles\src.Article_xml_dd.basearea.uslaxcms06.to.database.log] ---------
ENG: 2006-04-24 15:05:37 PDT GMT-07:00 Job ID=m1 Deployment=Web\Articles\Article_xml_dd
ENG: 2006-04-24 15:05:37 PDT GMT-07:00 DataDeploy Version is 6.1.0.0.0
ENG: 2006-04-24 15:05:37 PDT GMT-07:00 Owner started the deployment is HERBALIFECORP\rajatc
ENG: 2006-04-24 15:05:37 PDT GMT-07:00 DD args iwdd="basearea" cfg=D:\Programs\Interwoven\OpenDeployNG\conf\Web\Articles\Article_xml_dd.xml need-result=yes depuuid=75aeee90-d3de-11da-9002-eabd3aba9e5c leglabel=database

ENG: 2006-04-24 15:05:37 PDT GMT-07:00 Proceed to execute the database deployment

ENG: 2006-04-24 15:05:37 PDT GMT-07:00 Exec'ing [cmd.exe /E:1900 /C

\Programs\Interwoven\OpenDeployNG\lib\iwddexec iwdd="basearea" cfg=D:\Programs\Interwoven\OpenDeployNG\conf\Web\Articles\Article_xml_dd.xml need-result=yes depuuid=75aeee90-d3de-11da-9002-eabd3aba9e5c leglabel=database svrlogfile=D:\Programs\Interwoven\OpenDeployNG\log\Web\Articles\src.Article_xml_dd.basearea.uslaxcms06.to.database.log doEvtrpt=yes execProcess=yes]
DBD: Server log file

\Programs\Interwoven\OpenDeployNG\log\Web\Articles\src.Article_xml_dd.basearea.uslaxcms06.to.database.log
DBD: DD module version: 6.1.0.0.0 Build 56030 Interwoven 20060325
DBD: In Thread: Thread[OpenDeploy Main,5,main]
DBD: Run in Thread: Thread[DDThread,5,main]
DBD: Database Vendor set to oracle
DBD: SQL datatype for column ecmID is VARCHAR(255)
DBD: SQL datatype for column Title is VARCHAR(255)
DBD: SQL datatype for column Locale is VARCHAR(255)
DBD: SQL datatype for column Category is VARCHAR(255)
DBD: SQL datatype for column Teaser is VARCHAR(255)
DBD: SQL datatype for column BodyCopy is VARCHAR(255)
DBD: SQL datatype for column Author_Name is VARCHAR(255)
DBD: SQL datatype for column Med_Img_Caption is VARCHAR(255)
DBD: SQL datatype for column LRG_IMG_CAPTION is VARCHAR(255)
DBD: SQL datatype for column TeaserFlag is VARCHAR(255)
DBD: SQL datatype for column Thumb_Img is VARCHAR(255)
DBD: SQL datatype for column Medium_Img is VARCHAR(255)
DBD: SQL datatype for column Large_Img is VARCHAR(255)
DBD: SQL datatype for column sort_Order is VARCHAR(255)
DBD: # of columns: 14
DBD: # of primary key columns specified: 2
DBD: # of groups defined in element: 1
DBD: [Mon Apr 24 15:05:38 PDT 2006] Begin executing basearea
DBD: Begin Set up the publisher thread
DBD: End Set up the publisher thread
DBD: Deployment Publisher thread running...
DBD: Area VPath:/default/main/US/Articles/en/WORKAREA/Publisher/
DBD: Setting up TDbSchemaSynchronizer.
DBD: >>> Loading drivers <<<
DBD: Loading com.informix.jdbc.IfxDriver
DBD: Loading oracle.jdbc.driver.OracleDriver
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 Smiley Surprised

racle

ci8:@ATGQA
DBD: login : hlatgcore
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc Smiley Surprised

racle

ci8:@ATGQA...
DBD: Link failure
DBD: Attempt to connect using jdbc Smiley Surprised

racle

ci8:@ATGQA failed.
DBD: You must fix the problem before proceeding, because Oracle specific data types are being used.
DBD: ERROR:Unable to connect to ATGQA
DBD: ERROR:TDbAgent constructor failed.
DBD: Error occured in TDbSchemaSynchronizer
DBD: ERROR:TDbSchemaSynchronizer create failure.
DBD: Stat for group [Article]:
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 [ATGQA]...
DBD: Deployment[basearea]
DBD: Started : Mon Apr 24 15:05:38 PDT 2006
DBD: Shutting down DDD PublisherThread
DBD: Finished: Mon Apr 24 15:05:38 PDT 2006
ENG: 2006-04-24 15:05:38 PDT GMT-07:00 nullDBD: 2006-04-24 15:05:37 PDT GMT+01:00 OpenDeploy install location

\Programs\Interwoven\OpenDeployNG
DBD: 2006-04-24 15:05:37 PDT GMT+01:00 OpenDeploy install location

\Programs\Interwoven\OpenDeployNG
DD Home :

\Programs\Interwoven\OpenDeployNG
DBD: 2006-04-24 15:05:38 PDT GMT+01:00 args[0]:iwdd=basearea
DBD: 2006-04-24 15:05:38 PDT GMT+01:00 args[1]:cfg=D:\Programs\Interwoven\OpenDeployNG\conf\Web\Articles\Article_xml_dd.xml
DBD: 2006-04-24 15:05:38 PDT GMT+01:00 args[2]:need-result=yes
DBD: 2006-04-24 15:05:38 PDT GMT+01:00 args[3]:depuuid=75aeee90-d3de-11da-9002-eabd3aba9e5c
DBD: 2006-04-24 15:05:38 PDT GMT+01:00 args[4]:leglabel=database
DBD: 2006-04-24 15:05:38 PDT GMT+01:00 args[5]:svrlogfile=D:\Programs\Interwoven\OpenDeployNG\log\Web\Articles\src.Article_xml_dd.basearea.uslaxcms06.to.database.log
DBD: 2006-04-24 15:05:38 PDT GMT+01:00 args[6]:doEvtrpt=yes
DBD: 2006-04-24 15:05:38 PDT GMT+01:00 args[7]:execProcess=yes
DBD: 2006-04-24 15:05:38 PDT GMT+01:00 numArgs=8
Database Deployment error state: false

ENG: 2006-04-24 15:05:38 PDT GMT-07:00 Database deployment execution returned -1

ENG: 2006-04-24 15:05:38 PDT GMT-07:00 <<< Completed database deployment Invocation>>>

ENG: 2006-04-24 15:05:38 PDT GMT-07:00 Manifest path is

/Programs/Interwoven/OpenDeployNG/log/Web/Articles/src.Article_xml_dd.basearea.uslaxcms06.to.database.log.mf

ENG: 2006-04-24 15:05:38 PDT GMT-07:00 Got Manifest object com.interwoven.od.adapter.delivery.base.IWODManifest@19c7c21

ENG: 2006-04-24 15:05:38 PDT GMT-07:00 fHasFailedItems is set to true

ENG: 2006-04-24 15:05:38 PDT GMT-07:00 Published leg event depUuid=[75aeee90-d3de-11da-9002-eabd3aba9e5c] legLabel=[database] nextUuid=[null] nextDep=[null]
ENG: 2006-04-24 15:05:38 PDT GMT-07:00 Job ID=m1 Deployment leg=database Elapsed Time=1375 ms <<<
ENG: 2006-04-24 15:05:38 PDT GMT-07:00 End logfile [D:\Programs\Interwoven\OpenDeployNG\log\Web\Articles\src.Article_xml_dd.basearea.uslaxcms06.to.database.log]

Help Appreciated,

Rajat