Article ID: 933616
Article Last Modified on 9/12/2007
APPLIES TO
- Microsoft Operations Manager (MOM) 2005
SYMPTOMS
When many alerts occur at the same time, Notification Workflow Solution Accelerator version 2.1 does not send notifications in Microsoft Operations Manager (MOM) 2005.
Additionally, the following error message is logged in the Application log:
CAUSE
This problem occurs because the Microsoft SQL Server event provider (spNWEventsQuery) takes a long time to run. This situation is determined by the following factors:
- The number of alerts that come to the system
- The hierarchy of the management packs that are defined in the MOM OnePoint database
- The hierarchy of the computer groups that are defined in the OnePoint database
This situation causes a time-out error in Notification Workflow Solution Accelerator version 2.1. Therefore, Notification Workflow Solution Accelerator does not send notifications.
RESOLUTION
Hotfix information
A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that this article describes. Apply this hotfix only to systems that are experiencing this specific problem.
To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:
Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:
Important notes about this hotfix
- This hotfix works only when the MOM database and Notification Workflow Solution Accelerator are deployed on the same computer. If this is not the case, do not apply this hotfix.
- This hotfix applies only to Notification Workflow Solution Accelerator version 2.1. If version 2.0 is installed, you must upgrade to version 2.1 before you apply the hotfix.
To determine which version of Notification Workflow Solution Accelerator is installed, check the time stamp of the Microsoft Installer (MSI) file that you used to install the current version of Notification Workflow Solution Accelerator. If the time stamp is older than "March 29, 2005 12:00 AM," upgrade to Notification Workflow Solution Accelerator version 2.1. - Before you apply the hotfix that is described in this article, you must apply another hotfix that addresses a table error and missing notifications. To obtain the hotfix, visit the following Microsoft Web site:
- Before you apply the hotfix that is described in this article, you must back up the following Notification Workflow databases:
- NotificationWorkflowNSMain
- NotificationWorkflowNotificationWorkflowApp
How to apply this hotfix
- Run the Notification Workflow Hotfix for Transaction Rate Timeout.msi file.
- Stop the NS$NotificationWorkflow service. To do this, run the following command at a command prompt:
net stop NS$NotificationWorkflow
- Run the NWTimeout-TableCreation.sql script. This script is in the folder in which you installed the hotfix.
- Run the NWTimeout-SPCreation.sql script. This script is in the folder in which you installed the hotfix.
- Run the spPopulatetmpCG stored procedure on the NotificationWorkflowNotificationWorkflowApp database. This step may take a while, depending on the number of computers that are detected by the OnePoint database.
- Run the spPopulatetmpMP stored procedure on the NotificationWorkflowNotificationWorkflowApp database. This step may take a while, depending on the number of rules that are saved in the OnePoint database.
- Start the NS$NotificationWorkflow service. To do this, run the following command at a command prompt:
net start NS$NotificationWorkflow
How to maintain this hotfix
In steps 5 and 6 of the "How to apply this hotfix" section, you ran stored procedures. These stored procedures populate the tables that store the following associations:
- The associations between computers and computer groups
- The associations between rules and management packs
You must periodically run these stored procedures against the tables, depending on the frequency of the database changes. You can manually run the store procedures. Or, you can create a batch file or a Data Transformation Services (DTS) package to automatically run the stored procedures. To do this, follow these steps:
Paste the following text to Notepad.
use NotificationWorkflowNotificationWorkflowApp Go exec spPopulatetmpCG Go exec spPopulatetmpMP Go
- Save the file into a SQL Server script file. Use NWTimeout.sql as the file name.
Create a batch file that contains the following text.
net stop NS$NotificationWorkflow isql.exe -E -S <SQLServer\Instance> -U <Username> -P <Password> -i NWTimeout.sql net start NS$NotificationWorkflow
Note Replace
SQLServer\Instancewith the full name of an instance of SQL Server. ReplaceUsernamewith the user name. ReplacePasswordwith the corresponding password. You can omit the user name and the password if they are not required in the SQL Server configuration.- Run the batch file periodically.
Post-installation information
If the hotfix that you applied does not work, follow these steps:
- Back up the following Notification Workflow databases:
- NotificationWorkflowNSMain
- NotificationWorkflowNotificationWorkflowApp
- Uninstall Notification Workflow Solution Accelerator.
- Manually delete the databases that you backed up in step 1.
- Restore the databases from the backup that you created in step 1.
- Reinstall Notification Workflow Solution Accelerator. During the installation process, select the option to keep the application database.
- Reapply the hotfix that resolves a table error and the missing notifications. To obtain the hotfix, visit the following Microsoft Web site:
Prerequisites
To apply this hotfix, you must have Notification Workflow Solution Accelerator version 2.1 installed on the computer.
Restart requirement
You do not have to restart the computer after you apply this hotfix.
Hotfix replacement information
This hotfix does not replace any other hotfixes.
File information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
| File name | File version | File size | Date | Time | Platform |
|---|---|---|---|---|---|
| Nwtimeout-spcreation.sql | Not applicable | 7,555 | 04-Aug-2006 | 10:24 | Not applicable |
| Nwtimeout-tablecreation.sql | Not applicable | 906 | 04-Aug-2006 | 10:12 | Not applicable |
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
MORE INFORMATION
The SQL Server event provider uses nested cursors to generate the management pack names and the chained computer groups for each alert. This process may take a long time, depending on the number of computer groups and management packs that are defined in MOM 2005. The following table lists the processing statistics that were collected on a laboratory server before this hotfix was applied.
| Number of events that are submitted | Processing time |
|---|---|
| 75 | 15 seconds |
| 278 | 105 seconds |
| 196 | 90 seconds |
| 168 | 104 seconds |
| 139 | 131 seconds |
This hotfix improves the performance of Notification Workflow Solution Accelerator. However, this hotfix does not resolve the problem completely. After you apply this hotfix, Notification Workflow Solution Accelerator can process more alerts in a specified time. The following table lists the processing statistics that were collected on the same laboratory server after this hotfix was installed.
| Number of events that are submitted | Processing time |
|---|---|
| 255 | 5 seconds |
| 201 | 3 seconds |
| 269 | 4 seconds |
| 110 | 1 second |
| 300 | 4 seconds |
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
Additional query words: MOM 2005 NWSA 2.1 2990
Keywords: kbexpertiseinter kbbug kbfix kbhotfixserver kbqfe kbpubtypekc KB933616
