BAM Alert not firing

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BAM Alert not firing

Viewing 0 reply threads
  • Author
    Posts
    • #23620

      Hi,

      I have a problem understanding how BAM Alerts work. I hope someone here can enlighten me.

      My situation is as follows:

      – I have a pivot table which displays the number of files processed by an orchestration for every customers per time unit. I have to create an alert based on it.
      – I create an alert with the following condition
          + Threshold Less than 1
          + Based on time dimension Duration = 2 minutes
          + No advanced query  

      So, If I understand this correctly, I should receive an alert if there are more than 2 minutes between two file transfers. When the alert is created, it is fired immediately even if the condition is not met. I don’t know why this happens. If I transfer a file and I wait more than two minutes, nothing happens.

      I have looked at the AlertCondition field from the bam_Metadat_AlertCondition table and the value seems right. If I try to run the query on the BAMPrimaryImprot database, it returns what I expect it to. The query is as follows:

      SELECT CASE WHEN Count(*) = 0 THEN 0 ELSE Sum([Count]) END FROM [dbo].[bam_…_PivotTable_RTAView] WHERE ((([Date] > ‘#Start#’) AND ([Date] <= ‘#End#’)))

      I have applied the fix from KB 942235 which solves an issue when the treshold value is 0.

      If anyone can explain to me what I am doing wrong, it would be very appreciated.

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.