Skip to Content
0

JDBC Channel Connection details not taking effect

May 19, 2017 at 01:59 AM

56

avatar image
Former Member

Hi Experts,

We have been having issues regarding our JDBC receiver since last week with the shortened error below.

Fallback to another registered driver failed: com.sap.aii.adapter.jdbc.sql.jdbctrace.$Proxy3618 returns: The TCP/IP connection to the host <ipAdd>, port 1433 has failed. Error: "connect timed out (local port ***** to address ************ (*************), remote port 1433 to address <ipAdd>). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."..
: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <ipAdd>, port 1433 has failed. Error: "connect timed out (local port ***** to address ************ (*************), remote port 1433 to address <ipAdd>). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

We were advice that the IP address of the DB server have been changed and so we tried to apply the new IP in the connection details of the JDBC channel. After we activate the change and resend the stuck messages it seem to use the old IP.

My question is that is the connection details embedded/contained within the JDBC driver upon installation? I am new to how JDBC integrates so I am suspecting that way. Am I missing something that I need to check? If anyone could provide technical details or steps it would be a great help. Thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Iñaki Vila May 19, 2017 at 06:12 AM
0

Hi Joel,

May be the channel settings are chached, you can try for example to set it inactive and to test if the exception is that the channel is innactive or not, also you can delete and create again.

Regards.

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov May 19, 2017 at 06:51 AM
0

Hi Joel!

You could try to restart java service "XPI Adapter: JDBC".

Regards, Evgeniy.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for the suggestion. Tried it but never worked though.

0
Hari Joshyam May 23, 2017 at 08:47 AM
0

Hello Joel,

The connection details are not embedded in driver.

If the host is changed it is sufficient to update the channel parameters alone. Try to do complete refresh on cache once.

Could you trace the old message what channel is being used and make sure you dont have any duplicate channels configured in the system.

Share
10 |10000 characters needed characters left characters exceeded