Details
-
Fix
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.12.6
-
None
Description
Current Situation
- For earlier JobScheduler release, user was using the XML command <show_history job="[jobPath]" id="[taskId]" /> to JobScheduler to get the task's status, now user want to use the JOC REST API to get the same information.
- When a user calls the ./joc/api/tasks/history with parameters , where taskIds parameter is an array.
{ "jobschedulerId": "scheduler", "taskIds": [33612] }
- API response has the exception
JOC-420code": "JOC-420", "message": "com.sos.hibernate.exceptions.SOSHibernateQueryException: could not extract ResultSet: 0 ERROR: column \"taskid\" does not exist\n Position: 1051 [from com.sos.jitl.reporting.db.DBItemReportTask where schedulerId=:schedulerId and taskId in (:taskIds) order by startTime desc][schedulerId=scheduler,taskIds=33612]"
Desired Behavior
- The JOC API ./tasks/history should retrun Task status for all the taskIds specified in the rest request parameters.