1 Reply Latest reply on May 27, 2014 5:51 PM by KKT

    ora-604 error occurred at recursive sql level %S at DRM

    Alvaro Soares

      Hi All,


             I am getting the following error when I click on load setting at DRM Config Console :


      Process ID: 14020, Thread ID: 8, Process Manager]

      Application APPSERVER-1 is shutting down because the Read/Write engine reported the following fatal error: ORA-604: error occurred at recursive SQL level %s


      Oracle.DataAccess.Client.OracleException ORA-604: error occurred at recursive SQL level %s    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

         at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)

         at Oracle.DataAccess.Client.OracleConnection.Open()

         at Oracle.Drm.DalFramework.DalContext.CreateConnection()

         at Oracle.Drm.DalFramework.DalContext.CreateAdoCommand()

         at Oracle.Drm.DalFramework.DalContext.ExecuteNonQuery(String sql)

         at Oracle.Drm.DalFramework.DataAccessLayer.TestConnection()

         at Oracle.Drm.DalFramework.DataAccessLayer.RetrieveVersion()

         at Oracle.Drm.DalFramework.DrmDataAccessLayer.RetrieveVersion()

         at Oracle.Drm.DalFramework.DrmDataAccessLayer.LoadInitialData()

         at Oracle.Drm.DalFramework.DrmDataAccessLayer.Initialize(Boolean ignoreVersion)

         at Oracle.Drm.Global.Initialize(Boolean readOnly)

         at Oracle.Drm.Engine.Host.Program.Main(String[] args)


         I've been trying to google this ORA-006 but there is none an exactly fix to it.


         Does enyone could help me ?