Symptom
On the Scheduler screen in System Administration, Scheduled Action Type Arm/Disarm Area appears as Invalid Action after upgrading OnGuard.
Resolution
Option 2:
If the OnGuard system uses a SQL Server database, execute the following query against the AccessControl database after backing up the database:
If the OnGuard system uses an Oracle database, execute the following query 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