Multilevel pivot report fails to export as PDF from report, or as PDF in scheduled report

[EK28]

Hi Community

when trying to export a multilevel report on demand in old or new report UI, the error message "Export failed" appears:

I have added this report to a scheduled report, it generates a pdf according to system logs, but in fact there is no attachment when the email is sent and received:

I found this using search but it does not solve my issue. 

https://www.servicenow.com/community/developer-forum/multilevel-pivot-export-pdf/td-p/2615778 

Any idea how to go about this? 

Can I check the size of the report pdf somewhere, but I couldn't imagine it being more than 25MB. 

Thanks a bunch in advance!

[james598kee]

---

@EK28 wrote:

Hi Community

when trying to export a multilevel report on demand in old or new report UI, the error message "Export failed" appears:

I have added this report to a scheduled report, it generates a pdf according to system logs, but in fact there is no attachment when the email is sent and received:

I found this using search but it does not solve my issue. 

https://www.servicenow.com/community/developer-forum/multilevel-pivot-export-pdf/td-p/2615778 

Any idea how to go about this? 

Can I check the size of the report pdf somewhere, but I couldn't imagine it being more than 25MB. 

Thanks a bunch in advance!

---

Hello,
It sounds like you're encountering an issue with exporting multilevel reports in ServiceNow. Have you checked the instance logs for more details on the error? Additionally, verifying the report size might help identify if it exceeds the export limit.

Best Regards,
James Keen

[Mark Manders]

I had this a while back and it was due to an issue with the WEBKIT HTML to PDF plugin. After repairing it, it worked again. If it doesn't, check on the system logs as well. They may give an indication to what is the issue. Is it really not creating the PDF or is it simply not sending it.

[EK28]

Hi Mark, it was in fact an issue with the WEBKIT HTML to PDF plugin.

To put context to anybody encountering this issue, I am sharing the steps from ServiceNow support here. 

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

1. The "WebKit HTML to PDF" plugin needs to be repaired using plugin store link,

2. the above KB Article contains a fix script fix_enable_oauth_access.xml to import

3. activate the OAuth Application Registry record for the "WebKit HTML to PDF"

After that, both scheduled and on demand PDF export of pivot tables are possible.