loading large xml file goes to 2% and dies. How can I increase memory for xml importing?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-08-2017 06:40 PM
loading large xml file goes to 2% and dies. How can I increase memory for xml importing?
- Labels:
-
Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-09-2017 06:13 AM
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.
|
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-09-2017 06:13 AM
Is the transaction just stopped? If so, there's a good chance that it's timing out due to transaction quotas (http://wiki.servicenow.com/index.php?title=Transaction_Quotas#gsc.tab=0).
you can check by going to https://instance/syslog_cancellation_list.do?sysparm_query=sys_created_onONToday%40javascript%3Ags.d... and seeing if your transaction is in there.
I've uploaded similar sized files in the past without running into these issues.
If it's still not working, then you might have to look at exporting the data in smaller chunks on the source system
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-09-2017 06:22 AM
I tried that, thank you, but it is not canceled or timed out. It goes to 0% or 1% loading then the screen turns gray with a sad face.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-09-2017 08:41 AM
I ended up exporting data in smaller chunks.
