Skip to Content
avatar image
Former Member

Jobs Failing with Oracle error after upgrade to DS4.2

Hi

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.


Client version

SQL*Plus: Release 11.2.0.1.0 Production

Prod DB Version

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Please advice.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 28, 2015 at 09:24 AM

    hi

    As per SAP tech support, this issue occurs if  Oracle client version is between 11.2.0.1 and 11.2.0.3 and could be resolved by installing Oracle 12C - 12.1.0.1 version.

    Workaround available is by disabling the options to collect statistics for optimization and monitoring, use statistics for optimization.

    I have disabled the above set parameter and jobs are working fine.

    Thank you

    Manish Singh

    Add comment
    10|10000 characters needed characters exceeded