While running the reports in Analytics , we are getting the below error .
View Display Error
Odbc driver returned an error (SQLFetchScroll).
Error Codes: OPR4ONWY:U9IM8TAC
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 12002] Socket communication error at call=SSL_read: (Number=5) Resource temporarily unavailablePlease have your System Administrator look at the log for more details on this error. (HY000)
Logs are also not helping. Just to let you know that we have used horizontal clustering and using load balancer in active/active mode.
check the DSN tag what it got is it something like default dsn as coreappBLABLA or cluster related..
Edited by: Srini VEERAVALLI on Feb 24, 2013 11:10 PM Check this
Edited by: Srini VEERAVALLI on Feb 24, 2013 11:59 PM Check the Cluster Controller log:
*/instances/instance1/diagnostics/logs/OracleBIClusterControllerComponent\coreapplication_obiccs1* Files: nqcluster.log
Edited by: Srini VEERAVALLI on Feb 25, 2013 12:01 AM
Thanks for the response. Actually I didn't see your first comment and wanted to inform that we are using 126.96.36.199.5.
BTW , for a clustered set up what should be the value of DSN tag . The server is currently down , will definately check and revert back..
Edited by: 894860 on Feb 24, 2013 9:41 PM
Just to provide more input :
We have a OBI cluster with 2 nodes (cpf01 and cpf02), and both nodes have the BI server and Presentation service running, and the primary cluster controller is running on the node 1.
1. Shutdown the BI server in cpf02, and shutdown presentation service in cpf01.
2. Login analytics, and open report, and got the error page with "A general error has occurred. [nQSError: 12002] Socket communication error at call=SSL_read: (......
3. However, click the refresh link the error page will show the report correctly.
Have you taken out PrimaryCCS values intentionally?
Check this once http://oraclebiblog.blogspot.com/2009/07/configure-obiee-in-cluster-mode.html
version might diff but check it once at the end of the page or entire
Edited by: Srini VEERAVALLI on Feb 25, 2013 10:24 AM
Tried but no help..
Noticed one thing whenver we disable teh SSL in obiee componenets keeping Weblogic and Apache SSL intact , the problem is not reproduced. Any idea what is the issue with SSL in obiee interating componets.