AnsweredAssumed Answered

Custom Job failing after upgrading from clarity 14.3 to clarity 15.3

Question asked by Harun.Prasu on May 2, 2018
Latest reply on May 10, 2018 by Harun.Prasu

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(
 at com.niku.union.persistence.PersistenceController.processSql(
 at com.niku.union.persistence.PersistenceController.processStatement(
 at com.niku.union.persistence.PersistenceController.processStatements(
 at com.niku.union.persistence.PersistenceController.doProcessRequest(
 at com.niku.union.persistence.PersistenceController.processRequest(
 at com.niku.njs.listeners.SPJob.scheduledEventFired(
 at com.niku.njs.Dispatcher$
 at java.util.concurrent.ThreadPoolExecutor.runWorker(
 at java.util.concurrent.ThreadPoolExecutor$



I tried debugging the issue and failed. Please shed some light to it.