Thursday, January 22, 2009

EventID 10102

The OpsMgr eventlog of the RMS logs this EventID many times per hour:
Event Type: Error
Event Source: Health Service Modules
Event Category: None
Event ID: 10102
Date: xx-x-xxxx
Time: xx:xx:xx
User: N/A
Computer: xxxx
In PerfDataSource, could not resolve counter SQLServer:SSIS Pipeline, Rows written, . Module will be unloaded.

One or more workflows were affected by this.

Workflow name: Microsoft.SQLServer.2005.SQLServer_SSIS_Pipeline_Rows_Written_15.0_minutes_2_Rule
Instance name: MsDtsServer
Instance ID: {8CF3D89A-4393-20C5-1178-6715DD04AA4F}
Management group: xxxxxxx
This happens during the installation of SQL Server on a x64 server. SQL Server Setup sets the registry entry for the x64 SQL Server:SSIS Pipeline performance object to the wrong location. Thus the perfomance counter cannot be found.

The solution is simple:
Open a cmd-prompt on the SQL-server and type these commands, each followed by an :
cd DriveLetter:\Program Files\Microsoft SQL Server\90\DTS\Binn
unlodctr dtspipeline
lodctr dtsperf.ini

This should solve the problem. There is a KB article about this issue: KB941154

Sometimes step 2 in this KB article is needed as well (editing the registry). There is an easy way to check whether the mentioned steps have helped: Start Perfmon and check whether the counter 'SQL Server:SSIS Pipeline' is present. See screendump:

No comments: