Scheduled Global I/O Action Type 'Arm/Disarm Area' shows 'Invalid Action' after OnGuard Upgrade

Symptom

On the Scheduler screen in System Administration, Scheduled Action Type Arm/Disarm Area appears as Invalid Action after upgrading OnGuard.

Resolution

 
Option 1: There is a manual workaround that does not require running a database query. The user can simply launch System Administration, select the Arm/Disarm Area action in the Scheduler tab showing Invalid Action, and then click [Modify] [OK]. This causes System Administration to update the OnGuard database with the correct values. This must be done for each Arm/Disarm Area entry displayed in Scheduler showing Invalid Action.
 
Option 2:
If the OnGuard system uses a SQL Server database, execute the following query against the AccessControl database after backing up the database:
UPDATE SINGLE_DEVICE_ACTION
SET PANELID=aa.panelid
FROM ACCOUNT_AREA aa
INNER JOIN SINGLE_DEVICE_ACTION sda
INNER JOIN ACTION A
ON a.ACTIONID = sda.ACTIONID
ON sda.DEVICEID = aa.ACCOUNT_AREAID
WHERE A.ACTION_TYPEID = 28
AND sda.PANELID = -1

 
If the OnGuard system uses an Oracle database, execute the following query after backing up the database:
UPDATE SINGLE_DEVICE_ACTION
SET PANELID =
(SELECT PANELID
FROM ACCOUNT_AREA AS aa
WHERE (ACCOUNT_AREAID = SINGLE_DEVICE_ACTION.DEVICEID))
WHERE (ACTIONID IN
(SELECT ACTIONID
FROM ACTION AS a
WHERE (ACTION_TYPEID = 28))) AND EXISTS
(SELECT PANELID
FROM ACCOUNT_AREA AS aa
WHERE (ACCOUNT_AREAID = SINGLE_DEVICE_ACTION.DEVICEID)) AND (PANELID = - 1)

Applies To

OnGuard (All versions)

Additional Information

None