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 JULY 18, 2020
Applies to:
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.150120 and laterInformation in this document applies to any platform.
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) create a basic analysis in OBIEE (eg from Sample Sales select the "Per Name Month" object).
- 2) in Smartview, insert the analysis created in '1' as "Insert As Excel Table".
- 3) add to the newly created xls table an additional column to include a basic test: =IF(A2="September","OK,","KO").
- 4) delete all the rows in the table (except the row containing the headers).
- 5) refresh the smartview analysis.
- 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |