Issue with Importing 1 Lakh Incident Records from Demo2 to Demo5

[TEJAS]

Hi All,

I have two ServiceNow demo instances – Demo2 and Demo5.

• In Demo2, I have around 1,00,000 records in the Incident table.

• I exported all the incident records successfully.

• But while importing them into Demo5, only 10,000 records are getting imported.

I would like to import all the 1 lakh records, not just 10,000.

Has anyone faced this issue before?

• Is there a limitation while importing/exporting large number of records?

• Do I need to split the data into batches, or is there a configuration that allows importing all records at once?

• What would be the best practice for migrating such large datasets between instances?

Any guidance would be greatly appreciated.

Thanks in advance!

[Bhuvan]

@TEJAS  

Follow below knowledge article to change system property glide.import_template.row_limit 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0754235

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@TEJAS  

Issue

Import excel template, the 'wait for it' option only exports 10,000 records. This is the default feature

Resolution

The default size can be enhanced by using the easy import system property:

glide.import_template.row_limit to respective value

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[TEJAS]

Hi @Bhuvan  ,
I searched  for this property glide.import_template.row but it is not there in my instance so should i create a new property or can you elaborate please 

[Bhuvan · Accepted solution]

@TEJAS  

Yes, that is correct. You can add a new property and set the value above the number of records to import, for example if you are importing 100000 records set the value as 110000 and save the property. Try to import the records again and it should work. Loading would take time, so wait for it to complete.

As per community guidelines, you can accept more than one answer as accepted solution. If my responses helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan