none
Modifications made by the repairing process RRS feed

  • Question

  • Hey guys,

    We are having some issues exporting from SSRS to an Excel file. Sometimes we have the message error : 

    We found a problem with some content in 'XYZ.xlsx'. Do you want us to try to recover.

    After the repairing process finished successfully, we are trying to validate which were the modifications applied. However, the log file that is mentioned in the pop up window does not contain any relevant data:

    <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error230440_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\~username\Downloads\XYZ.xlsx'</summary><additionalInfo><info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info></additionalInfo></recoveryLog>

    Question: Is there a way to know which data was fixed during the repairing process? We have compared the data exported to the Excel file with the one obtained in the SQL query and everything seems exactly the same. 

    Appreciate any help with this.

    Regards,

    Monday, March 19, 2018 9:38 PM

All replies

  • Hey guys,

    We are having some issues exporting from SSRS to an Excel file. Sometimes we have the message error : 

    We found a problem with some content in 'XYZ.xlsx'. Do you want us to try to recover.

    After the repairing process finished successfully, we are trying to validate which were the modifications applied. However, the log file that is mentioned in the pop up window does not contain any relevant data:

    <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error230440_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\~username\Downloads\XYZ.xlsx'</summary><additionalInfo><info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info></additionalInfo></recoveryLog>

    An interesting fact here, is that if we open the file that contains the error and after the repairing process you save it (same of different file) the size of the Excel decreases up to 5 MB less than the original exported file meaning that something changes in the process.

    Question: Is there a way to know which data was fixed during the repairing process? We have compared the data exported to the Excel file with the one obtained in the SQL query and everything seems exactly the same. 

    Appreciate any help with this.

    Regards,

    Monday, March 19, 2018 9:57 PM
  • Hello FranciscoGarcia.BioClinica,

    >>Is there a way to know which data was fixed during the repairing process?

    Excel Object model does not provide such function. Repairing process could not only recovering data, but also fix format. Not all repairing process will fix data. I would suggest you check how to avoid exporting corrupted excel file from SSRS so you do not need fix it.

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, March 20, 2018 1:43 AM
  • The file is not actually corrupted.  It can be opened by an earlier version of Excel without any error messages.  It seems to us that this is related to Excel 2016 and O365 as they are the offending versions.

    Hope this helps...

    Majickmann

    Wednesday, July 31, 2019 5:57 PM