Notification of Publication Failure
Hello,
Is there a way that users can be notified when a publication fails?
I can see this previous question which showed there is a repository table to see this in BI Office, is there an equivalent in Pyramid?
Thanks,
Alec
1 reply
-
Alec,
You can use the following query to get the information you want:
SELECT tt.task_id , tt.execution_id , te.schedule_id , ts.item_id , tt.start_date , tt.summary , tt.description AS OutputName , ts.name AS ItemName , CASE schedule_data_type WHEN 1 THEN 'Recurring' ELSE 'Once' END AS ScheduleType FROM te_task tt INNER JOIN te_execution te ON tt.execution_id = te.execution_id INNER JOIN te_schedule ts ON te.schedule_id = ts.schedule_id WHERE item_type = 4 AND content_type = 6 AND tt.status IN ( 3, 5 )
The item_type = 4 is for container objects, which include Discover, Present, and Publish content (LINK). The content_type = 6 is for Publications (LINK). Finally, the status IN (3,5) represent execution failure (LINK). I included the Item ID in the query so you could join to the content_tbl_item table if you want more information about the publication in your results. The summary field contains the information regarding the failure but it is a JSON datatype so you may need to parse it to get the actual reason for failure.
This query should work with whichever repository database you are using. If you are not sure of the DB type or name of your repository, you can get the information from your Diagnostic page which is available via the standard Pyramid URL in the format "<MY PYRAMID SERVER>/diagnostic". See 2 examples below:
