KB426626:In MicroStrategy Command Manager 10.7, exporting results to Excel generates an empty Excel file

Quality Engineer, Senior • MicroStrategy

The issue described in this document has been classified as a defect by MicroStrategy. The issue occurs in MicroStrategy Command Manager 10.7. A code fix is available in current releases. A workaround is also provided in this document.

SUMMARY:
The issue described in this document has been classified as a defect by Strategy. The issue occurs in Strategy Command Manager 10.7. A code fix is available in current releases. A workaround is also provided in this document.
SYMPTOM:
In Strategy Command Manager, users can export the results of a script execution to an Excel file. In Strategy Command Manager 10.7, users may notice that the size of the Excel file generated is 0 KB. If users try to open the Excel file, they will see the following message:


<File Name>.xls is locked for editing by 'another user'.

Open 'Read-Only' or click 'Notify' to open read-only and receive notification when the document is no longer in use.

If users click on "Read Only", they will see the following message:


The file you are trying to open '<File Name>.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?

If users click on "Yes" to proceed and open the file, they will notice that the file is empty.
CAUSE:
This is an identified defect in Strategy Command Manager 10.7.
ACTION:
This issue has been addressed in Strategy 10.11. Upgrade to this version to take advantage of the fix.
WORKAROUND:
In Command Manager, go to File > Export Results > to Excel. In the Save window, change the File type from "XLS Files (*.xls)" to "CSV Files (*.csv)". The CSV file will successfully be generated with data.
KB426626

Comment

0 comments

Details

Knowledge Article

Published:

July 10, 2017

Last Updated:

December 4, 2018

The file you are trying to open '<File Name>.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?