Sending mail from Event Processing Policy not working

[Filipp Sudanov]

Can you share the exported .xml (or at least it's part related to this specific rule).
Export was performed in v 2.2, right?

[Mystery]

Yes, XML (from 2.2 version) of this rule ID is here:
Do you need some more details?

<rule id="5">
			<guid>0cdde918-dc08-4096-9418-0197355b2833</guid>
			<flags>7936</flags>
			<alarmMessage>%m</alarmMessage>
			<alarmKey></alarmKey>
			<alarmSeverity>5</alarmSeverity>
			<alarmTimeout>0</alarmTimeout>
			<alarmTimeoutEvent>43</alarmTimeoutEvent>
			<script></script>
			<comments>Network Device is OFFLINE - Send E-mail</comments>
			<sources>
			</sources>
			<events>
				<event id="100032">
					<name>Network_Device_not_OK</name>
				</event>
			</events>
			<actions>
				<action id="16">
					<guid>9b8807fa-f8d4-4ad7-ac5d-61f85cd27795</guid>
					<timerDelay>
0</timerDelay>
					<timerKey>
</timerKey>
				</action>
			</actions>
			<timerCancellations>
			</timerCancellations>
			<pStorageActions>
			</pStorageActions>
		</rule>
	<event id="100032">
			<name>Network_Device_not_OK</name>
			<guid>06cdfff3-bce6-4bbd-8c02-0a444a29e90f</guid>
			<code>100032</code>
			<severity>4</severity>
			<flags>1</flags>
			<message>NetXMS - Cisco Router/Switch/ASA IS OFFLINE!</message>
			<description></description>
		</event>

[Filipp Sudanov]

Can you also select this from the DB and show the output (IDs are less by 1 then what's visible in the UI):

select rule_id, flags, comments from event_policy where rule_id in (59, 78);

[Mystery]

MariaDB [netxms]> select rule_id, flags, comments from event_policy where rule_id in (59, 78);
+---------+-------+-----------------------------------------+
| rule_id | flags | comments                                |
+---------+-------+-----------------------------------------+
|      59 |  7936 | Network Device is OFFLINE - Send E-mail |
|      78 |  7936 | Test new                                |
+---------+-------+-----------------------------------------+
2 rows in set (0,001 sec)

[Filipp Sudanov]

We've fixed a bug in import - when importing from older version of xml state of Action (active or not) was not correctly imported. The fix will be included in next release.

In overall it's better to upgrade just with the same database - new server will upgrade it's structure. Installing a new system and migrating config approach is used not so often, while perfectly valid.

[Mystery]

Ok, thank you for info. 
Is there any way how to fix these bad imported EPPs? Like disable and enable etc? Or should I delete them and create again?

I couldn't upgrade the server, there were many errors in the upgrading process so I had to make it this way.

[Filipp Sudanov]

Yes, pls try disabling and reenabling the actions. If this does not help, we will check how to fix them with a database query.

[Mystery]

I tried disabling (+save) and reenabling (+save) and EP is still not working. If you don't mind, database query would be helpfull.
Thank you:)

[Filipp Sudanov]

This query should list EPP rules that have actions. In the "active" column you should have 1 for active actions and 0 for inactive, but may be you'll get some other values.

select p.comments, a.action_id, a.active from POLICY_ACTION_LIST a INNER JOIN event_policy p ON a.rule_id = p.rule_id;

A query to activate them all should be just this:

update policy_action_list set active = 1;

Note that netxms server should be stopped before running any update queries to the DB.

[Mystery]

Thank you, it helped:)

[Filipp Sudanov]

Great, thanks for the update