4 Replies Latest reply on Nov 26, 2007 9:48 PM by user153637

    ORA-00604: error occurred at recursive SQL le

    New Member


      Hi All,



      When I tried to run the workflow I am getting the following error. The issue is I am getting this error sometimes only. Most of the times the map runs fine.



      Informatica 7.1.4

      Oracle 11g.



      Thanks,

      Akhil



      WRITER_1_*_1> WRT_8229 Database errors occurred:

      ORA-00604: error occurred at recursive SQL level 1

      ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired



      Database driver error...

      Function Name : Prepare DPL

      SQL Stmt : INSERT INTO EMP_DEPT(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO,DNAME,LOC) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

      Oracle Fatal Error

      Database driver error...

      Function Name : Execute Multiple

      SQL Stmt : INSERT INTO EMP_DEPT(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO,DNAME,LOC) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

      Oracle Fatal Error

      WRITER_1_*_1> Mon Nov 26 10:30:24 2007

      WRITER_1_*_1> WRT_8076 Writer run terminated.

      WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.

      WRITER_1_*_1> WRT_8325 Final rollback executed for the target at end of load

      WRITER_1_*_1> Mon Nov 26 10:30:24 2007

      WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table ]

      WRITER_1_*_1> WRT_8168 End loading table at: Mon Nov 26 10:30:24 2007

      WRITER_1_*_1> WRT_8035 Load complete time: Mon Nov 26 10:30:24 2007