ServiceNow Troubleshooting · LessonBy Praveen T, ServiceNow Trainer, 9 yrs · Published · ServiceNow · all levels
Import set failures
Diagnose failed and partial imports: staging rows, transform errors, coalesce problems and skipped records.
Quick answer
Diagnose failed and partial imports: staging rows, transform errors, coalesce problems and skipped records.
Key takeaways
- Check import row state, then transform history, then target record
- Empty coalesce values create duplicates
- Reference resolution failures leave blank fields, not errors
- Alert on transform errors, do not rely on someone checking
Follow the row
Every import lands in a staging table row with a state. Open the import set, then the row, then the transform history. That path answers most questions in two minutes without guessing.
Common causes
Four issues cover the majority of failures.
- Coalesce field empty in the source, which creates instead of updates
- Reference field cannot resolve the incoming value, so the field ends up empty
- Date format mismatch between the source and the instance format
- Mandatory field on the target table blocking insert, visible in the transform log
Making failures visible
Silent partial imports are the dangerous ones. Add an onComplete transform script that counts errors and raises an event, then notify the integration owner. A daily import that quietly stopped three weeks ago is a data quality incident waiting to happen.
Practice challenge
+0 XPStreak ×0
Question 1 of 2
What causes duplicate target records on every run?
Frequently asked questions
Where do I see why a row did not transform?
The transform history and the import set row error message. Both are on the import set record.
Should we delete old import sets?
Yes. Schedule cleanup, staging tables grow quickly and slow the instance.