"Link failure" while deploying to DB

Hi all,

TS 6.1 SP1
OD 6.0.2 SP1
Oracle 9.2.0.7

I have the following error while trying to deploy a DCR to our DB.
[ Everything was working until I restarted OD ]

--------------
DBD: Deployment : dcr-to-db
DBD: Database Vendor set to oracle
DBD: SQL datatype for column id is numeric
DBD: SQL datatype for column state is varchar(255)
DBD: SQL datatype for column Path is varchar(255)
DBD: SQL datatype for column idsiti is numeric
DBD: SQL datatype for column idtipicategorie is numeric
DBD: SQL datatype for column priorita is numeric
DBD: SQL datatype for column stato is numeric
DBD: SQL datatype for column keywordsricerca is varchar
DBD: SQL datatype for column keywordsprofilazione is varchar
DBD: SQL datatype for column datainiziopub is date
DBD: SQL datatype for column datafinepub is date
DBD: SQL datatype for column titolo is varchar(2048)
DBD: SQL datatype for column autore is varchar(100)
DBD: SQL datatype for column approvatore is varchar(100)
DBD: # of columns: 14
DBD: # of primary key columns specified: 1
DBD: WARNING:Assuming group name as the table name for [contents].
DBD: SQL datatype for column idcontents is numeric
DBD: SQL datatype for column idservizi is numeric
DBD: # of columns: 2
DBD: Invalid parent-group element/attribute.
DBD: ERROR:Invalid element found
DBD: Invalid parent-group element/attribute.
DBD: ERROR:Invalid element found
DBD: # of primary key columns specified: 1
DBD: WARNING:Assuming group name as the table name for [eventi].
DBD: # of groups defined in element: 2
DBD: [Thu Jul 20 12:07:25 EDT 2006] Begin executing dcr-to-db
DBD: Area VPath:/intl/main/www.spazioperilmedico.it.wlp81/integration/WORKAREA/AdminWorkArea
DBD: Setting up TDbSchemaAgent.
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:@targetServer
DBD: login : loginName
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc Smiley Surprised

racle

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

racle

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

I have dowloaded the lastest driver version ojdbc14.jar from otn.oracle.com.

Any other inputs would be highly appreciated

Thanks,
Mam

Find more posts tagged with

Comments

Bhargav Coca

There is a Error which says that there is an invalid element found. Please check on that, and try running this from the command line. Check your connection to the database.
Thanks

TestReport.rptdesign

TestReport.jpg

Mam

1. the connection to the DB is fine :
---------------
bash-2.03# tnsping targetServer

TNS Ping Utility for Solaris: Version 9.2.0.4.0 - Production on 20-JUL-2006 13:12:58

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/local/home/oracle/app/oracle/product/9.2.0/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 1.2.3.4) (PORT = 1521)) (CONNECT_DATA =(SERVICE_NAME = SID)))
OK (10 msec)
------------------

2. the error you mentioned was here before the connection problem. And we were able to deploy without any issue. But you are right, I'll have the application developer fix it in parallel
Thanks

Mam

We are now using the THIN driver instead of the OCI. It works fine.
We will try to find the origin of the problem with the OCI

Thanks for your help
Mam