SCCM connection issue

[Jack62]

Evening folks,

We have just moved our SCCM connection to test and running a test load 20 records fails with an error of Cannot invoke "java.util.Map.keySet()" because "this.fImportSourceFields" is null. This has worked fine in dev. I assume something has not come across in the update set but can work out what. 

Anyone else had this issue?

[Jack62]

Any thoughts on this from anyone?

Thanks

Jack

[BigMikeyVegas]

We tried resetting the password on the data source and rerunning to no avail. (as noted in a previous post)

We then tried restarting the mid-server to no avail.  (as noted in a previous post)

We then looked at the mid-server record on our instance and found 2 mid-server issues. They essentially pointed to revalidating the server. So, from the Related Links, we selected Invalidate, then selected Rekey, then finally selected Validate. We then reran the 20 record load test and it was successful. 

Other options were to update the Service Graph Connector plugin or change the MySQL authntication settings to Legacy.

Hope that this helps

[Nicolas_B]

Hello,

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

After looking at this community message, I tried revalidate the mid, rekey etc but it was not working either.

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.

[Nicolas_B]

Small addition.  It seems that since Washington, ALL SQL Errors of JDBC Data sources are not retrieved anymore and replaced by this message "Cannot invoke "java.util.Map.keySet()" because "this.fImportSourceFields" is null"