Remedy - Server - Error opening an Excel/PowerPoint file from a BIRT scheduled report shows the message:""The file format and extension of '{filename}' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it...."

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


    APPLIES TO:

    Remedy AR System Server v.19.08



    PROBLEM:

    A scheduled BIRT report is created in Remedy to run a report and send via e-mail on an Excel or PowerPoint file.
    The Report Scheduler, as expected sends an e-mail with the Excel/PowerPoint attached with the expected report.

    When trying to open the received Excel/PowerPoint report file the following message is displayed:
    .............
    "The file format and extension of '{filename}' 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?"
    .............


    Example of an Excel report file:

         User-added image


    Example of a PowerPoint report file:

         User-added image


    CAUSE:

    Defect: SW00565191


    SOLUTION:

    This behavior has been identified as a defect:
    ................
    SW00565191 - PPT and Excel received files from scheduled birt reports seem to be corrupted. 
    ................

    and it will be addressed on a future release.

    Note, the main reason for this message is the way the current BIRT build creates the emitter for these file types being set with XML format but adding the Excel and PowerPoint extensions in the final file.
    When opening the file(s) in MS Office Suite they are not identified as native Excel/PowerPoint files therefore the message is displayed.
    Note that the file(s) are not corrupted but just being created by an unexpected format.

    As a workaround you can ignore this message and in most cases the file will open.
    Note, that in some scenarios with MS Office Suite 2016 the file will still not opening despite accepting the message due to the restriction policies set by the organization in the MS Office Trust Center.
    Link: https://docs.microsoft.com/en-us/office/troubleshoot/settings/file-blocked-in-office
    In most cases single users are unable to change this in which case for scheduled reports if facing this message and it is not possible to open the file(s) it will need to wait until it is fixed in the Remedy code line.

    Note:
    There is a similar scenario receiving the same message when running the BIRT reports from the Remedy application and save them in Excel file format.
    This was identified also as a defect for the MidTier side: SW00563163

    So, to be sure:

    1- If running BIRT reports from the application directly and exporting them into an Excel file and receiving this message this is a MidTier defect: SW00563163
    There is a Hot Fix for the MidTier to address this behavior.
    The Hot Fix is located in the FTP link below:
    ftp://ftp.bmc.com/pub/ARRecommendedFixes/Midtier/19.08/

    2- If having scheduled BIRT reports which then is being handled by the AR Server and the reports are being sent as an attachment and receiving the reported messages when opening them, this is reported in the defect mentioned on this article: SW00565191

     


    Article Number:

    000184469


    Article Type:

    Solutions to a Product Problem



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