Unable to bring up BI after change the AD user password for "oracle.bi.system" in AD and em console

Question

Hello, we are not able to bring up BI (11.1.19) application after change the AD user password for "oracle.bi.system" in AD and em console,

now even we switch to use "local user" BISystemUser, but get the same error in bi managed server logs:

INFO: SAW Config read through com.siebel.analytics.web.j2eeutils.AbstractConfigLoader : com.siebel.analytics.utils.DualConfig@3b703ff4

INFO: *** Oracle MapViewer Data Server started. ***

INFO: oracle.domain.config.dir=/prd/bi/obi11g/user_projects/domains/bifoundation_domain/config/fmwconfig

INFO: Externalized SAWBridge config file is /prd/bi/obi11g/user_projects/domains/bifoundation_domain/config/fmwconfig/biinstances/coreapplication/bridgeconfig.properties

INFO: Getting SAWBridge config from external config file and web.xml

INFO: *** Oracle Feature of Interest (FOI) Server started. ***

INFO: *** Oracle MapTileServer started. ***

WARNING: unable to retrieve sudo session id [username: BISystemUser]

WARNING: javax.xml.ws.ProtocolException: java.net.ConnectException: Connection refused

at com.siebel.analytics.web.jaxwsutils.HttpTcpBridge.sendHttpRequest(HttpTcpBridge.java:117)

at com.siebel.analytics.web.jaxwsutils.DirectSoapCaller.invokeSoapMethod(DirectSoapCaller.java:180)

at com.siebel.analytics.web.jaxwsutils.SAWSOAPTcpConnector.invokeSoapMethod(SAWSOAPTcpConnector.java:77)

at com.siebel.analytics.web.jaxwsutils.SOAPInterfaceProxy.invoke(SOAPInterfaceProxy.java:206)

at $Proxy219.logonex(Unknown Source)

at oracle.xdo.service.report.saw.wrapper.v7.AbstractSawSessionService.logonex(AbstractSawSessionService.java:65)

at oracle.xdo.service.report.saw.wrapper.v7.SawSessionServiceImpl.logonex(SawSessionServiceImpl.java:165)

at oracle.xdo.servlet.GlobalContext.getSawLogin(GlobalContext.java:472)

at oracle.xdo.servlet.GlobalContext.initSawResource(GlobalContext.java:654)

any idea will be very appreciated since this is production and it has been down for 8 hours now, thanks

User_27DEY · Answer

Thanks! we can not reset back to the original passwd due to security policy, have to change periodically  but do you know why we are getting the error, where to check? we think something get corrupted. but not sure what they are. thanks! in the past we used BISystemUser and it worked fine, but now we are having issues with AD account, so try to use this user, but get the same error as use AD user. thanks again!! very appreciate you rhelp!

Sumanth V -Oracle · Answer

@User_27DEY - The BISystemUser is a system account created during the OBIEE 11g installation and configuration process. It is meant to reside in the WebLogic embedded LDAP and is used internally by the system for inter-component communication.

This user should not be and cannot be updated to use external LDAP or Active Directory credentials. Attempting to do so may cause startup failures or internal authentication issues.

If you recently changed the password in Active Directory or linked this user to AD, please try resetting the password back to the original value used before the change, and then restart the BI services.

For detailed instructions on how to resolve this issue, please refer to the document below:

https://docs.oracle.com/middleware/12211/biee/BIESC/GUID-E9408D30-0317-477C-BB39-6FAB11260A98.htm