Import - JDBC load error Table contains duplicate column names

[maxstnr]

Hello, we have a scheduled data import of type File w/ format CSV and SFTP file retrieval method from our HRIS platform. Recently, the imports have started failing with "JDBC load error Table contains duplicate column names" in the logs. However, there are no duplicate columns on the CSV file, no duplicate fields on the transform tables, or duplicate fields on the destination tables. Weirdly, the scheduled data import has also set itself with the next action on sys_trigger 15 years into the future, even though it's set to run daily. Not sure if related to the duplicate error problem though. Anyone run into this and have any ideas?

[Tanushree Maiti]

Hi @maxstnr 

For 1st issue, If you share the screen shot 

 CSV file with search result no duplicate column found,

field map under transformp map

 fields on the transform tables,

fields on the destination tables

These are the place which can cause the error.

Check this post: Similar issue (2nd one) reported before:

https://www.servicenow.com/community/virtual-agent-forum/issue-with-scheduled-data-import-not-import....