This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified. PRODUCT:
Remedy AR System Server COMPONENT:
AR System Mid Tier APPLIES TO:
The file format and extension, report issue, file could be corrupted or unsafe. Unless you trust its source, export throws an error;excel format,excel report ,export a BIRT, BIRT report,excel format, column in excel report
When using Mid Tier 19.02 Web reports exported to other formats are displaying several problems
- When you export a Web (BIRT) report to excel and then open the generated XLS file in Microsoft Excel, it displays a warning message.
The file format and extension of <reportname> don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?'
- Powerpoint (PPT) export also throws an error and the export cannot be opened.
The selected file does not appear to be a valid Microsoft PowerPoint file. It might be a file created by a different program.Try double-clicking the file in Windows Explorer to see if another program will open it. If PowerPoint opens again when you double-click the file in Windows Explorer, it is possible that the file is not a PowerPoint file but that its extension was renamed to be that of a registered PowerPoint file type (such as .ppt, .pptx, .pps, .ppsx, .pptx, .pot, or .potx) but the file is not a PowerPoint file.To determine which program can open the file, try any of the following:Contact the original author (if known) to find out which program was used to create this file. Then rename the file with the correct extension so that it can be opened by that program.Try opening the file in other programs.If you, or someone you know, are very knowledgeable about software, examine the file header in a text editor to determine which program can read the file.Another possibility is that the file was damaged during transfer from another computer. Try transferring the file again.The file might have become corrupted. If you have a backup copy of the file, use it. It is not possible repair a corrupted file.
This warnings do NOT occur with files generated in Mid Tier 18.05 or in earlier version. Word export is OK
- The other problem is that the export to PPTX and DOCX happen without a file extension and one has to add them manually. The problem is easily reproduced by using an OOTB report, like in my test where I used the "All Problem Investigations by Coordinator Group" report.
This is a defect arising from a change in the BIRT components used for reporting and incorporated into the Mid Tier 19.02 installation.. Defect SW00563140 has been addressed in the Nov 12 2019 hotfix against Midtier 1902 patch 1 and 1908. Article Number:
As all Mid Tier hotfixes are cumulative, please monitor ftp://ftp.bmc.com/pub/ARRecommendedFixes/Midtier/ for the latest hotfix.
000171275 Article Type:
Solutions to a Product Problem