search cancel

Export generates empty .xlsx file with Web Viewer 14.0

book

Article ID: 201869

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/Introduction

When trying to export a TEXT report to Excel, it is failing.  After clicking export Web Viewer generates a 0KB (empty) .xlsx file and when opening the file Excel says the file is corrupted.

 

Cause

The format for export was not specified in the ConfigFile.cfg so it defaults to OOXML. The OOXML format is the Office Open format which is a compressed file.  In order to compress the file Web Viewer needs to use temporary files. A temporary file is created with the user's permission and the STC does not have access to write to the file.

Environment

Release : 14.0

Component : CA Output Management Web Viewer

Resolution

Apply SO13705 INCORRECT SECURITY CONTEXT USED
As the fix includes an update to the ConfigFile.cfg file, backup the current ConfigFile.cfg just in case there are any problems with the update.
See Additional information below.

Workaround: Set EXPORT_FORMAT to XML in the ConfigFile.cfg file:

// Specify the file format used when exporting reports. Available options:
//  OOXML - (default) Office Open XML                                     
//  XML - legacy Microsoft Office XML                                     
// See user documentation for details about each option.                   

EXPORT_FORMAT = "XML";

Additional Information

NOTE: SO14380 has a pre-req for SO13705.  Note SO14380 also pre-reqs SO13818 which changes the name of the war file that gets deployed from MTC-ContentViewer.war to web-viewer.war (see the SO13818 holddata).

.