We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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

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.