Data deployment error

Hi All,

I am trying to do datadeploy form Teamsite 6.7.1 to Oracle database, the deployment is giving error, od logs are showing following error:

Exception Massage: IO exception: The Network adapter could not establish the connection
Vendor Error Code: 17002
SQL state: null

When I am trying to telnet the database from my base server it is connecting.

Can anyone suggest some solution.

Thanks in advance.

Regards,
Jitendra

Find more posts tagged with

Comments

Rick Poulin

When checking the connectivity via telnet, are you using exactly the same notation as what you used in your DD config? If your telnet test used IP but your DD mapping uses a domain address that can't be resolved, then that could be your issue... Or perhaps you're running your DB on a non-standard port? If telnet works, then something somewhere is wrong with how you configured DataDeploy to find your DB.

g2svnit

Hi,

I am be able to connect, I used IP address instead of server name in connection string and it worked......
Now but i have different problem, How to access particular schema of the database which my application is using, as there are other schemas also present in the database but i have Write permission on my application schema only....I did not found any way to specify that schema in dd.xml

Please help Smiley Sad

Rick Poulin

Users and schemas are usually synonymous in Oracle.. but if you're doing some weird stuff with it, then maybe try setting your group element in your DD cfg like so:
<group name="MYGROUP" table="SCHEMA.TABLE">

</group>
That's a guess though, I've never personally tried that syntax with DD.