14 Replies Latest reply on May 24, 2017 9:43 PM by 3434481

    Logon failed returned when loging in RPD in Online mode

    3434481

      After we migrated catalog from one environment to another, We are then unable to log into the repository in an online mode. We have refreshed GUIDs but WebLogic will only log in console, EM and Answers. What could be causing this? Any suggestions will be greatly appreciated.

        • 1. Re: Logon failed returned when loging in RPD in Online mode
          Sherry George

          Were you able to connect in online mode  in this environment before the catalog migration? If yes, has anything changed? Also post your OBIEE version.

          • 2. Re: Logon failed returned when loging in RPD in Online mode
            3434481

            Yes, we were able to connect in online mode before the migration. I also forgot to mention that we migrated both RPD and Catalog. The version is 11.1.1.9.0

            • 3. Re: Logon failed returned when loging in RPD in Online mode
              Sherry George

              Do you see any additional error messages in NQSAdminTool log ?

              • 4. Re: Logon failed returned when loging in RPD in Online mode
                3434481

                Please observe the following logs below: NQSAdmintool, NQquery and NQserver

                 

                 

                NQSAdminTool

                 

                 

                2017-05-10T16:30:58.36-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: a74]  [nQSError: 43113] Message returned from OBIS. [[

                file: server\NQSAdmin\RpAdmin\Src\SAProxyRp.cpp; line: 131

                [nQSError: 43126] Authentication failed: invalid user/password.

                [nQSError: 37001] Could not connect to the Oracle BI Server instance.

                ]]

                [2017-05-10T16:31:54.444-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 4218] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-10T16:31:54.472-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 4218]  [46158] Admintool is using language ENU.

                [2017-05-10T16:33:52.517-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 3688] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-10T16:33:52.545-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 3688]  [46158] Admintool is using language ENU.

                [2017-05-10T16:39:55.828-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 17c0] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-10T16:39:55.855-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 17c0]  [46158] Admintool is using language ENU.

                [2017-05-10T17:51:37.897-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 28d0] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-10T17:51:37.923-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 28d0]  [46158] Admintool is using language ENU.

                [2017-05-10T18:25:33.442-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 37c0] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-10T18:25:33.469-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 37c0]  [46158] Admintool is using language ENU.

                [2017-05-10T21:03:39.741-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 33d8] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-10T21:03:39.768-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 33d8]  [46158] Admintool is using language ENU.

                [2017-05-10T21:04:53.55-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: aec] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-10T21:04:53.81-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: aec]  [46158] Admintool is using language ENU.

                [2017-05-11T14:46:24.863-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 301c] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-11T14:46:24.891-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 301c]  [46158] Admintool is using language ENU.

                [2017-05-11T18:51:01.29-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 3510] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-11T18:51:01.57-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 3510]  [46158] Admintool is using language ENU.

                [2017-05-11T18:59:58.22-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 7a8] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-11T18:59:58.50-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 7a8]  [46158] Admintool is using language ENU.

                [2017-05-11T19:32:31.526-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 7a8]  [nQSError: 43113] Message returned from OBIS. [[

                file: server\NQSAdmin\RpAdmin\Src\SAProxyRp.cpp; line: 131

                [nQSError: 43126] Authentication failed: invalid user/password.

                [nQSError: 37001] Could not connect to the Oracle BI Server instance.

                ]]

                [2017-05-16T09:29:12.326-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 2b5c] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

                [2017-05-16T09:29:12.355-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 2b5c]  [46158] Admintool is using language ENU.

                 

                 

                NQquery

                 

                ]

                [2017-05-16T14:29:54.911-04:00] [OracleBIServerComponent] [TRACE:2] [] [] [ecid: 00ifZu^DZKZFw00Fzzw0w00000e^001YeH,0] [tid: 1054] [messageid: USER-0] [requestid: 756900cb] [sessionid: 75690000] [username: svcacct_OBIEE] ############################################## [[

                -------------------- SQL Request, logical request hash:

                3de3b1ac

                {call NQSSearchIdentities('USERS','GUID=931A22F0FD9B11E5AF726316A15A45DA')}

                 

                ]]

                [2017-05-16T14:29:54.946-04:00] [OracleBIServerComponent] [TRACE:2] [] [] [ecid: 00ifZu^DftsFw00Fzzw0w00000e^001YeP,0] [tid: 1054] [messageid: USER-0] [requestid: 756900cc] [sessionid: 75690000] [username: svcacct_OBIEE] ############################################## [[

                -------------------- SQL Request, logical request hash:

                b269476c

                {call NQSSearchIdentities('USERS','GUID=01acb0962f1d4dcd8410e2412a293a84')}

                 

                ]]

                [2017-05-16T14:29:55.222-04:00] [OracleBIServerComponent] [TRACE:2] [] [] [ecid: 00ifZu^EitlFw00Fzzw0w00000e^001YeX,0] [tid: 1054] [messageid: USER-0] [requestid: 756900cd] [sessionid: 75690000] [username: svcacct_OBIEE] ############################################## [[

                -------------------- SQL Request, logical request hash:

                2fd944c3

                {call NQSSearchIdentities('USERS','GUID=89eb0480ba0845a4af79e468951bf9d5')}

                 

                ]]

                [2017-05-16T14:29:55.254-04:00] [OracleBIServerComponent] [TRACE:2] [] [] [ecid: 00ifZu^Er0_Fw00Fzzw0w00000e^001Yed,0] [tid: 1054] [messageid: USER-0] [requestid: 756900ce] [sessionid: 75690000] [username: svcacct_OBIEE] ############################################## [[

                -------------------- SQL Request, logical request hash:

                81ff644e

                {call NQSSearchIdentities('USERS','GUID=1c4606aee9254352b1e0ca5a5c691c3c')}

                 

                ]]

                 

                 

                 

                 

                 

                NQserver

                 

                 

                 

                 

                 

                 

                [2017-05-15T19:20:42.958-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:20:53.958-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:21:04.959-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:21:15.974-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:21:26.990-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:21:37.990-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:21:49.84-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:22:00.100-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:22:11.100-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:22:22.100-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:22:33.116-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:22:44.132-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:22:55.132-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d08]  [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

                file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

                ]]

                [2017-05-15T19:23:09.929-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: 00ifYuV7NyBFw00Fzzw0w00000e^0014eE,0] [tid: 100c]  [nQSError: 43123] Query log for some users are enabled, performance may decreased

                [2017-05-16T09:32:01.882-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZdush_RFw00Fzzw0w00000e^001QpV,0] [tid: 10a8]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 16 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 172 **********

                Description: Authenticate

                RPID: Star; user: weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T09:32:01.975-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZdush_RFw00Fzzw0w00000e^001QpV,0] [tid: 10a8]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard#1; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 265 **********

                Description: Authenticate

                RPID: Star; user: weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T09:32:01.976-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZdush_RFw00Fzzw0w00000e^001QpV,0] [tid: 10a8]  [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: INIT_PROXYLEVEL; Query:

                select proxyLevel

                from S_PROXY_USERS

                where 'VALUEOF(NQ_SESSION.RUNAS)'=targetId and 'weblogic'=proxyId

                **********  Task: 2. Running for (mls): 265 **********

                Description: Authenticate

                RPID: Star; user: weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T09:32:01.977-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00ifZdush_RFw00Fzzw0w00000e^001QpV,0] [tid: 10a8]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard' has failed.

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard#1' has failed.

                [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition.

                [nQSError: 13011] Query for Initialization Block 'INIT_PROXYLEVEL' has failed.

                ]]

                [2017-05-16T12:32:26.734-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZo06iXFFw00Fzzw0w00000e^001V^E,0] [tid: 1028]  [nQSError: 13057] Error From BI Security Service: oracle.webservices.provider.ProviderException: javax.xml.ws.WebServiceException: [OBI-SEC-00110] FailedAuthentication : BI Security access denied - missing web service credentials.. [[

                 

                **********  Task: 1. Running for (mls): 47 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T12:32:40.448-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZo0ucIqFw00Fzzw0w00000e^001V^^,0] [tid: 1038]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 140 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T12:32:40.560-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZo0ucIqFw00Fzzw0w00000e^001V^^,0] [tid: 1038]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard#1; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 250 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T12:32:40.562-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZo0ucIqFw00Fzzw0w00000e^001V^^,0] [tid: 1038]  [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: INIT_PROXYLEVEL; Query:

                select proxyLevel

                from S_PROXY_USERS

                where 'VALUEOF(NQ_SESSION.RUNAS)'=targetId and 'Weblogic'=proxyId

                **********  Task: 2. Running for (mls): 265 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T12:32:40.564-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00ifZo0ucIqFw00Fzzw0w00000e^001V^^,0] [tid: 1038]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard' has failed.

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard#1' has failed.

                [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition.

                [nQSError: 13011] Query for Initialization Block 'INIT_PROXYLEVEL' has failed.

                ]]

                [2017-05-16T15:14:56.375-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx5EIpIFw00Fzzw0w00000e^001ZYw,0] [tid: 105c]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 141 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:14:56.446-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx5EIpIFw00Fzzw0w00000e^001ZYw,0] [tid: 105c]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard#1; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 203 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:14:56.447-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx5EIpIFw00Fzzw0w00000e^001ZYw,0] [tid: 105c]  [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: INIT_PROXYLEVEL; Query:

                select proxyLevel

                from S_PROXY_USERS

                where 'VALUEOF(NQ_SESSION.RUNAS)'=targetId and 'Weblogic'=proxyId

                **********  Task: 2. Running for (mls): 203 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:14:56.448-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00ifZx5EIpIFw00Fzzw0w00000e^001ZYw,0] [tid: 105c]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard' has failed.

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard#1' has failed.

                [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition.

                [nQSError: 13011] Query for Initialization Block 'INIT_PROXYLEVEL' has failed.

                ]]

                [2017-05-16T15:15:37.417-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx7f2fVFw00Fzzw0w00000e^001Z^9,0] [tid: 1064]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 78 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:15:37.431-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx7f2fVFw00Fzzw0w00000e^001Z^9,0] [tid: 1064]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard#1; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 94 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:15:37.433-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx7f2fVFw00Fzzw0w00000e^001Z^9,0] [tid: 1064]  [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: INIT_PROXYLEVEL; Query:

                select proxyLevel

                from S_PROXY_USERS

                where 'VALUEOF(NQ_SESSION.RUNAS)'=targetId and 'Weblogic'=proxyId

                **********  Task: 2. Running for (mls): 94 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:15:37.434-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00ifZx7f2fVFw00Fzzw0w00000e^001Z^9,0] [tid: 1064]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard' has failed.

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard#1' has failed.

                [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition.

                [nQSError: 13011] Query for Initialization Block 'INIT_PROXYLEVEL' has failed.

                ]]

                [2017-05-16T15:15:51.310-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx8W3H8Fw00Fzzw0w00000e^001Z_0,0] [tid: 106c]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 79 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:15:51.324-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx8W3H8Fw00Fzzw0w00000e^001Z_0,0] [tid: 106c]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard#1; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 94 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:15:51.324-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx8W3H8Fw00Fzzw0w00000e^001Z_0,0] [tid: 106c]  [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: INIT_PROXYLEVEL; Query:

                select proxyLevel

                from S_PROXY_USERS

                where 'VALUEOF(NQ_SESSION.RUNAS)'=targetId and 'Weblogic'=proxyId

                **********  Task: 2. Running for (mls): 94 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:15:51.325-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00ifZx8W3H8Fw00Fzzw0w00000e^001Z_0,0] [tid: 106c]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard' has failed.

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard#1' has failed.

                [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition.

                [nQSError: 13011] Query for Initialization Block 'INIT_PROXYLEVEL' has failed.

                ]]

                [2017-05-16T15:16:14.777-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx9tU0dFw00Fzzw0w00000e^001Z_t,0] [tid: 1074]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 109 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:16:14.791-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx9tU0dFw00Fzzw0w00000e^001Z_t,0] [tid: 1074]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard#1; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 125 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:16:14.792-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZx9tU0dFw00Fzzw0w00000e^001Z_t,0] [tid: 1074]  [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: INIT_PROXYLEVEL; Query:

                select proxyLevel

                from S_PROXY_USERS

                where 'VALUEOF(NQ_SESSION.RUNAS)'=targetId and 'Weblogic'=proxyId

                **********  Task: 2. Running for (mls): 125 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:16:14.794-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00ifZx9tU0dFw00Fzzw0w00000e^001Z_t,0] [tid: 1074]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard' has failed.

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard#1' has failed.

                [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition.

                [nQSError: 13011] Query for Initialization Block 'INIT_PROXYLEVEL' has failed.

                ]]

                [2017-05-16T15:17:23.348-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZxDz8E7Fw00Fzzw0w00000e^001Zbc,0] [tid: 107c]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 93 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:17:23.362-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZxDz8E7Fw00Fzzw0w00000e^001Zbc,0] [tid: 107c]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: Get Users Default Dashboard#1; Query:

                select case when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'HIA_Medical_Cost') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'BIAdministrator') > 0 then '/shared/HIA Medical Cost/_portal/HIA Medical Cost'

                         when INSTR(NVL('valueof(nq_session.ROLES)', 'NOROLES'),'Claims_Opermart') > 0 then '/shared/HIA Operational Claims/_portal/HIA Operational Claims'

                end

                from dual;

                **********  Task: 2. Running for (mls): 93 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:17:23.363-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifZxDz8E7Fw00Fzzw0w00000e^001Zbc,0] [tid: 107c]  [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition. [[

                file: server\Metadata\Src\SMUtil.cpp; line: 2247

                 

                **********  Task: 1. Running for (mls): 0 **********

                Description: Execute Init Block

                Name: INIT_PROXYLEVEL; Query:

                select proxyLevel

                from S_PROXY_USERS

                where 'VALUEOF(NQ_SESSION.RUNAS)'=targetId and 'Weblogic'=proxyId

                **********  Task: 2. Running for (mls): 109 **********

                Description: Authenticate

                RPID: Star; user: Weblogic; AppType: 1; Offline: false

                 

                ]]

                [2017-05-16T15:17:23.365-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00ifZxDz8E7Fw00Fzzw0w00000e^001Zbc,0] [tid: 107c]  [nQSError: 23006] The session variable, nq_session.ROLES, has no value definition. [[

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard' has failed.

                [nQSError: 13011] Query for Initialization Block 'Get Users Default Dashboard#1' has failed.

                [nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition.

                [nQSError: 13011] Query for Initialization Block 'INIT_PROXYLEVEL' has failed.

                ]]

                • 5. Re: Logon failed returned when loging in RPD in Online mode
                  Sherry George

                  Was there any security related changes with the migration?  Also I see socket communication errors, are you able to telnet the OBIEE server  from the client machine.

                   

                  telnet mybiserver 9703

                  • 6. Re: Logon failed returned when loging in RPD in Online mode
                    3434481

                    Thank you for replying. There was no change in security during the migration. We are able to connect with all the users through answers. host:9502/analytics since it's the 2nd instance.

                    • 7. Re: Logon failed returned when loging in RPD in Online mode
                      Sherry George

                      This is a silly question, but did you confirm that the services are running on both of your instances? Also were you able to perform a telnet from the machine where the admintool is used.

                      • 8. Re: Logon failed returned when loging in RPD in Online mode
                        3434481

                        Hey George,

                         

                        Services are running on all instances. In the 1st instance, I am able to login to rpd in online mode without any issues. As for the telnet performance, I have no clue. Researching that now.

                        • 9. Re: Logon failed returned when loging in RPD in Online mode
                          Sherry George

                          3434481 wrote:

                           

                          Hey George,

                           

                          In the 1st instance, I am able to login to rpd in online mode without any issues.

                          What do you mean by this? Wasn't your problem "not being able to login in online mode".

                           

                          3434481 wrote:

                           

                          As for the telnet performance, I have no clue. Researching that now.

                          I asked to check telnet because firewall could cause login issues, to rule out firewall as the cause you can run telnet from a command prompt (example I gave you before), if successful it would normally give you a prompt otherwise it will give an appropriate error message.

                          • 10. Re: Logon failed returned when loging in RPD in Online mode
                            3434481

                            The server has 2 instances. The 1st instance has no issues login into rpd online. I am having issues with the 2nd instance.

                            • 11. Re: Logon failed returned when loging in RPD in Online mode
                              Sherry George

                              ok, can you also make sure that your ODBC DSN has the correct information to connect to instance 2 and you are able make a successful connection.

                              • 12. Re: Logon failed returned when loging in RPD in Online mode
                                Chaitanya

                                Hi,

                                Are you able to login into Analytics page? Are you able to login EM and Console?

                                If you are not able to login analytics page also, Please check the boot.properties file which is located in $MIDDLEWARE_HOME/user_projects/domains/bifoundation_domain/servers/AdminServers/security  and edit the boot.properties file..

                                 

                                Just remove the encrypted format and provide user name and password. Hope this will work.

                                 

                                Regards,

                                C.

                                 

                                 

                                • 13. Re: Logon failed returned when loging in RPD in Online mode
                                  3434481

                                  Hello Chaitanya,

                                   

                                  I am able to login into Analytics page, EM as well as Console with no issues. There only place I can't login to is The RPD in online mode of course.

                                  • 14. Re: Logon failed returned when loging in RPD in Online mode
                                    3434481

                                    Hello George,

                                     

                                    This issue has been resolved. There was a change in a security feature. A developer mistakenly deleted the administrative policy. The policy contains the following permission which is required for online RPD access: See attached screen shot.

                                     

                                    Thank you.

                                     

                                     

                                    policies.pngThank