Error 'Cannot invoke "java.util.Map.keySet()" because "this.fImportSourceFields" is null' in SN

[Nikhil63]

Hi All,

i am getting the 'Cannot invoke "java.util.Map.keySet()" because "this.fImportSourceFields" is null' error in the data source.

Could you please help me with this? I am not sure if it is something related to SN or not and what I need to do here.

[Steffen Hansen]

Was seeing the same issue as OP, and while OPs might be something else, in our case, it was a permission issue.

1. Getting a domain account to connect to the SCCM database through the Graph connector is a no go. Nothing I have learned in my 20 years a sys.admin helped. Everything works when connecting through SSMS or ODBC connections in Windows. Just not through the Graph connector.

2. Changing the MID Server Service account to run as a domain user and then using Integrated Authentication do work.

3. I ended up creating a local account on the SQL server itself. Since it's very much read only, it can be shared between the different ServiceNow instances (incl. my PDI)

BR, Steffen

[Nicolas_B]

Hello,

I was having also the error "Cannot invoke "java.util.Map.keySet()" because "this.fImportSourceFields" is null"

After looking at other community messages, I tried revalidate the mid, rekey etc but it was not working.

Finally, after looking at the MID server logs, I could see an SQL error due to a table used in the SQL query not available for my SCCM user.  Usually, these errors are visible in the ServiceNow console and in the progress worker but here strangely, it was not visible.   

Fixing the SQL query fixed the issue for me.

[Patrik Karlsson]

We had the same error, turns out to be missing rule in the firewall from the MID server to the database.

[Camila Oliveira]

Hi Guys

I managed to resolve it by updatind my script with the DBA team, and the pemissions of the account used for connection were also redone

[Community Alums]

can you please tell me, how you resolved this issue in detail?