Identifying suspended extract refresh failures about community-tableau-server-insights HOT 5 CLOSED

This was added as the field named "Task State"--just in case anyone was looking for "Is Suspended", and not finding it...like I was for the last half hour, despite being the one who added it.

from community-tableau-server-insights.

Right now, using TS Background Tasks, the only way would likely be to use the Notes field to look for "suspended", and the grab the workbook/data source LUID, and track down the appropriate Task LUID via the REST API. But, we should add a few things to TS Background Tasks to make this easier:

Add Task LUID
Add consecutive failure count
Add "suspend_state" field from any item tables it exists in (just data_alerts and metrics at this time..this may have to be done carefully, as having it NULL for more popular items, such as workbooks and data sources could be pretty confusing)

from community-tableau-server-insights.

Not sure if my screenshot is visible . I used TS Background Tasks ( big Thanks to you for all these data sources) , used this column "Job LUID" to get Luid's of these suspended tasks and copied all these luid's in a excel sheet.

Then used this below mentioned code to remove these failed extract schedules by providing these LUID's but it did not work. It

url1 = "https://tableauserver.com/api/3.7/sites/siteid/tasks/extractRefreshes/"
url2=url1+cell
response = requests.request("DELETE", url2,headers=headers, data = payload)

from community-tableau-server-insights.

Looks like I'm missing something or not looking at right place. Would you mind sharing a solution working for you ?

from community-tableau-server-insights.

Job LUID is different than Task LUID. That's why I was saying I think you'd have to get the actual Item LUID for the workbook/data source, then obtain the Task LUIDs based on those.

from community-tableau-server-insights.