Export to Excel of a Checksheet using the options in the tools menu doesnot 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] ExportToExcel::Export() - exception thrown during export EXCEPTION OCCURRED:COMException Microsoft Excel cannot access the file 'C:\Users\pgoodfellow\Documents\38945 - ROUTE\INSP\CC PIPELINE\NIGHTS\D0FA8080'. There are several possible reasons:
• The file name orpath does not exist.• The file is being used by another program.• The workbook you are trying to save has the same name as a currently open workbook. at Microsoft.Office.Interop.Excel._Workbook.SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPassword, Object ReadOnlyRecommended, Object CreateBackup, XlSaveAsAccessMode AccessMode, Object ConflictResolution, Object AddToMru, Object TextCodepage, Object TextVisualLayout, Object Local) at Ivara.Client.Callbacks.ExportToExcel.Export(WindowBase wb, IvaraDataSet dataSet, String sFileName, Boolean bLaunch)
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