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.

[AL Zeehan Uddin]

I am also facing the same issue, nothing working can anyone suggest some concrete solution.
Thanks in advance.

[NDboy]

Hi,

you should check the Import log, you can find much more information there.

[Brian Lancaster]

This was fixed for me by using a SQL account rather then a windows authentication account. It seems there was a Microsoft patch to fix security that broke JDBC because Oracle has not updated java. So you cannot use a AD account.

[mbourla]

I just got that same error.  Turned out it was because I'd got something wrong in the SQL in the data source record.  Basically I copied a couple of new lines from the SQL in one data source to another data source, forgetting that in the first one I was doing a GROUP BY, while in the second one I wasn't.  The two lines did MAX(col1) and MAX(col2), which worked OK when there was a GROUP but obviously is not valid SQL when there isn't a GROUP BY.  

So in my case that error "Cannot invoke "java.util.Map.keySet()" because "this.fImportSourceFields" is null" was about the invalid SQL.  But clearly, from what other people have said, it seems it can indicate a whole range of different issues.

[Nimmagadda]

Mid server rekey fixed the issue for us.