Hi,
I get "Logon Error !" when I connect to OBIEE 11.1.1.7 from Smartview using the URL: http://servername:7001/analytics/jbips
Has anyone else encountered similar problem with Smartview on OBIEE 11.1.1.7? Appreciate if you could share the solution if you managed to resolve this issue.
Below is my environment and error details:
I installed OBIEE 11.1.1.7 (Simple Install) which I downloaded from OTN on Windows 2008 Server R2. I have the default SampleApp Lite application up and running.
I downloaded the BI Desktop Tool - Smartview for MS Office from the BI Homepage and installed Smartview on my Excel 2007 (32 bit) - The version I see on Smartview About menu is: 11.1.2.2.310 (Build 247).
When I Login using system id (weblogic) and password, I get "Login Error" & I get the below stacktrace weblogic console (of course, I am able to login to BI using browser, using with the same credentials):
<Apr 6, 2013 5:47:29 PM SGT> <Error> <HTTP> <BEA-101017> <[ServletContext@766032975[app:jbips module:analytics/jbips path:/analytics/jbips spec-version:2.5 version:11.1.1]] Root cause of ServletException.
javax.servlet.ServletException: oracle.bi.nanserver.fwk.exception.BISvsException: java.io.IOException: oracle.bi.nanserver.fwk.exception.BISvsException: java.io.IOException: javax.xml.stream.XMLStreamException: org.xml.sax.SAXParseException: Content is not allowed in prolog.
at oracle.bi.nanserver.fwk.servlet.as.BIRemotingServlet.handleRequest(BIRemotingServlet.java:79)
at oracle.bi.nanserver.fwk.servlet.BIServlet.doGet(BIServlet.java:78)
at oracle.bi.nanserver.fwk.servlet.BIServlet.doPost(BIServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
Truncated. see log file for complete stacktrace
>
<Apr 6, 2013 5:47:29 PM SGT> <Notice> <Diagnostics> <BEA-320068> <Watch 'UncheckedException' with severity 'Notice' on server 'AdminServer' has triggered at Apr 6, 2013 5:47:29 PM SGT. Notification details:
WatchRuleType: Log
WatchRule: (SEVERITY = 'Error') AND ((MSGID = 'WL-101020') OR (MSGID = 'WL-101017') OR (MSGID = 'WL-000802') OR (MSGID = 'BEA-101020') OR (MSGID = 'BEA-101017') OR (MSGID = 'BEA-000802'))
WatchData: DATE = Apr 6, 2013 5:47:29 PM SGT SERVER = AdminServer MESSAGE = [ServletContext@766032975[app:jbips module:analytics/jbips path:/analytics/jbips spec-version:2.5 version:11.1.1]] Root cause of ServletException.
javax.servlet.ServletException: oracle.bi.nanserver.fwk.exception.BISvsException: java.io.IOException: oracle.bi.nanserver.fwk.exception.BISvsException: java.io.IOException: javax.xml.stream.XMLStreamException: org.xml.sax.SAXParseException: Content is not allowed in prolog.
at oracle.bi.nanserver.fwk.servlet.as.BIRemotingServlet.handleRequest(BIRemotingServlet.java:79)
at oracle.bi.nanserver.fwk.servlet.BIServlet.doGet(BIServlet.java:78)
at oracle.bi.nanserver.fwk.servlet.BIServlet.doPost(BIServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.bi.nanserver.fwk.servlet.cs.BICSServletFilter.doFilter(BICSServletFilter.java:62)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
SUBSYSTEM = HTTP USERID = <WLS Kernel> SEVERITY = Error THREAD = [ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)' MSGID = BEA-101017 MACHINE = demodrive TXID = CONTEXTID = b227e6fabfa44ef8:-377dab32:13dde92deb9:-8000-000000000000071e TIMESTAMP = 1365241649533
WatchAlarmType: AutomaticReset
WatchAlarmResetPeriod: 30000
>
<Apr 6, 2013 5:47:29 PM SGT> <Emergency> <oracle.dfw.incident> <BEA-000000> <incident 6 created with problem key "DFW-99998 [javax.servlet.ServletException][oracle.bi.nanserver.fwk.servlet.as.BIRemotingServlet.handleRequest][jbips]">
<Apr 6, 2013 5:47:34 PM SGT> <Error> <HTTP> <BEA-101017> <[ServletContext@766032975[app:jbips module:analytics/jbips path:/analytics/jbips spec-version:2.5 version:11.1.1]] Root cause of ServletException.
javax.servlet.ServletException: oracle.bi.nanserver.fwk.exception.BISvsException: java.io.IOException: oracle.bi.nanserver.fwk.exception.BISvsException: java.io.IOException: Invalid AMF3 data type: 17
at oracle.bi.nanserver.fwk.servlet.as.BIRemotingServlet.handleRequest(BIRemotingServlet.java:79)
at oracle.bi.nanserver.fwk.servlet.BIServlet.doGet(BIServlet.java:78)
at oracle.bi.nanserver.fwk.servlet.BIServlet.doPost(BIServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
Truncated. see log file for complete stacktrace
>
<Apr 6, 2013 5:47:36 PM SGT> <Error> <HTTP> <BEA-101017> <[ServletContext@766032975[app:jbips module:analytics/jbips path:/analytics/jbips spec-version:2.5 version:11.1.1]] Root cause of ServletException.
javax.servlet.ServletException: oracle.bi.nanserver.fwk.exception.BISvsException: java.io.IOException: oracle.bi.nanserver.fwk.exception.BISvsException: java.io.IOException: javax.xml.stream.XMLStreamException: org.xml.sax.SAXParseException: Content is not allowed in prolog.
at oracle.bi.nanserver.fwk.servlet.as.BIRemotingServlet.handleRequest(BIRemotingServlet.java:79)
at oracle.bi.nanserver.fwk.servlet.BIServlet.doGet(BIServlet.java:78)
at oracle.bi.nanserver.fwk.servlet.BIServlet.doPost(BIServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
Truncated. see log file for complete stacktrace
>
<Apr 6, 2013 5:53:02 PM SGT> <Error> <HTTP> <BEA-101017> <[ServletContext@766032975[app:jbips module:analytics/jbips path:/analytics/jbips spec-version:2.5 version:11.1.1]] Root cause of ServletException.
javax.servlet.ServletException: oracle.bi.nanserver.fwk.exception.BISvsException: java.io.IOException: oracle.bi.nanserver.fwk.exception.BISvsException: java.io.IOException: javax.xml.stream.XMLStreamException: org.xml.sax.SAXParseException: Content is not allowed in prolog.
at oracle.bi.nanserver.fwk.servlet.as.BIRemotingServlet.handleRequest(BIRemotingServlet.java:79)
at oracle.bi.nanserver.fwk.servlet.BIServlet.doGet(BIServlet.java:78)
at oracle.bi.nanserver.fwk.servlet.BIServlet.doPost(BIServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
Truncated. see log file for complete stacktrace
>
Any pointers to resolve this issue is much appreciated.
Thanks in advance,
Sasidha