Showing posts with label BI. Show all posts
Showing posts with label BI. Show all posts

Error in BI Server logs-Failed to create system session due to exception: java.net.ConnectException: Connection refused

 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

Change the permissions of the Shared Folders for Oracle Analytics Server

Enabling the Online Catalog Manager to Connect and change the permissions for the folders.
 
Go to the location:
cd $ORACLE_HOME/user_projects/domains/bi/bitools/bin
run
./runcat.sh
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Click on File --> Open Catalog
URL-->http://hostname:port_number/analytics-ws
User --> weblogic
Password -->
Click on OK
 
 
Right Click on the folder you want to change permissions

 

Basic Perfomance Tuning For stuck threads and response times

Documentation for performance tuning: https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/asper/redundant-cross-references-remo...