Import sets not working

[Earl L]

I'm trying to run an import set on my instance and they are consistently failing with the following error.

2017-03-21 08:22:54 03-21 08:22 1m ago

Error

sysID cannot be null: java.lang.IllegalArgumentException: sysID cannot be null: com.glide.worker.ProgressMonitor.<init>(ProgressMonitor.java:21) com.glide.processors.ImportProcessor.waitForStartup(ImportProcessor.java:203) com.glide.processors.ImportProcessor.outputMessage(ImportProcessor.java:179) com.glide.processors.ImportProcessor.process(ImportProcessor.java:79) com.glide.processors.AProcessor.runProcessor(AProcessor.java:424) com.glide.processors.AProcessor.processTransaction(AProcessor.java:195) com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:178) com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:167) com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:49) com.glide.sys.Transaction.run(Transaction.java:1976) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) java.lang.Thread.run(Thread.java:745)

com.glide.ui.ServletErrorListener

This is a new import set and the underlying import set table has not been created yet (verified by searching in system tables). This is a very simple two record import and I've tried it in both Excel and CSV formats without any luck. I can attach a copy of the file I'm using for the import if that would be helpful.

My instance is dev17716.service-now.com and it's running Istanbul.

Is there any way that someone from SN can look at this to see if there are some kind of internal errors causing the instance to not be able to generate sys IDs? I really have no idea what's going on with this but it is getting pretty frustrating trying every combination of tricks I can come up with to try to make this work, only to have them all fail.

[sergiu_panaite]

Hi Earl,

I see no transform map on your data source, have you followed WIki?

http://wiki.servicenow.com/index.php?title=Import_Sets#gsc.tab=0

[Earl L]

I was under the impression you don't need a transform map to perform an import. I've done lots of import sets, but didn't realize that having a transform map prior to doing an import was a requirement.

In fact, I seem to recall doing some imports without a transform map and then being asked if I wanted to create one? Am I just making this up?

Earl

[sergiu_panaite]

You;re right, it's not required to import in staging table. Let me have another look.

[Earl L]

Can you login to my instance and try it for yourself?