Hi Experts,
I am having an issue with a custom job that is running through clarity after upgrading clarity from 14.3 to 15.3.
1.The Job is a SQL Stored Procedure executable.
2.I am able to run the stored procedure successfully from studio.
While running the job through clarity I am getting the following error.
ERROR 2018-05-02 07:51:26,455 [Dispatch CF Manage Timesheet Edit & Approval rights for PM's & RM's : bg@SV-CLRTY15-T1 (tenant=clarity)] niku.njs (clarity:AAA3158:18096025__E519D015-489A-4D2D-A1C3-A970013326C7:CF Manage Timesheet Edit & Approval rights for PM''s & RM''s) Error executing job: 6427487
com.niku.union.persistence.PersistenceException: extractResultSets may be in an infinite loop
at com.niku.union.persistence.PersistenceController.extractResultSets(PersistenceController.java:1897)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2820)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:868)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:768)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:576)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:306)
at com.niku.njs.listeners.SPJob.scheduledEventFired(SPJob.java:141)
at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:652)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
I tried debugging the issue and failed. Please shed some light to it.
Thanks,
Harun