OBIEE 11g - Smartview: Error Refreshing OBIEE Analysis Inserted As Excel Table: "Smart View handled an unknown exception thrown by Microsoft Office" (Doc ID 2065158.1)

Last updated on MAY 01, 2018

Applies to:

Symptoms

• Using:
  • OBIEE 11.1.1.7.150120
  • Excel 2010
  • Smart View 11.1.2.5.210 (build 042)
• Smartview: unable to refresh OBIEE analysis inserted as excel table
• When trying to refresh an OBIEE analysis inserted as an Excel table, Smartview throws the following error:
  • Smart View handled an unknown exception thrown by Microsoft Office.
• The issue can be reproduced at will with the following steps:
  1. 1) create a basic analysis in OBIEE (eg from Sample Sales select the "Per Name Month" object).
  2. 2) in Smartview, insert the analysis created in '1' as "Insert As Excel Table".
  3. 3) add to the newly created xls table an additional column to include a basic test: =IF(A2="September","OK,","KO").
  4. 4) delete all the rows in the table (except the row containing the headers).
  5. 5) refresh the smartview analysis.
  6. 6) an error message is generated: Smart View handled an unknown exception thrown by Microsoft Office.
• LOG FILE: smartviewlog.txt:

[2015-07-09T12:11:04-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Entering QueryConnection:DeSerialize

[2015-07-09T12:11:04-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Existing QueryConnection:DeSerialize

[2015-07-09T12:11:04-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Entering OBIEE:JBIPSServiceManager:Logon

[2015-07-09T12:11:04-00:00] [SVC] [ERROR:1] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] BISvsInvokerBase:OBI-01101 : Invalid user name and/or password

Invalid user name and/or password

  at oracle.bi.ui.cs.fwk.service.BISvsInvokerSync.Invoke(String svs, String method, String version, String pageId, String parentClsName, String accMethodName, Object[] args)

[2015-07-09T12:11:04-00:00] [SVC] [ERROR:1] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] OBIEE:JBIPSServiceManager:Logon failed: Invalid user name and/or password

  at oracle.bi.ui.cs.fwk.exception.BISvsException.ThrowException(Exception cause, ILog log)

  at oracle.bi.ui.cs.fwk.service.BISvsInvokerSync.Invoke(String svs, String method, String version, String pageId, String parentClsName, String accMethodName, Object[] args)

  at oracle.bi.ui.cs.svs.security.SecuritySvs.logon(String p0, String p1, Dictionary`2 p2, SecuritySvsOpts p3)

  at JBIPS.Common.JBIPSServiceManager.Logon(String username, String pwd, Dictionary`2 localeProperty)

[2015-07-09T12:11:04-00:00] [SVC] [TRACE:8] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] JBIPS.Common.JBIPSException: Exception of type 'JBIPS.Common.JBIPSException' was thrown.

  at JBIPS.Common.JBIPSServiceManager.Logon(String username, String pwd, Dictionary`2 localeProperty)

  at JBIPS.CJBIPSProvider.ConnectWithUserPassword(String connectionContext, String username, String pwd, String& sessionID, HttpWebRequest webreq, Boolean ChallengeAttemp)

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Entering OBIEE:JBIPSServiceManager:Logon

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Leaving OBIEE:JBIPSServiceManager:Logon

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Entering OBIEE:JBIPSServiceManager:CheckOfficePrivilege

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Leaving OBIEE:JBIPSServiceManager:CheckOfficePrivilege

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Entering OBIEE:JBIPSServiceManager::GetMetadataObjDefn with Report Path.

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Leaving OBIEE:JBIPSServiceManager::GetMetadataObjDefn with Report Path.

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Entering OBIEE:JBIPSServiceManager::GetMetadataObjDefn with Report Path.

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Leaving OBIEE:JBIPSServiceManager::GetMetadataObjDefn with Report Path.

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Entering OBIEE:JBIPSServiceManager:GetViewModelWithXML

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Leaving OBIEE:JBIPSServiceManager:GetViewModelWithXML

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Entering OBIEE:JBIPSServiceManager:ApplyScroll

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Leaving OBIEE:JBIPSServiceManager:ApplyScroll

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Entering QueryConnection:DeSerialize

[2015-07-09T12:11:08-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Existing QueryConnection:DeSerialize

[2015-07-09T12:11:10-00:00] [SVC] [ERROR:1] [SVC-1] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] Smart View handled an unknown exception thrown by Microsoft Office. [[

FILE: ..\src\com_wrappers\connectivity.cpp

LINE: 6090]]

[2015-07-09T12:11:10-00:00] [SVC] [ERROR:1] [SVC-1] [SVC] [ecid: 00iUGMODVaCFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] COleDispatchException: (error: 800a03ec, code: 0) ] [[

FILE: ..\src\com_wrappers\connectivity.cpp

LINE: 6090]]

[2015-07-09T12:11:32-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iUGMPtgMMFw0zlzo0A3z64zVU1z1YxI0001Qo000000,0] BISvsInvokerBase:Reset Connection: _default_0

• FURTHER INFO
  • - Issue does not occur if the method to delete the rows is replaced by the user dragging to include the data cells, & hitting the delete button on the keyboard. That way all the 10 data cells stay their ogirinal blue colour & the error is not received, the original month data reappears in column A.
  • - Issue does not occur if the extra column has not been added
  • - So, the issue only happens if the combination of the following has taken place: a) adding the extra column AND b) deleting the rows as per steps mentioned

Cause