Unable to export reports into a CSV file or Excel file

Unable to export reports into a CSV file or Excel file

Issue:

Unable to export User Console reports into a CSV file or Excel file.

The file is downloaded as default.html instead of a CSV report or Excel file report.

blalvani_0-1583366702896.png

 

Root Cause:

This is an issue with the Pentaho java script in 8.3.0.6

This issue has been reported on 5.5.26 and 5.5.27.

Permanent fix:

This issue will be fixed in 5.5.28 patch.

Workaround: (Can be applied on 5.5.26 OR 5.5.27)

Please find the attached: BDNA_32431_ExportReport.zip

The workaround updates the Pentaho version to 8.3.0.5 which does not cause the issue.


You can apply the patch by following the steps below:


0. We strongly recommend to manually back up everything on the following path as a pre step:
%NORMALIZE_BI_HOME%\Solution\system\analyzer


NOTE : '%NORMALIZE_BI_HOME%' is the location where user console installed.

Steps:
1. Download 'BDNA_32431_ExportReport.zip' and copy it to the host where User Console is installed.
Example: c:\BDNA_32431_ExportReport.zip
2. Close all web browsers, run the following commands in command prompt with administrators rights.
Every command must run after the previous one succeeds:
cd %NORMALIZE_BI_HOME%\bin
Updater.exe /file=c:\BDNA_32431_ExportReport.zip
3. Once above is successful, Login to user console and try to export report.

 

NOTE : The workaround is only for CSV file and Excel file exports. The workaround does not fix the PDF export.

Labels (4)
Was this article helpful? Yes No
No ratings
Comments

Will this be resolved in 5.5.28?

Version history
Revision #:
2 of 2
Last update:
‎Mar 05, 2020 03:34 PM
Updated by:
 
Contributors