Overview
At times, devices with status IN_PROGRESS are stuck in the table policy_device table.
Important: Make a backup before completing any database changes. Any production database changes require written consent from the customer.
Affected versions
Version 4.11
Requirements
SQL knowledge.
Resolution
- Log into the database.
- Execute the query below.
UPDATE sprt_sg_policy_action_history ah
SET ah.action_exec_end_time = sys_extract_utc(systimestamp),
ah.result_code = -3456,
ah.workflow ='STOP_FAIL',
ah.message = 'The policy action has timed out.',
ah.modified = sys_extract_utc(systimestamp),
ah.modified_by = 'id094673',
ah.in_progress = 'N',
ah.retry = 0
WHERE ah.guid = '1'
AND ah.action_exec_end_time IS NULL;
Validation
After the next run of RunAgedResults, the queue should be cleaned.