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

[chercm]

unable to import from SQL server on the midserver . firewall connectivity is ok. i am using xandu. 

any idea how to fix this ?

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

[Community Alums]

Hi @chercm ,

The first thing i would do is check the MID server logs.

he MID server logs can be retrieved directly on the instance. To collect the logs via the instance:

1. Navigate to the MID server record of interest, MID Server > Servers
2. Click on link "Grab MID logs, files and thread dump" 
3. In the ecc_queue we can see output records for topic SystemCommand and source "grabLog"
4. Related list "Agent Logs" and "Agent Files" will be populated with the uploaded files by the MID server

or simply on your script  use ms.log().

I would also check your JDBC Credentials that you would have setup as part of Guided Setup.

[chercm]

@Community Alums @Ankur Bawiskar 

here is the error  :

MID Server reported error: SQLState: null
java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'id '. ClientConnectionId:501525fc-c218-4fcf-85f3-1a8fb6f10927

 when we use windows authentication : 

MID Server reported error: SQLState: null
java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. ClientConnectionId:c0525279-27ce-48d7-afce-4b9f9aad7e97
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)

[Ankur Bawiskar]

@chercm 

the error clearly says connection unsuccessful.

Did you verify that?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[chercm]

@Ankur Bawiskar i tried to use SQL management studio and i used that user id that was granted permission on the db and was able to connect but not from mid server