Oracle Business Intelligence Applications

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

After applying the OBIEE bundle stack patch 37468177 user are not able to login via EBS

Accepted answer
15
Views
1
Comments

Hi,

We have a EBS environment which is connected to OBIEE. After applying the OBIEE bundle stack patch 37468177 user are not able to login using a cookie via EBS anymore. EBS has not been patched yet. Only OBIEE has been patched.

Does anyone has a clue?

I have changed the userId for security reasons and have renamed the ip to "removed_ip"

sawlog reports:

[2025-03-03T14:42:47+01:00] [OBIPS] [ERROR:31] [] [saw.rpc.variablemos.write] [ecid: e0efedc7-62f9-4567-b1f4-d18413db3de0-0001faaa,0:1] [tid: 2781894400] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: CHANGED_USER] An error occurred during execution of "send". Connection reset by peer [Socket:32][[
48496 File:socket.cpp
48497 Line:830
48498 Location:
48499 saw.rpc.variablemos.write
48500 saw.subsystem.portal.pagesImpl
48501 saw.subsystem.portal
48502 saw.httpserver.processrequest
48503 saw.rpc.server.responder
48504 saw.rpc.server
48505 saw.rpc.server.handleConnection
48506 saw.rpc.server.dispatch
48507 saw.threadpool.socketrpcserver
48508 saw.threads
48509 DashPagePath: /shared/Finance/_portal/Fixed Assets/Reserve Ledger
48510 SessionID: removed_ip.1b8.ucv34g9
48511 AuthProps: AuthSchema=EBS-ICX|NQ_SESSION.ICX_SESSION_COOKIE=GX2FlEoDnTf8MPHRWXJUvEnILM|NQ_SESSION.SERVICEINSTANCEKEY=ssi|User=CHANGED_USER|GUID=CHANGED_USER
48512 RemoteIP: removed_ip
48513 DashPath: /shared/Finance/_portal/Fixed Assets
48514 HttpCommand: Dashboard
48515 SIKey: ssi
48516 ]]
48517 [2025-03-03T14:42:47+01:00] [OBIPS] [ERROR:31] [] [saw.subsystem.portal.pagesImpl] [ecid: e0efedc7-62f9-4567-b1f4-d18413db3de0-0001faaa,0:1] [tid: 2781894400] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ENSHORE_WOOD ROW] Client no longer there.[[
48518 File:sawserverstream.cpp
48519 Line:949
48520 Location:
48521 saw.subsystem.portal.pagesImpl
48522 saw.subsystem.portal
48523 saw.httpserver.processrequest
48524 saw.rpc.server.responder
48525 saw.rpc.server
48526 saw.rpc.server.handleConnection
48527 saw.rpc.server.dispatch
48528 saw.threadpool.socketrpcserver
48529 saw.threads
48530 DashPagePath: /shared/Finance/_portal/Fixed Assets/Reserve Ledger
48531 SessionID: removed_ip.1b8.ucv34g9
48532 AuthProps: AuthSchema=EBS-ICX|NQ_SESSION.ICX_SESSION_COOKIE=GX2FlEoDnTf8MPHRWXJUvEnILM|NQ_SESSION.SERVICEINSTANCEKEY=ssi|User=CHANGED_USER|GUID=CHANGED_USER
48533 RemoteIP: removed_ip
48534 DashPath: /shared/Finance/_portal/Fixed Assets
48535 HttpCommand: Dashboard
48536 SIKey: ssi
48537 ]]

bi_server1-diagnostic.log says:

 [2025-03-03T14:42:44.579+01:00] [bi_server1] [ERROR] [] [oracle.webservices.service] [tid: [ACTIVE].ExecuteThread: '36' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: e0efedc7-62f9-4567-b1f4-d18413db3de0-00      01faaa,0:1:6:1] [APP: bi-security] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] oracle.webservices.provider.ProviderException: javax.xml.ws.WebServiceException: [OBI-SEC-00110]  FailedAuthentication: BI Security access denied       - missing web service credentials.[[

Best Answer