Folks, I need some ideas. This is a problem that just showed up in our OAC environment within the past 2 days. Prior to that, everything worked well.
I have 8 subject areas in my repository. Seven of them work fine. Any time I try to execute any query against the other one, I get this message:
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 1012, message: ORA-01012: not logged on Process ID: 8536 Session ID: 314 Serial number: 53019 at OCI call OCIStmtExecute. (HY000)
State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation failed. (HY000)
- The subject area passes a consistency check.
- If I right-click ... View Data in the physical layer of the repository, I see data, so I know the connection pool credentials are correct.
I do not know if this is related or not, but this additional problem has shown up along with the first one: None of my session variables are getting set when I sign in. However, I test the initialization block while in the repository, the SQL executes correctly and I see what I expect.
And one more bit of fun: I have even rolled back to a repository that was active 3 weeks ago. And the same failures are appearing. Until 2 days ago, everything was running well. Rolling back to a repository that worked 3 weeks ago should get rid of whatever is wrong, UNLESS something is goofy in the application itself.