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'

[Ankur Bawiskar]

@chercm 

connectivity issue from mid server then

[chercm]

@Ankur Bawiskar  The sql db is having port 50000 opened 

here is the connection: jdbc:sqlserver://server:50000;selectMethod=cursor;databaseName=name

[Kieran Anson]

Hey,

The key error part is "The login is from an untrusted domain". 

Check with your infrastructure team on the following:

1. Is the MID server domain joined?
2. Is there multiple domains in the customers forest? Does the domain the MID server is bound to, trusted by the domain the SQL server is bound to
3. Is the MID in the DMZ and not domain joined? If this is true, windows authentication can't be used and local credentials are needed. 

[chercm]

@Kieran Anson that server is in the same domain as the sql server and the mid server and the sql are using the same domain . both are on premise server

[chercm]

@Kieran Anson 

here is the connection string: jdbc:sqlserver://server:50000;selectMethod=cursor;databaseName=name