microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Rule Firing Error with MOM Notification Work Application

Subject: Rule Firing Error with MOM Notification Work Application
From: Pete Zerger
Date: Wed, 14 Sep 2005 17:26:29 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
I have installed SQL Notification Services w/ SP1 in my environment, as well
as the MOM 2005 Notification Workflow Solution Accelerator. I am receiving
an error relating to the rule firing. The detailed error message is listed
below. Any advise as to next step in troubleshooting would be appreciated.
The server topology is as follows:
AKOS-RDB-01 - MOM DB Server, SQL Notification Workflow Databases
AKOS-RPT-01 - MOM Rpting Svr, SQL Notification Services, Notification Workflow Application
SQL Notification Services Logs the following error message:

Event Type:     Error
Event Source:   NotificationServices
Event Category: None
Event ID:       4045
Date:           9/14/2005
Time:           6:05:48 PM
User:           N/A
Computer:       AKOS-RPTL-01
Description:
<NotificationServicesEvent>
        <Description>
                The running of the rule failed. Please check the rule.
        </Description>
        <Context>
<EventParameters>
        <ApplicationName>NotificationWorkflowApp</ApplicationName>
        <QuantumId>961</QuantumId>
        <RuleFiringId>3</RuleFiringId>
        <RuleName>AlertSubscriptionEventRule</RuleName>
        <NotificationThrottle>1000</NotificationThrottle>
        <EventClassId>1</EventClassId>
        <SubscriptionClassId>1</SubscriptionClassId>
        <RuleId>1</RuleId>
<RuleAction>SELECT dbo.AlertNotificationNotify( ASUB.SubscriberId, ASUB.SubscriberDeviceName, ASUB.SubscriberLocale,
                                                        NSEE.Guid,
                                                        NSEE.ComputerName,
                                                        NSEE.Description,
NotificationWorkflowNotificationWorkflowApp.dbo.fnAlertSubscriptionEventRule( NSEE.Severity , NSEE.ComputerName ,NSEE.Name),
                                                        NSEE.Owner,
                                                        NSEE.RepeatCount,
                                                        NSEE.Severity,
                                                        NSEE.Source,
                                                        NSEE.TimeAdded,
                                                        NSEE.TimeofFirstEvent,
                                                        NSEE.TimeofLastEvent,
                                                        NSEE.TimeRaised,
                                                        NSEE.ManagementPackName,
                                                        ASUB.ComputerGroupName,
                                                        
ASUB.SubscriberDeviceAddress,
                                                        ASUB.LimitedText,
                                                        NSEE.ServerLocalTime,
NotificationWorkflowNotificationWorkflowApp.dbo.fnGetSeverityLevelText( NSEE.Severity )) FROM NSAlertEventEvents NSEE,
                                                        AlertSubscription ASUB,
                                                        AlertEventChron AEC
                                                WHERE
                                                        NSEE.EventBatchID  >= 
AEC.PreviousEventBatchID
                                                        AND
                                                        (ASUB.ComputerName = 
NSEE.ComputerName OR ASUB.ComputerName = '*')
                                                        AND
                                                        ASUB.Severity <= 
NSEE.Severity
                                                        AND
                                                        (ASUB.Source = 
NSEE.Source OR ASUB.Source = '*')
                                                        AND
( (NSEE.Description LIKE '%' + ASUB.Description + '%') OR (ASUB.Description = '*') )
                                                        AND
( (ASUB.ManagementPackName = NSEE.ManagementPackName) OR (ASUB.ManagementPackName = '*') )
                                                        AND
                                                        (1 = 
dbo.SchedulePermitted( ASUB.SubscriberId,getDate() ) )
                                                        AND
( (NSEE.ComputerGroupName LIKE '%' + ASUB.ComputerGroupName + '%') OR (ASUB.ComputerGroupName = '*') )</RuleAction>
        <StoredProcedureName>NSFire1</StoredProcedureName>
</EventParameters>

<SqlServerError>
Error Number: 0 Source: .Net SqlClient Data Provider Number: 0 State: 0 Class: 16 Server: AKOS-RDB-01 Message: Cannot load the DLL Microsoft_SqlServer_NotificationServices_XP_2_0_3008_0.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). Procedure: xp_NSBeginNotifications_2_0_3008_0 Line Number: 27 Error Number: 1 Source: .Net SqlClient Data Provider Number: 0 State: 0 Class: 16 Server: AKOS-RDB-01 Message: Cannot load the DLL Microsoft_SqlServer_NotificationServices_XP_2_0_3008_0.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). Procedure: xp_NSEndNotifications_2_0_3008_0 Line Number: 12 </SqlServerError>
        </Context>
        <Description>
Cannot load the DLL Microsoft_SqlServer_NotificationServices_XP_2_0_3008_0.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). Cannot load the DLL Microsoft_SqlServer_NotificationServices_XP_2_0_3008_0.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
        </Description>
        <Instance>NotificationWorkflow</Instance>
        <ApplicationName>NotificationWorkflowApp</ApplicationName>
        <Component>Generator</Component>
        <Thread>13</Thread>
</NotificationServicesEvent>

For more information, see Help and Support Center at 
http://go.microsoft.com/fwlink/events.asp.



Thanks,

Pete




<Prev in Thread] Current Thread [Next in Thread>