not connected to ORACLE at OCI call OCIStmtExecute
I am facing a problem in OBI EE Administrator tool while accessing data. I have created ODBC connection. It is working fine in SQL Plus. It was working fine in OBI EE Administrator tool recently but now, I am getting this error because of unknown change.
When I open OBI EE Administrator Tool in online mode, I right-click on a table and select Update Row Count or View Data..., I get following error -
[NQODBC][SQL_STATE:HY000][nQSError:10058] A general error has occurred.
[nQSError:43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 17001] Oracle Error code: 3114, message: ORA-03114: not connected to ORACLE at OCI call OCIStmtExecute.
[nQSError: 17010] SQL statement preparation failed.
In the log file, I am getting following message -
-------------------- Query Status: Query Failed: [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 17001] Oracle Error code: 3114, message: ORA-03114: not connected to ORACLE
at OCI call OCIStmtExecute.
[nQSError: 17010] SQL statement preparation failed.
Over Answers, I am getting this error message -
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 3114, message: ORA-03114: not connected to ORACLE at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
SQL Issued: SELECT ...
Please suggest some solution.