Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tony_empiredev
Contributor II
Contributor II

How can I determine the real last execution date to a task?

I have 3 failed tasks as showing the picture, but the marked task is interesting.

tasks_failed.png

 I made a request to:

/qrs/task/full?xrfkey=1234567891234567&filter=id+eq+9b9f830f-41dc-4ba1-9313-2417e2882981+and+operational.lastExecutionResult.status+eq+8+and+enabled+eq+true

This Id is associated to the task "Target Email Sends" and the result was: 

[
    {
        "id": "9b9f830f-41dc-4ba1-9313-2417e2882981",
        "createdDate": "2018-08-02T15:07:18.429Z",
        "modifiedDate": "2018-10-31T04:15:40.833Z",
        "modifiedByUserName": "TONY\\main",
        "customProperties": [],
        "app": {
            "id": "074408c4-7217-4382-9904-7edb6130d746",
            "name": "Target - Email Sends",
            "appId": "",
            "publishTime": "2018-07-31T19:15:51.420Z",
            "published": true,
            "stream": {
                "id": "1e2224e8-fa38-4685-b617-47d7650d9327",
                "name": "publics",
                "privileges": null
            },
            "savedInProductVersion": "12.145.4",
            "migrationHash": "98d482c3f964dccf69cbfb9a00e0c048ea6eb221",
            "availabilityStatus": 0,
            "privileges": null
        },
        "isManuallyTriggered": false,
        "operational": {
            "id": "21e609ea-06df-425a-b81a-0cf66559964e",
            "lastExecutionResult": {
                "id": "f97eb3fa-ec5b-4f8a-87d2-e2bb50b19899",
                "executingNodeName": "qlik-node2.ad.TONY.com",
                "status": 8,
                "startTime": "2018-12-04T04:30:54.053Z",
                "stopTime": "2018-12-04T04:31:23.959Z",
                "duration": 29906,
                "fileReferenceID": "b14bf6b9-c6a9-46ba-bfeb-2640e54276d0",
                "scriptLogAvailable": false,
                "details": [
                    {
                        "id": "3db3be1f-af89-41d8-b5a7-6e71586d5f48",
                        "detailsType": 2,
                        "message": "Trying to start task. Sending task to slave scheduler qlik-node2.ad.TONY.com",
                        "detailCreatedDate": "2018-12-04T04:30:54.272Z",
                        "privileges": null
                    },
                    {
                        "id": "31430c31-d8bb-4526-a736-c0802c49516b",
                        "detailsType": 2,
                        "message": "Changing task state from Triggered to Started",
                        "detailCreatedDate": "2018-12-04T04:30:54.412Z",
                        "privileges": null
                    }
                ],
                "privileges": null
            },
            "nextExecution": "2018-12-05T04:30:54.000Z",
            "privileges": null
        },
        "name": "T	",
        "taskType": 0,
        "enabled": true,
        "taskSessionTimeout": 1440,
        "maxRetries": 0,
        "tags": [],
        "privileges": null,
        "schemaPath": "ReloadTask"
    }
]

In the picture appear 2018-12-03 23:30 (yesterday almost midnight) but in the response to the QRS API  "lastExecutionResult" in "operational" block has as "startTime" "2018-12-04T04:30:54.053Z" .

Then, how can I know the last date of execution of the task? and that is equal to the one shown by Qlik in its dashboard.

 

Labels (4)
1 Solution

Accepted Solutions
Levi_Turner
Employee
Employee

The time is stored as UTC without timezone off-set.

Example from my end:

