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 JANUARY 27, 2017

Applies to:

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

Symptoms

[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



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