logo

NJP

Integration Hub ETL - Error handling

Import · Oct 13, 2021 · article

Error #1 : Error loading partial payload

Cause #1: Import set staging table is not present

Cause #2: Data source is not able to load data to import set staging table.

Solution : Try running test load on data source outside of ETL.

Error #2 : No data found for an import set : sys_id of import set

Cause #1: Import set staging table doesnt have good data.

Solution : Delete that import set record along with the import set rows for that staging table and retry.

Use below script to get the import set details

var grImport = new GlideRecord('sys_import_set');grImport.get('23ff496f874b7810fc692f49cebb35c5');

gs.print(grImport.number);

View original source

https://www.servicenow.com/community/now-platform-blog/integration-hub-etl-error-handling/ba-p/2287259