JDBC Connection failed in ISC

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hi All,

While doing testing connection getting following error. how to fix the issue

Error
Error1147Ă—649 77 KB

1 Like
2

Hi Nandana

That means IdentityNow sent a “test connection” job to your Virtual Appliance (VA), but the VA didn’t reply in time (driver didn’t load, can’t reach DB host/port, DNS/SSL hang, or the VA itself can’t talk back to the tenant). It’s a transport/connector issue more than a JDBC-credential issue.

A)Validate the VA path first
B)Check basic network reachability from the VA
3)T urn Logging = DEBUG, retry, then read ccg.log for the exact exception (driver not found, SSL, auth, etc.)

Regards
SathishKumar.N

2 Likes
3

Hello,

If your test connection is getting timed out, following the below troubleshooting steps.

  1. Check whether JDBC URL is correct.
  2. Check whether you have explicitly provided the port to which your Target DB is pointing to.
  3. Check whether through SQL Developer client, the credentials and URL are working as expected.
  4. If above 3 are as expected, then, it could be the connectivity issues from your VA.
  5. Check connectivity from VAs using ping and netstat command to check connection with host and port respectively.
  6. If connections are getting timed out from VAs as well, then, surely its a connectivity issue which could be resolved by the firewall team.
  7. Also, make sure that correct JDBC driver files are imported in your connector. It seems that is not issue in your case but still, its good to check it once.
  8. Also, check whether target DB is supporting the SQL Native Authentication or Windows Authentication & change your configurations of connections accordingly.
2 Likes
4

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.