Product(s):	APM Implementation and Performance Management
	Version(s):	N\A
	Environment:	N\A
	Area:	N/A
	Subarea:	N\A

Problem

Export to Excel of a Checksheet using the options in the tools menu does
not complete. It just churns away for an inordinate amount of time.  Eventually the export failed after 35 minutes.

Log entries include:

Ivara.Client.Callbacks.ExportToExcel [7] ExportToExcel::FillData - Could not set name ranged for row:...

EXCEPTION OCCURRED:COMException Exception from HRESULT: 0x800A03EC

Error  Ivara.Client.Callbacks.ExportToExcel [7] Exp
ortToExcel::Export() - exception thrown during export EXCEPTION OCCURRED:COMException Microsoft Excel cannot access the file 'C:\Use
rs\pgoodfellow\Documents\38945 - ROUTE\INSP\CC PIPELINE\NIGHTS\D0FA8080'. There are several possible reasons:

• The file name or
path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a cur
rently open workbook.    at Microsoft.Office.Interop.Excel._Workbook.SaveAs(Object Filename, Object FileFormat, Object Password, Obj
ect WriteResPassword, Object ReadOnlyRecommended, Object CreateBackup, XlSaveAsAccessMode AccessMode, Object ConflictResolution, Obj
ect AddToMru, Object TextCodepage, Object TextVisualLayout, Object Local)
   at Ivara.Client.Callbacks.ExportToExcel.Export(WindowB
ase wb, IvaraDataSet dataSet, String sFileName, Boolean bLaunch)

Solution

The problem comes from the Measurement Device column on the export configuration (Readings configuration on the indicator reading) having it's "Enable pick from a dropdown list" set.  (Open Configuration column, go to the Export to Excel tab, the Dropdown sub tab.) 
If this bool is DISABLED, the export is quick.  This can be done if the customer doesn't use Measurement devices.  (Need to customize that configuration and disable bool, or remove column etc.)

Core problem fixed in 7.5

 

Original Author:

Giselle Crawford