Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

not connected to ORACLE at OCI call OCIStmtExecute

netgautamMay 16 2007 — edited Feb 26 2008
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2008
Added on May 16 2007
5 comments
17,584 views