The exact error message:
SchedTbl_Ora_conn,0: The OCI function OCIStmtFetch returned status -1. Error code: 3,113, Error message: ORA-03113: end-of-file on communication channel. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1,009)
The OCI function OCITransRollback returned status -1. Error code: 3,114, Error message: ORA-03114: not connected to ORACLE. (CC_OraConnection::endLocalTransaction, file CC_OraConnection.cpp, line 1,098)
There are multiple jobs running connecting the the same database and schema. This job last ran successfully 2 days back. Now it refuses to run with this issue. DBA's cannot find any issues with the table or Connection.
The OCI function OCIStmtFetch returned status -1
Moderators: chulett, rschirm, roy
There are many causes for that 3113 error as noted out in the wild, including here. If you can't get any joy from your DBAs or there's no sign of "defunct processes" then I'd suggest you contact your official support provider. Could be a bug in the stage or perhaps even in the Oracle client version you are using.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Found the solution
This had nothing to do with Oracle. I had earlier changed one of the jobs loading into the table to handle one of the columns as BigInt instead of Integer as i was getting negative values while using integer and the data according to Mainframe was a type Int64 (S9(10)).
Due to this change, DS is not able to select the data as the select statement still considers the column as an Integer. Instead of giving a warning that the record precision is incorrect or smaller than the required size, it instead gave an oracle connectivity issue. Seems like the Oracle connectivity needs to be checked to understand why this was happening.
Due to this change, DS is not able to select the data as the select statement still considers the column as an Integer. Instead of giving a warning that the record precision is incorrect or smaller than the required size, it instead gave an oracle connectivity issue. Seems like the Oracle connectivity needs to be checked to understand why this was happening.
Regarding reporting to support provider
Am not sure if any action will be taken on this. Am just changing my jobs that touch that table to handle this issue. This had a cascading effect where all the jobs reading from or loading into the table started failing.