Resources for IT Professionals >
Forums Home
>
BizTalk Server Forums
>
BizTalk Server General
>
BAM alert not firing
BAM alert not firing
- 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.
All Replies
- Possibly a stupid question from me:
the name of the view is correct, with the thre dots? bam_..._PivotTable_RTAView
That looks odd. - I just removed a part of the view name to avoid posting the name of our system.
- 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. - 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.
