BAM alert not firing

Question

Hi,

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

My situation is as follows:

- I am using BizTalk 2006 R2
- 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 BAMPrimaryImport 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.

Answer 1

Possibly a stupid question from me:
the name of the view is correct, with the thre dots? bam_..._PivotTable_RTAView
That looks odd.

Answer 2

I just removed a part of the view name to avoid posting the name of our system.

Answer 3

Please check if notification service is actually working on your server.

Configuring Notification Services Event Logging
http://msdn.microsoft.com/en-us/library/ms172626(SQL.90).aspx

---

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 4

As far as I can see, Notification Services seem to be running fine. I tried to increase the log level level and I found out that I regurlarly get an information from the BAM Event Provider that says

Alerting for this activity view is disabled, returning.

I also tried to use nscontrol status -name bamalerts and everything seemed normal. The message might indicate the cause of my problem but I don't know how to enable alerts for a specific view. I will have to look into it. If you have any other idea, it would be apreciated.