Identity Governance Generic CSV Connector import fails

Document ID : KB000111069
Last Modified Date : 14/08/2018
Show Technical Document Details
Issue:
Trying to import a  "Generic Feed (Standard CSV)" Connector fails with a NullPointerException.  The eurekify.log shows:

09:27:55,818 ERROR [stderr] (import-connector thread-1) java.lang.NullPointerException
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.iteration.resource.ResourceDatabaseSchemaCsvImporter.initSchema(ResourceDatabaseSchemaCsvImporter.java:42)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.iteration.AbstractCsvImporter.<init>(AbstractCsvImporter.java:46)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.iteration.AbstractCsvImporter.<init>(AbstractCsvImporter.java:31)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.iteration.resource.ResourceDatabaseSchemaCsvImporter.<init>(ResourceDatabaseSchemaCsvImporter.java:32)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.iteration.configuration.ConfigurationCreator.createConfig(ConfigurationCreator.java:59)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.actions.batch.importFromCsv.ImportFromCSV.createConfiguration(ImportFromCSV.java:221)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.actions.batch.importFromCsv.ImportFromCSV.importData(ImportFromCSV.java:181)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.actions.batch.importFromCsv.ImportFromCSV.executeActionImpl(ImportFromCSV.java:168)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.actions.AbstractAction.executeAction(AbstractAction.java:24)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.batch.connectors.imports.impl.CSVThinImport.importData(CSVThinImport.java:115)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at com.eurekify.batch.connectors.AbstractImportCommand.run(AbstractImportCommand.java:27)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
09:27:55,818 ERROR [stderr] (import-connector thread-1)     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
09:27:55,819 ERROR [stderr] (import-connector thread-1)     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
09:27:55,819 ERROR [stderr] (import-connector thread-1)     at java.lang.Thread.run(Thread.java:745)
Resolution:
Ensure that all files used for the import are comma delimited.  If any are tab delimited for example, instead of comma delimited, this exception could occur.