Reports failing when being generated with Excel installed

Expand / Collapse
 

Reports failing when being generated with Excel installed


Article ID: 51258 - Last Review: March 4, 2016

PROBLEM

Reports failing when being generated with Excel installed.


SYMPTOMS

Reports will show in the inbox as failed.


Error     2/2/2016 9:37:42 AM      ReportBase.GenerateReport An exceptionwas encountered while generating the excel report. Excel appears to beinstalled on the machine. The exception was:System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excelcannot access the file 'Program Files (x86)\prairieFyre SoftwareInc\CCM\Websites\CCMWeb\applications\'. There are several possible reasons:

 

• The filename or path does not exist.

• The fileis being used by another program.

• Theworkbook you are trying to save has the same name as a currently open workbook.

   atprairieFyre.Reporting.Client.ExcelReportBuilder.BuildReport()

   atprairieFyre.ReportProcessing.ReportBase.GenerateReport(DataSet ds)       

Info      2/2/2016 9:37:42 AM      ReportBase.SaveReport:  Killed Excel process 13020         

Verbose   2/2/2016 9:37:42 AM      ReportStandard.Generate - Startedgenerating a standard report. : 00:00:01.1811288             

Error     2/2/2016 9:37:42 AM      Report generation failure - Failed togenerating report, error was System.Runtime.InteropServices.COMException(0x800706BE): The remote procedure call failed. (Exception from HRESULT:0x800706BE)

   atMicrosoft.Office.Interop.Excel.ApplicationClass.get_Workbooks()

   atprairieFyre.Reporting.Client.ExcelReportBuilder.Dispose()

   atprairieFyre.ReportProcessing.ReportBase.GenerateReport(DataSet ds)

   atprairieFyre.ReportProcessing.ReportBase.PersistReport(DataSet ds)

   atprairieFyre.ReportProcessing.ReportStandard.Generate()

   atprairieFyre.ReportProcessing.ReportBase.GenerateReportsByPriority(Int32numberToGenerate)  


          

CAUSE

The report will fail due to Excel security.


RESOLUTION

Permission for DCOMs "Microsoft Excel Application" are causing issues. Here are the instructions to follow in order to resolve the issue;

  1. Go to Start > Administrative Tools > Component Services > Expand computers > My computer > DCOM Config.
  2. Find Microsoft Excel Application and Right Click and go to Properties.
  3. Under security set all to customize and then edit each one to add the user you are currently logged into with full access.
  4. Launch Excel to test that the error "cannot use object linking and embedding" is gone.
    Note: Excel may re-configure out of box again and click ok to confirm user and initials.
  5. Once you can launch Excel without config on startup and error, your reports should no longer fail.

APPLIES TO

5.x 6.x 7.x

Keywords: Report failing Access denied DCOM object linking embedding Excel installed sql dataset null REP002



Rate this Article:
     
Tags:

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Friday, March 04, 2016
Last Modified By: dfountaine
Type: ERRDOC
Article not rated yet.
Article has been viewed 6,428 times.
Options