OBIEE 11g: Language Mismatch At Oracle.BIOffice Error While Trying To Open Any View (Doc ID 1676610.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.6.12 and later
Information in this document applies to any platform.

Symptoms

When attempting to run BI Office it fails. This happens for few users and all the reports.  Connection works, but when trying to open any report/view the below error is shown in Excel:

"Failed to insert Oracle BI View

Object reference not set to an instance of an object."


 Also, the following error is written in the logs:

Error while naming sheet : Langauge mismatch at Oracle.BIOffice.BIExcel.BIObjectCollectionExcel.AddSheet(Int32 viewType) at Oracle.BIOffice.BIExcel.BIObjectCollectionExcel.AddBIReportView(CatalogReportView hostView, CatalogReport report)

Failed to insert report view Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)) at Oracle.BIOffice.BIExcel.BIObjectCollectionExcel.AddBIReportView(CatalogReportView hostView, CatalogReport report) at Oracle.BIOffice.Common.UI.UIBICatalog.InsertReportView(CatalogReportView reportView)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms