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.