Question
Elevance Health
US
Last activity: 29 Jun 2022 10:27 EDT
Export to Excel is getting blank screen
Hi Team,
I have report definition and while doing export to excel from the actions button we are getting the blank screen in UAT and Prod where as in Dev and SIT it is working fine.
For out of the box reports it is working fine
Version 8.6
***Edited by Moderator Marije to add Capability tags***
UnitedHealth Group Incorporated
IN
Please share the tracer results. Also you can compare tracer results of prod/UAT and DEV/SIT, That might give some hint here.
Blue Rose Technologies
NL
If this is not working in Prod but working in lower environment then possibility is that the due to large amount of data it might be timing out. Could you please try to debug from the perspective of time taken to run the report. - You can check the alerts when you are running the report. Check the the DB trace and compare the prod and dev db trace.
- Check the elapsed time of report in the data access tab and try to adjust it a bit.
Pegasystems Inc.
GB
@NarendraC7462 please update us if the above suggestions worked.
We have a support article and Support docs Tips for troubleshooting Export to Excel issues and Troubleshooting and Debugging Export to Excel Issues to help with further troubleshooting.
Updated: 29 Jun 2022 9:30 EDT
Elevance Health
US
@NarendraC7462 Solution for this issue is there is a when rule that is restricting the the export to excel based on the production level access. pyBlockUnregisteredRequests.
Capgemini
IN
@NarendraC7462 if excel export is successfull and data in excel it blank then it is because of the huge data in prod and it is taking more time to retrieve the data .please check if properties are optimized or not ...
if excel it self not exporting Change the when condition pyBlockUnregisteredRequests value in prod env