Alert Management is one of the best data management tools in EAM, but when an unexpected error occurs, it may go unnoticed unless a user checks the History tab of the alert.
Wouldn’t it be great to receive an email notification when an error occurs so that it can be addressed quickly?
There are various ways this configuration can be accomplished:
1. Email Notification Setup for Alerts That do not Generate PM Work Orders
Table: R5ALERTHISTORY
Update and Insert checkboxes checked
Conditions:
alh_errormessage is not equal to E-mail for the alert has not been configured properly.
alh_errormessage is not blank
alh_rstatus is equal to F
Key fields for template mapping:
alh_alert → Alert Management ID
alh_created → Alert Run Date/Time
alh_errormessage → Error Message
2. Email Notification Setup for Alerts That Generate PM Work Orders
Table: R5AUTOWOS
Update checkbox checked, Insert checkbox unchecked
Conditions:
awo_status is equal to IE
Key fields for template mapping:
iawo_alert → Alert Management ID
awo_evaluationdate → Alert Run Date/Time
awo_total → Total WOs to generate
awo_successcount → Total WOs generated successfully
awo_errorcount → Total WOs that failed to generate
The error messages can be found on the Auto-Generated WO Sessions screen in EAM (there may be more than one kind of error listed)
3. Flex Business Rule
For either case above, utilizing Flex SQL for the notification allows for inclusion of other tables and fields, which means that we can include supporting information in the email, such as the Alert Management description.
Rest a little easier knowing that you’ll be notified when an Alert Management error occurs, and should you require additional assistance handling/preventing these errors, please don’t hesitate to contact us!
Tech Wheelhouse, LLC
Comentários