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

1. Log into the database.
2. 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.