Jobs Failing with Oracle error after upgrade to DS4.2
We are experiencing Oracle error while executing jobs after it was upgraded to DS 4.2 SP5. We have modified the jobs cache value to Pageable to resolve named pipe error, since we modified the settings named pipe error has resolved but we notice Oracle error as below. After the settings at DF were reverted to in-memory we noticed Named pipe error and Oracle error as well.
14.2) 10-24-15 02:45:31 (E) (15812:14908) DBS-070301: |Data flow DF_Name
Oracle <(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = XXXX)(PORT = 1521)))(CONNECT_DATA
=(SID=PRODDB)))> error message for operation <OCIStmtExecute>: <ORA-03149: Invalid Oracle error code
The db in error msg is repository connection, we can ping the DB and connect to it fine.
SQL*Plus: Release 126.96.36.199.0 Production
Prod DB Version
Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options