Exchange Integration Status - Send Notification on error

Hi,

I would to add an escalation rule to send a notification email when the Exchange Integration fails.

At the moment everything is ok so I have a "SuccessW" value in the field EcngIntegration.exin_SyncStatus

I would like to know what is the value when the Integration fails. Problem is I can't simulate this case because the integration is on production and I can't enable another one on test environment...

Thank you

Valerian

  • 0

    You can get all the translations associated with the exchange integration with the following statement:

    SELECT *

    FROM custom_captions

    WHERE capt_family = 'exin_syncstatus'

    So the code values are:

    Failed

    InProgress

    Interrupt

    Success

    SuccessW

    One thing to bear in mind about the escalation rule. Sometimes, if the tomcat service has an issue, the Exchange integration will not run, and the exin_syncstatus will appear as 'Success' but the last sync time can be a while ago. It may be worth while to build in some logic to look at the last sync time also, so you can be notified if this is significantly greater than the scheduled time.