Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Import Set ISETxxxxx transform stopped due to error: java.lang.NullPointerException

s_w_
Kilo Explorer

Having issues testing a JDBC data source, the transform will occasionally stop at an increment of 10k records (usually stops around 50k, have seen it go up to 160k) with the error:

java.lang.NullPointerException
at com.glide.db.meta.RowBlock.getRowBySlot(RowBlock.java:403)
at com.glide.db.meta.RowBlock.get(RowBlock.java:170)
at com.glide.db.meta.RowList.get(RowList.java:127)
at com.glide.db.meta.Table.rowAt(Table.java:750)
at com.glide.db.meta.Table.getStorage(Table.java:677)
at com.glide.db.meta.TableIterator.getStorageForCurrent(TableIterator.java:123)
at com.glide.db.meta.TableIterator.next(TableIterator.java:56)
at com.glide.script.GlideRecordITable.next(GlideRecordITable.java:391)
at com.glide.script.GlideRecord.next(GlideRecord.java:5950)
at com.glide.db.impex.transformer.Transformer.transformBatch(Transformer.java:133)
at com.glide.db.impex.transformer.Transformer.transform(Transformer.java:76)
at com.glide.system_import_set.ImportSetTransformerImpl.transformEach(ImportSetTransformerImpl.java:239)
at com.glide.system_import_set.ImportSetTransformerImpl.transformAllMaps(ImportSetTransformerImpl.java:91)
at com.glide.system_import_set.ImportSetTransformer.transformAllMaps(ImportSetTransformer.java:61)
at com.glide.system_import_set.ImportSetTransformer.transformAllMaps(ImportSetTransformer.java:48)
at com.snc.automation.ScheduledImportSetJob.runImport(ScheduledImportSetJob.java:55)
at com.snc.automation.ScheduledImportJob.execute(ScheduledImportJob.java:45)
at com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:103)
at com.glide.schedule.JobExecutor.execute(JobExecutor.java:89)
at com.glide.schedule.GlideScheduleWorker.executeJob(GlideScheduleWorker.java:219)
at com.glide.schedule.GlideScheduleWorker.process(GlideScheduleWorker.java:157)
at com.glide.schedule.GlideScheduleWorker.run(GlideScheduleWorker.java:67)

Can't find much about this error anywhere, does anyone have suggestions how to go forward?

1 REPLY 1

Greg75
ServiceNow Employee
ServiceNow Employee

Greetings,

I will need more information on this issue but this could be relative to a known error.

Please review this known error article:

Concurrent Import Set fail to transform rows with coalesce fields value equal to "null" - SCCM 2012v...

Please let me know if you can provide more details on this issue.