Need help on JDBC Type connection with Oracle Database using Datasources

[divyalakshmi]

Hi All,

I am trying to connect to Oracle DB using JDBC from Data source to pull data from the DB. But I get the  error  as "'Cannot invoke "java.util.Map.keySet()" because "this.fImportSourceFields" is null' "after load and in ECC Queue i get this error. Network error could not establish the connection.  

Can some one help me if this is ServiceNow mid server issue or Port issue? Credentials are fine ,no issues with credentials.

#ITSM #GRC

[Kieran Anson]

Your MID server is unable to communicate with the SQL database, this could be:

There is a firewall / routing policy issue which doesn't allow the MID to connect

The wrong port has been specified 

The database isn't setup to listen to jdbc connections.

An authorised user should logon to the MID server and use command prompt/powershell to perform basic connectivity checks between the two compute devices

[Rachel]

Hi,

I have the similar issue, No firewal restrictions and I have mentioned the right port as well. Is there anything else I can check?

[divyalakshmi · Accepted solution]

I had the firewall issue. After whitelisting the IP's Issue got sorted.