Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Logon failed returned when loging in RPD in Online mode
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.
Answers
-
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.
0 -
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
0 -
Do you see any additional error messages in NQSAdminTool log ?
0 -
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.
]]
0 -
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
0 -
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.
0 -
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.
0 -
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.
0 -
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.
0 -
The server has 2 instances. The 1st instance has no issues login into rpd online. I am having issues with the 2nd instance.
0