Uploaded image for project: 'JOC - JobScheduler Operations Center'
  1. JOC - JobScheduler Operations Center
  2. JOC-589

JOC API ./tasks/history throws error JOC-420 for taskIds parameter

    XMLWordPrintable

Details

    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-420
        code": "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.

      Attachments

        Activity

          People

            oh Oliver Haufe
            mp Mahendra Patidar
            Anuj-Jain Anuj-Jain
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: