When we upgraded to Washington DC, the import of SCCM data stopped working. We are still using the legacy plugin. We are receiving the following error:
Cannot invoke "java.util.Map.keySet()" because "this.fImportSourceFields" is null
From what I've read, this message is returned for any SQL error encountered. I did a test load of 20 records on one of the data sources and saw the following in the import log:
I have asked the database and network folks to verify that everything is set up correctly and that the mid server can connect to the SCCM database using the SQL credentials that are defined in ServiceNow. I am told that is all configured correctly and that the credentials are valid.
We are using SQL authentication to connect to the SCCM database. Our mid server is in the DMZ. It can’t use integrated authentication to connect to our internal databases because our DMZ server isn’t connected to active directory in order to leverage windows authentication.
Is SQL authentication still a valid option here? I haven't run across anything in the documentation that indicates it is not.
At one point, I installed the ServiceGraph Connector for SCCM in our development instance, set up a data source and did a test load of 20 records. I received the same error that we are receiving in our production instance with the legacy plugin. We have since cloned production to development so I need to install the replacement plugin in development again.
Any suggestions on how to troubleshoot this would be greatly appreciated. We would like to get this working in production again before we upgrade to the replacement plugin.
Thank you!
