Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Login failed -online rpd
Obiee ver: 12.2.1.2
When I try to login to online rpd through BI12c Administrator tool , it throws the error:
So , as a test , i tried to download the rpd through datamodel download command , and it ask for the same rpd password , and it was successful , the rpd was downloaded successfully as the same rpd password was taken .
Isn't the datamodel download command and the BI Admin tool uses the same protocol ? I though it should go through obis server .
Can some one throw his/her view on this ?
Thanks
Answers
-
I think obips and not obis
0 -
819624 wrote:So , as a test , i tried to download the rpd through datamodel download command , and it ask for the same rpd password , and it was successful , the rpd was downloaded successfully as the same rpd password was taken .
The datamodel command to download the RPD doesn't ask for an existing RPD password, it asks to set a RPD password. In OBIEE 12c the RPD on the server doesn't have a password, you need a valid account (username/password) and it's enough. Once you download a copy of the RPD locally you are requested to set a password because for offline editing you will not be required to login to OBIEE with a valid user, therefore the RPD is protected just by a password.
0 -
sawserver.log
[OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: 1762ywm5b-8hfb-43e4-b31d-887d6c116545f-00000007,0:2495:38:1] [tid: 284677029024] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Odbc driver returned an error (SQLDriverConnectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
(HY000)
State: HY000. Code: 73025. [nQSError: 73025] The Oracle BI Server is currently unavailable for queries. Please contact your System Administrator to report the failure. (HY000)[[
File:checkauthentication.cpp
Line:1607
Location:
saw.securitysubsystem.checkauthentication.runimpl
saw.threadpool.asynclogon
saw.threads
[OBIPS] [ERROR:16] [] [saw.soap.makesession] [ecid: 1716uemd5b-4hjddb-43e4-b31d-75d6c116545f-00000007,0:2495:38] [tid: 339307734600] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Authentication error. Invalid session ID or session expired (session ID ending with '')
An error occurred during authentication. Try again later or contact your system administrator.
Odbc driver returned an error (SQLDriverConnectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
(HY000)
State: HY000. Code: 73025. [nQSError: 73025] The Oracle BI Server is currently unavailable for queries. Please contact your System Administrator to report the failure. (HY000)[[
File:soapservicesimpl.cpp
Line:207
Location:
saw.soap.makesession
saw.soap.sessionrequesthandler
saw.SOAP
saw.httpserver.request.soaprequest
saw.rpc.server.responder
saw.rpc.server
saw.rpc.server.handleConnection
saw.rpc.server.dispatch
saw.threadpool.socketrpcserver
saw.threads
0 -
thanks .. the username/password works fine while downloading the rpd through datamodel command , but when I use the same username / password to login to analytics or open the rpd online it throws the error.
0 -
Can you check your services to see if all components are up and running? The error indicates an issue with the obis BI Server component.
0 -
Yes its up. Infact all services are up.
0 -
Thanks .. I've one question ..
I downloaded the rpd on the server like this ..
./datamodel.sh downloadrpd -O /uat/SampeTest.rpd -U obadmin -SI ssi
it asked for obadmin password and the rpd password(as you said , it's for offline use , and that any pwd can be set at this time)
The rpd downloaded successfully .So it means the obadmin password supplied was correct .
Now when I try to open the rpd online through bi admin tool , it asks for password of "obadmin" and when I enter the same password , it throws the above error which I posted originally .
So why it does take the password in cli and not through BI Admin tool.
Also I get the error the error "The specified credentials could not be authenticated" for user obadmin when I try to login to analytics dashboard url
============
My finding from obis logs . sawlogs
[OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: 1716375b-4ffb-43e4-b31d-75d6c116545f-00000007,0:2495:38:1] [tid: 2846689024] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Odbc driver returned an error (SQLDriverConnectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
(HY000)
State: HY000. Code: 73025. [nQSError: 73025] The Oracle BI Server is currently unavailable for queries. Please contact your System Administrator to report the failure. (HY000)[[
File:checkauthentication.cpp
Line:1607
Location:
saw.securitysubsystem.checkauthentication.runimpl
saw.threadpool.asynclogon
saw.threads
[OBIPS] [ERROR:16] [] [saw.soap.makesession] [ecid: 1716375b-4ffb-43e4-b31d-75d6c116545f-00000007,0:2495:38] [tid: 3393017600] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Authentication error. Invalid session ID or session expired (session ID ending with '')
An error occurred during authentication. Try again later or contact your system administrator.
Odbc driver returned an error (SQLDriverConnectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
(HY000)
State: HY000. Code: 73025. [nQSError: 73025] The Oracle BI Server is currently unavailable for queries. Please contact your System Administrator to report the failure. (HY000)[[
File:soapservicesimpl.cpp
Line:207
Location:
saw.soap.makesession
saw.soap.sessionrequesthandler
saw.SOAP
saw.httpserver.request.soaprequest
saw.rpc.server.responder
saw.rpc.server
saw.rpc.server.handleConnection
saw.rpc.server.dispatch
saw.threadpool.socketrpcserver
saw.threads
=====================
Error 52 : iam.test.abc.com:567; socket closed >
####<Error> <Default> <obieeserver-hostnane> <bi_server1> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <c6734663-2ba9-4b6b-8c1f-5bf177786e03-00000502> <1562463182796> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <OBI-SEC-00500
oracle.bi.security.centaurus.IdentityStoreProviderException: [BISecurity] [oracle.bi.security.centaurus.IDSIdentityStoreProvider::getUserProfile] [OBI-SEC-00500] Identity store provider error
at oracle.bi.security.centaurus.IDSIdentityStoreProvider.getUserProfile(IDSIdentityStoreProvider.java:469)
at oracle.bi.security.centaurus.AuthenticateUserAction.run(AuthenticateUserAction.java:79)
at oracle.bi.security.centaurus.CentaurusService.authenticateUser(CentaurusService.java:103)
at oracle.bi.security.login.LoginServlet.doPost(LoginServlet.java:96)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.bi.security.filter.BISecurityFilter.handleAnonymousSubject(BISecurityFilter.java:187)
at oracle.bi.security.filter.BISecurityFilter.doFilter(BISecurityFilter.java:158)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.wls.filter.SSOSessionSynchronizationFilter.doFilter(SSOSessionSynchronizationFilter.java:294)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3683)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3649)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2433)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2281)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2259)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1692)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1652)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused By: oracle.igf.ids.IDSException: Operations error: entity= op=find mesg=
at oracle.igf.ids.arisid.ArisIdServiceManager.findEntity(ArisIdServiceManager.java:1712)
at oracle.igf.ids.UserManager.searchUser(UserManager.java:184)
at oracle.bi.security.centaurus.IDSIdentityStoreProvider.getUserProfile(IDSIdentityStoreProvider.java:456)
at oracle.bi.security.centaurus.AuthenticateUserAction.run(AuthenticateUserAction.java:79)
at oracle.bi.security.centaurus.CentaurusService.authenticateUser(CentaurusService.java:103)
at oracle.bi.security.login.LoginServlet.doPost(LoginServlet.java:96)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.bi.security.filter.BISecurityFilter.handleAnonymousSubject(BISecurityFilter.java:187)
at oracle.bi.security.filter.BISecurityFilter.doFilter(BISecurityFilter.java:158)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.wls.filter.SSOSessionSynchronizationFilter.doFilter(SSOSessionSynchronizationFilter.java:294)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3683)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3649)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2433)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2281)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2259)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1692)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1652)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused By: oracle.igf.ids.arisid.ArisIdConnectionException: Operations error: entity= op=find mesg= AdditionalInfo: LDAP Error 52 : am.test.abc.com:567; socket closed
============
If this is something to do with ldap then why the password went through successfully in cli . Or is it that online -BI Admin tool/ Analytics Url uses different authentication and cli uses different ..but then I am using the same user obadmin.
Your expert comments please!
.
0 -
I figured out ..obadmin actually and for that matter the the user supplied in cli is a weblogic user ..so it has nothing to do with the user supplied through online rpd and anaytics url . In my case i have obadmin user as ldap as well as weblogic user..
So now that part is clear , it's fair to say logically that it looks like the issue is with the ldap authentication , but then wny the error in fisrt screen shot say , cannot connect Bi server instance.
0 -
Issue resolved . the problem lies with LDAP. Thanks again for all your time , valuable inputs .
0 -
I'm facing the same problem when trying top open the rpd online. How did you resolve the LDAP issue?
Thanks!
0
