Remedy Mid Tier Web reports export problems after upgrade to 19.02 - Remedy AR System Server

Version 1
    Share This:

    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



    PROBLEM:


    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.
      
       
    • 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 warnings do NOT occur with files generated in Mid Tier 18.05 or in earlier version.  
    Word export is OK 

     


    CAUSE:

    SW00563140


    SOLUTION:

    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.   

    As all Mid Tier hotfixes are cumulative, please monitor  ftp://ftp.bmc.com/pub/ARRecommendedFixes/Midtier/  for the latest hotfix.


    Article Number:

    000171275


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles