Following is the error in BI logs:
[2023-04-03T22:31:52.633-04:00] [bi_server1] [ERROR] [] [oracle.biee.search] [tid: BISearchSujectAreaPushCrawler-thread-1] [userId: <anonymous>] [ecid: eed40b4f-e0e5-4d62-8ab6-0cdcabc489fe-0000000d,0:776:7:39] [APP: bisearch] [partition-name: DOMAIN] [tenant-name: GLOBAL] Failed to create system session due to exception: java.net.ConnectException: Connection refused (Connection refused)[[
javax.xml.ws.ProtocolException: java.net.ConnectException: Connection refused (Connection refused)
at com.siebel.analytics.web.jaxwsutils.HttpTcpBridge.sendHttpRequest(HttpTcpBridge.java:105)
at com.siebel.analytics.web.jaxwsutils.DirectSoapCaller.invokeSoapMethod(DirectSoapCaller.java:221)
at com.siebel.analytics.web.jaxwsutils.SAWSOAPTcpConnector.invokeSoapMethod(SAWSOAPTcpConnector.java:79)
at com.siebel.analytics.web.jaxwsutils.SOAPInterfaceProxy.invoke(SOAPInterfaceProxy.java:206)
at com.sun.proxy.$Proxy718.logonex(Unknown Source)
at oracle.biee.search.security.BISearchSessionManager$BIPSSoapSession.createSessionID(BISearchSessionManager.java:576)
at oracle.biee.search.security.BISearchSessionManager$BIPSSoapSession.createSession(BISearchSessionManager.java:440)
at oracle.biee.search.security.BISearchSessionManager$BIPSSoapSession.<init>(BISearchSessionManager.java:423)
at oracle.biee.search.security.BISearchSessionManager$BIPSSoapSession.<init>(BISearchSessionManager.java:403)
at oracle.biee.search.security.BISearchSessionManager.lambda$getSession$0(BISearchSessionManager.java:290)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at oracle.biee.search.security.BISearchSessionManager.getSession(BISearchSessionManager.java:301)
at oracle.biee.search.security.BISearchSessionManager.getSystemSession(BISearchSessionManager.java:360)
at oracle.biee.search.security.BISearchSessionManager.getSystemSession(BISearchSessionManager.java:366)
at oracle.biee.search.services.crawl.scheduler.BISearchSubjectAreaUpdater$SubjectAreaUpdater.call(BISearchSubjectAreaUpdater.java:117)
at oracle.biee.search.services.crawl.scheduler.BISearchSubjectAreaUpdater$SubjectAreaUpdater.call(BISearchSubjectAreaUpdater.java:72)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218)
Solution:
Start System Components of OBIEE as following:
1. Login to EM as admin user
2. Click on Navigation Icon
3. Expand Business Intelligence
4. Click on biinstance
5. Click on Availability Tab
6.Click Start All to start the Components
javax.xml.ws.ProtocolException: java.net.ConnectException: Connection refused (Connection refused)
at com.siebel.analytics.web.jaxwsutils.HttpTcpBridge.sendHttpRequest(HttpTcpBridge.java:105)
at com.siebel.analytics.web.jaxwsutils.DirectSoapCaller.invokeSoapMethod(DirectSoapCaller.java:221)
at com.siebel.analytics.web.jaxwsutils.SAWSOAPTcpConnector.invokeSoapMethod(SAWSOAPTcpConnector.java:79)
at com.siebel.analytics.web.jaxwsutils.SOAPInterfaceProxy.invoke(SOAPInterfaceProxy.java:206)
at com.sun.proxy.$Proxy718.logonex(Unknown Source)
at oracle.biee.search.security.BISearchSessionManager$BIPSSoapSession.createSessionID(BISearchSessionManager.java:576)
at oracle.biee.search.security.BISearchSessionManager$BIPSSoapSession.createSession(BISearchSessionManager.java:440)
at oracle.biee.search.security.BISearchSessionManager$BIPSSoapSession.<init>(BISearchSessionManager.java:423)
at oracle.biee.search.security.BISearchSessionManager$BIPSSoapSession.<init>(BISearchSessionManager.java:403)
at oracle.biee.search.security.BISearchSessionManager.lambda$getSession$0(BISearchSessionManager.java:290)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at oracle.biee.search.security.BISearchSessionManager.getSession(BISearchSessionManager.java:301)
at oracle.biee.search.security.BISearchSessionManager.getSystemSession(BISearchSessionManager.java:360)
at oracle.biee.search.security.BISearchSessionManager.getSystemSession(BISearchSessionManager.java:366)
at oracle.biee.search.services.crawl.scheduler.BISearchSubjectAreaUpdater$SubjectAreaUpdater.call(BISearchSubjectAreaUpdater.java:117)
at oracle.biee.search.services.crawl.scheduler.BISearchSubjectAreaUpdater$SubjectAreaUpdater.call(BISearchSubjectAreaUpdater.java:72)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218)
Solution:
Start System Components of OBIEE as following:
1. Login to EM as admin user
2. Click on Navigation Icon
3. Expand Business Intelligence
4. Click on biinstance
5. Click on Availability Tab
6.Click Start All to start the Components