{
  "id": "bc193abd-707f-4dfc-b33b-0f4b3d9bc877",
  "createdDate": "2018-10-04T16:22:31.404Z",
  "modifiedDate": "2018-10-04T16:22:31.404Z",
  "modifiedByUserName": "DOMAIN\\USERID",
  "customProperties": [],
  "app": {
    "id": "6e794c0a-6913-4179-ab17-06b8a5f1c8f7",
    "name": "Random Data",
    "appId": "",
    "publishTime": "2018-06-28T19:04:06.06Z",
    "published": true,
    "stream": {
      "id": "aaec8d41-5201-43ab-809f-3063750dfafd",
      "name": "Everyone",
      "privileges": null
    },
    "savedInProductVersion": "12.244.5",
    "migrationHash": "98d482c3f964dccf69cbfb9a00e0c048ea6eb221",
    "availabilityStatus": 0,
    "privileges": null
  },
  "isManuallyTriggered": false,
  "operational": {
    "id": "48e96c6e-f574-4763-894c-d9e21cd34576",
    "lastExecutionResult": {
      "id": "561077b8-97ce-42a7-be3a-ef1cf3f94dae",
      "executingNodeName": "Sense.Company.com",
      "status": 7,
      "startTime": "2018-12-04T21:16:02.355Z",
      "stopTime": "2018-12-04T21:16:13.901Z",
      "duration": 11546,
      "fileReferenceID": "c14f8314-aa22-4185-b363-d6d52cb6ff6a",
      "scriptLogAvailable": false,
      "privileges": null
    },
    "nextExecution": "1753-01-01T00:00:00Z",
    "privileges": null
  },
  "name": "foo1",
  "taskType": 0,
  "enabled": true,
  "taskSessionTimeout": 1440,
  "maxRetries": 0,
  "tags": [],
  "privileges": null,
  "schemaPath": "ReloadTask"
}

The key times for the task (operational) is:

  • "startTime": "2018-12-04T21:16:02.355Z"
  • "stopTime": "2018-12-04T21:16:13.901Z"

The local time would be 4:16PM EST. Translating that into 24 hour format, would be 16:14. And since I am EST, I am -5 off-set to UTC so it now becomes 21:16.

Make sense?

View solution in original post

1 Reply
Levi_Turner
Employee
Employee

The time is stored as UTC without timezone off-set.

Example from my end:

{
  "id": "bc193abd-707f-4dfc-b33b-0f4b3d9bc877",
  "createdDate": "2018-10-04T16:22:31.404Z",
  "modifiedDate": "2018-10-04T16:22:31.404Z",
  "modifiedByUserName": "DOMAIN\\USERID",
  "customProperties": [],
  "app": {
    "id": "6e794c0a-6913-4179-ab17-06b8a5f1c8f7",
    "name": "Random Data",
    "appId": "",
    "publishTime": "2018-06-28T19:04:06.06Z",
    "published": true,
    "stream": {
      "id": "aaec8d41-5201-43ab-809f-3063750dfafd",
      "name": "Everyone",
      "privileges": null
    },
    "savedInProductVersion": "12.244.5",
    "migrationHash": "98d482c3f964dccf69cbfb9a00e0c048ea6eb221",
    "availabilityStatus": 0,
    "privileges": null
  },
  "isManuallyTriggered": false,
  "operational": {
    "id": "48e96c6e-f574-4763-894c-d9e21cd34576",
    "lastExecutionResult": {
      "id": "561077b8-97ce-42a7-be3a-ef1cf3f94dae",
      "executingNodeName": "Sense.Company.com",
      "status": 7,
      "startTime": "2018-12-04T21:16:02.355Z",
      "stopTime": "2018-12-04T21:16:13.901Z",
      "duration": 11546,
      "fileReferenceID": "c14f8314-aa22-4185-b363-d6d52cb6ff6a",
      "scriptLogAvailable": false,
      "privileges": null
    },
    "nextExecution": "1753-01-01T00:00:00Z",
    "privileges": null
  },
  "name": "foo1",
  "taskType": 0,
  "enabled": true,
  "taskSessionTimeout": 1440,
  "maxRetries": 0,
  "tags": [],
  "privileges": null,
  "schemaPath": "ReloadTask"
}

The key times for the task (operational) is:

  • "startTime": "2018-12-04T21:16:02.355Z"
  • "stopTime": "2018-12-04T21:16:13.901Z"

The local time would be 4:16PM EST. Translating that into 24 hour format, would be 16:14. And since I am EST, I am -5 off-set to UTC so it now becomes 21:16.

Make sense?