Harold Buckner (11/7/2008)

---

Hi Marios

I like the way you handled this task and the great information it provides. However, I had some errors on the 2000 script thats making me do a lot of head scratching. These our all older 2000 instances on either Windows Server 2000 or 2003

Does any of these make any since to you:

Event Type:Warning

Event Source:Health Service Modules

Event Category:None

Event ID:21413

Date:11/7/2008

Time:1:03:57 PM

User:N/A

Computer:GIS

Description:

The Event Policy for the process started at 1:03:56 PM has detected errors in the output. The 'StdErr' policy expression:

\a+

matched the following output:

C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\55987\Custom_SQL2000_Blocking.vbs(153, 9) ADODB.Command: Item cannot be found in the collection corresponding to the requested name or ordinal.

Command executed:"C:\WINDOWS\system32\cscript.exe" /nologo "Custom_SQL2000_Blocking.vbs" gis

Working Directory:C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\55987\

One or more workflows were affected by this.

Workflow name: MomUIGeneratedRule81b439253e464a408ab1d0402a91aad1

Instance name: MSSQLSERVER

Instance ID: {6BEBE62A-DEE0-BEB3-8822-FD9B7941FD43}

Management group: SCOM

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

Event Type:Warning

Event Source:Health Service Modules

Event Category:None

Event ID:21413

Date:11/7/2008

Time:3:43:07 PM

User:N/A

Computer:GIS

Description:

The Event Policy for the process started at 3:43:06 PM has detected errors in the output. The 'StdErr' policy expression:

\a+

matched the following output:

C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\56373\SQL2000Blocking.vbs(100, 1) Microsoft OLE DB Provider for SQL Server: String or binary data would be truncated.

Command executed:"C:\WINDOWS\system32\cscript.exe" /nologo "SQL2000Blocking.vbs" gis

Working Directory:C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\56373\

One or more workflows were affected by this.

Workflow name: MomUIGeneratedRule624f6f0c92d14efc8c6798ca7787892d

Instance name: MSSQLSERVER

Instance ID: {6BEBE62A-DEE0-BEB3-8822-FD9B7941FD43}

Management group: SCOM

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

The SQL-2000 vbs script seems to be failing at lines 100 and 153.

If possible, try running the vbs script from the cmd prompt on the server on which you are getting the errors. Do you still get the same errors?

I will have a look at the code and will send out an update soon.