Is there a place or table in ServiceNow that lists all possible error messages for data import

Med99
Tera Contributor

I know about syslog and sys_import_log / sys_import_set_row, but these only show errors that actually occurred during an import. I'm looking for a full list of all possible errors that could  happen during an import in ServiceNow. Is that possible?

2 REPLIES 2

Afrith Shariff
Tera Guru

Hi @Med99 ,

 

No, there is no single table or location in ServiceNow that provides a comprehensive list of all possible error messages for data imports. The error codes and messages you can find are limited to what has actually been triggered during import operations in your instance.

 

Please check the below link for reference

https://www.servicenow.com/community/servicenow-ai-platform-forum/list-of-all-error-code-in-import-s...

 

One thing I found out is the property com.glide.import_set.importlog_level, the details are available in above link.

 

Mark this thread helpful so that it can benifit others.

 

Thanks,

Afrith

M Iftikhar
Mega Sage

@Med99 , No, there isn’t an OOTB table of all possible import errors.
You only get what actually occurred, and the universe of ā€œwhat could happenā€ depends on data, transform maps, and customizations.

Some General Properties available as per documentation

  • glide.import_set.preserve.leading.spaces: Preserves leading spaces in Excel data cells.

    • Type: true | false
    • Default: false
  • glide.import_set_row.dynamically_add_fields: Allows adding new columns to the staging table.

    • Type: true | false
    • Default: true
  • com.glide.loader.verify_target_field_size: Enables dynamic resizing of import set fields.

    • Type: true | false
    • Default: false
  • glide.scheduled_import.stop_on_error: Stops import on error in parent scheduled import.

    • Type: true | false
    • Default: false

CSV Properties

  • com.glide.csv.loader.ignore_non_parseable_lines: Ignores lines with bad data in CSV imports.

    • Type: true | false
    • Default: false
  • com.glide.csv.loader.max_errors_allowed: Maximum lines to ignore before failing.

    • Type: integer
    • Default: 100

Excel Properties

  • glide.excel.multiplier: Memory allocation for Excel imports.

    • Type: integer
    • Default: 8
  • glide.excel.max_memory_percent: Max memory for Excel imports as a percentage.

    • Type: integer
    • Default: 10

Logging Properties

  • com.glide.import_set.importlog_level: Controls log verbosity (INFO, WARNING, ERROR).

    • Type: string
    • Default: INFO
  • glide.import.debug: Enables debug logging for all import processes.

    • Type: true | false
    • Default: false