The CreatorCon Call for Content is officially open! Get started here.

Issue with large Excel from Data Visualization (18,000+ records) – getting error PDF in Export

DP_3105
Tera Contributor

3 weeks ago

Hi Community,

I’m facing an issue while exporting a report on Email using Data Visualization in Excel format from ServiceNow. The report has more than 18,000 records, but instead of downloading an Excel file, it generates a PDF with the following error:

"We were unable to generate the report due to a server error. null"

Has anyone faced this issue before? Is there a configuration/limitation on the number of rows that can be exported to Excel, or any workaround to successfully export large reports?

Thanks in advance for your help!

0 Helpfuls
  • 618 Views
4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

3 weeks ago

@DP_3105 

18k record is small count.

Did you try to clear instance cache using cache.do and then logout and login again and then test?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

DP_3105
Tera Contributor
In response to Ankur Bawiskar

3 weeks ago

So I have found that the issue is related to file type so when I am selecting Excel(.xls) then this issue is occurring but for Excel(.xlsx) it is working fine. But in our production instance we have only two options available which are PDF and Excel. This Excel option gives the file in Excel(.xls) format is it possible to change its format ?

DP_3105_0-1757942466915.pngDP_3105_1-1757942614223.png

 

 

 

 

 

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron

3 weeks ago

Hi @DP_3105 

It should work. It might be a cache issue, or possibly related to what table you're trying—there may be some redundancy involved.

 

Try to break the data in chunk and test once.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Dhana3
Kilo Sage

Sunday

Hi @DP_3105 ,

 

This seems to be a cache issue. have you tried clearing the cache and trying again?

 

regards,

Dhanashree