Import of Excel file fails with error: file is too large to be loaded on this instance

[shimongabai]

Scheduled import for a large excel file is failing.

Error message is:

File /glide/nodes/rttmsdev001_16009/bin/../tmp/ids2151ecbdc556e100d3a2862e2daae3e9.tmp is too large (63660544) to be loaded on this instance

[shimongabai · Accepted solution]

ServiceNow only allows 20% of the available JVM memory to be used for the Excel file upload. Files larger than the maximum allowed cannot be loaded.

The solution is to split the Excel file into multiple smaller files and import them into the same table.

[Cristian6]

Hello,

The property glide.excel.max_memory_percent can help with that.

The maximum amount of memory allowed for Excel imports, as a percentage of the total instance memory. 
Type: integer & Default value: 20 

[sahu_jitendra]

Hi,

I can't see any System Property with "glide.excel.max_memory_percent" in the instance.

[Cory Miller]

I think this is what I am looking for:

glide.db.impex.XMLLoader.max.file.size.mb

Controls the maximum file size allowed when importing an XML file, in megabytes. Attempting to import an XML file larger than this limit results in an error. Warning: Use caution when modifying this property. Uploading a very large XML file may impact performance and can cause an instance outage. Type: integer Default value: 100 Location: System Properties > Import Export