3 Replies Latest reply: Nov 16, 2012 3:16 PM by user651347 RSS

    Clear Audit records

    user651347
      I am trying to clear AUD_JMS by running "Issue Audit Messages Task" schedule task but receiving the following error

      <Error> <XELLERATE.AUDITOR> <BEA-
      000000> <Class/Method: UserProfileRDGenerator/insertFormProfile encounter some problems: Failed to insert form profile record
      in table UPA_UD_FORMS >>
      <Nov 15, 2012 9:28:33 AM CST> <Notice> <Stdout> <BEA-000000> <<Nov 15, 2012 9:28:33 AM CST> <Error> <XELLERATE.AUDITOR> <BEA-
      000000> <Class/Method: UserProfileRDGenerator/insertFormProfile encounter some problems: {1}
      com.thortech.xl.orb.dataaccess.tcDataAccessException
      at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(tcDataAccessExceptionUtil.java:81)
      at com.thortech.xl.dataaccess.tcDataBase.createException(tcDataBase.java:3171)
      at com.thortech.xl.dataaccess.tcDataBase.writePreparedStatement(tcDataBase.java:1718)
      at com.thortech.xl.dataobj.PreparedStatementUtil.executeUpdate(PreparedStatementUtil.java:156)
      at com.thortech.xl.audit.auditdataprocessors.UserProfileRDGenerator.insertFormProfile(UserProfileRDGenerator.java:160


      <Error> <XELLERATE.DATABASE> <BEA
      -000000> <Class/Method: tcDataBase/writeStatement encounter some problems: ORA-02291: integrity constraint (DEV_OIM.FK_UPA_UD
      UPARES) violated - parent key not found

      java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (DEV_OIM.FK_UPA_UD_UPA_RES) violated - par
      ent key not found

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)


      Any idea how to clear this?