Login failed -online rpd — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Login failed -online rpd

Received Response
162
Views
12
Comments
User_4NU9S
User_4NU9S Rank 6 - Analytics Lead

Obiee ver: 12.2.1.2

When I try to login to online rpd through BI12c Administrator tool , it throws the error:

pastedImage_0.png

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

«1

Answers

  • User_4NU9S
    User_4NU9S Rank 6 - Analytics Lead

    I think obips and not obis

  • 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.

  • User_4NU9S
    User_4NU9S Rank 6 - Analytics Lead

    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

  • User_4NU9S
    User_4NU9S Rank 6 - Analytics Lead

    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.

  • Joel
    Joel Rank 8 - Analytics Strategist

    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. 

  • User_4NU9S
    User_4NU9S Rank 6 - Analytics Lead

    Yes its up. Infact all services are up.

  • User_4NU9S
    User_4NU9S Rank 6 - Analytics Lead

    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!

    .

  • User_4NU9S
    User_4NU9S Rank 6 - Analytics Lead

    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.

  • User_4NU9S
    User_4NU9S Rank 6 - Analytics Lead

    Issue resolved . the problem lies with LDAP.  Thanks again for all your time , valuable inputs .

  • The_Dutchman
    The_Dutchman Rank 2 - Community Beginner

    I'm facing the same problem when trying top open the rpd online. How did you resolve the LDAP issue?

    Thanks!