AnsweredAssumed Answered

Delete Investments Monthly

Question asked by mush on Apr 17, 2012
Latest reply on Nov 26, 2012 by Dale_Stockman
We run a delete Investments job on a monthly basis. We are on Clarity 12.0.4, with an Oracle Database.

Last time run I got a message stating, "An error ocurred while attempting to delete one or more projects in the background scheduler. Please, refer to the log for details."

I've searched the logs and can't find the error. Is there a query that can be run to find more detail? I ran this query just to get the message above.

SELECT * FROM cmn_sch_job_logs WHERE status_code IN ('FAILED')
and JOB_RUN_ID = 11066164

It could be that the error is too old for the logs, but, any input would be appreciated.

Thank you.