Summary:
This article troubleshoots an error that occurs when connecting to BI360 in Designer, due to the existence of two folders with different Excel object libraries.
Symptoms:
When a user connects to BI360 in Report Designer, they get the following error message:
There was a problem loading the System Integration Package for this Report.
System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.Office.Interop.Excel._Application.get_Hwnd()
at OneStop.ReportDesigner.ThisAddIn.get_ReportingAddIn()
at OneStop.ReportDesigner.ThisAddIn.get_ReportingApp()
at OneStop.ReportDesigner.Globals.get_DesignerSettings()
at OneStop.ReportDesigner.DesignEnvironment.RefreshMeta(MetaInfo oldInfo, String dataSource, MetaInfoTypes types)
at OneStop.ReportDesigner.DesignEnvironment.RefreshMeta(String dataSource, MetaInfoTypes types)
at OneStop.ReportDesigner.DesignEnvironment.RefreshMeta()
at OneStop.ReportDesigner.Forms.ReportPane.b__6(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
Causes:
This is due to the existence of two folders with different Excel object libraries in CLSID of HKEY_CLASSES_ROOT registry. This could’ve happened on the machine if one version of Excel was replaced by a different one. Because there are now two object libraries, Reporting is unable to connect to the proper one.
Resolution:
To resolve this, please open up the path below and see to it that there are two folders - 1.7 and 1.8 for Excel 2010 and 2013 respectively. Back up the entire registry key and proceed to delete 1.8 folder if you are on Excel 2013 or 1.7 folder if you are on Excel 2010. Excel 14.0 object library is for Excel 2010 and Excel 15.0 object library is for Excel 2013.
Properties:
BI360 Report Designer all version
BI360 Data Warehouse