Error in dbo.spri_CPU: No data in dbo.dc_processor

Oct 21, 2009 at 9:35 PM

No data coming into repository. Log file shows the following:

10/21/2009 4:14:56 PM     Status:       RUN  
10/21/2009 4:14:56 PM     Status:      Initializing collector: WMI
10/21/2009 4:14:56 PM     Status:     Running WMI collector
10/21/2009 4:14:56 PM     Status:      Opening Unit 1 (OS/CS)
10/21/2009 4:14:56 PM     Status:       Collecting Win32_OperatingSystem
10/21/2009 4:14:57 PM     Status:       Collecting Win32_ComputerSystem
10/21/2009 4:14:57 PM     Status:       Collecting Win32_Processor
10/21/2009 4:15:01 PM     ERROR:     Procedure or function 'spri_CPU' expects parameter '@Name', which was not supplied.
10/21/2009 4:15:01 PM     Status:      Closing Unit 1
10/21/2009 4:15:01 PM     ERROR:       dbo.spri_CPU
10/21/2009 4:15:01 PM     WARNING:       WMI Collector encountered critical error. Abandoning Collector.
10/21/2009 4:15:01 PM     ERROR:     dbo.spri_CPU
10/21/2009 4:15:01 PM     ERROR:     20.0.0.163: Collection failed;  Error:StorSyntaxErrorNonQuery;  Provider Error: 201
10/21/2009 4:15:01 PM     ERROR:     Critical Repository Failure
10/21/2009 4:15:01 PM         SQLH2 is shutting down
10/21/2009 4:15:01 PM         Closing Log

Investigating the procedure, I find where the table that it might be failing on (dbo.dc_processor) which has no data in it. Is that the problem? Is something supposed to populate the reference tables?

Oct 21, 2009 at 9:39 PM

Some more info...

Server 2008 + SQLServer 2008

Found another item of interest...

10/21/2009 4:37:00 PM         
10/21/2009 4:37:00 PM         Opening Log
10/21/2009 4:37:00 PM         SQLH2  ver. 2.1.4.0 3/16/2009 6:34:28 PM
10/21/2009 4:37:00 PM     Status:     Init
10/21/2009 4:37:00 PM     WARNING:     There are no PerfProviders in the config file
10/21/2009 4:37:00 PM     Status:      Initializing repository: (local)
10/21/2009 4:37:01 PM     Status:      Repository Database: SQLH2Repository
10/21/2009 4:37:01 PM     INFO:     host_id = 1
10/21/2009 4:37:01 PM     Status:     Starting RUN  
10/21/2009 4:37:01 PM     Status:     Registering Run
10/21/2009 4:37:01 PM     INFO:     run_id = 2
10/21/2009 4:37:01 PM     Status:     Starting Targets processing  
10/21/2009 4:37:01 PM     Status:     Initializing Target: 20.0.0.163
10/21/2009 4:37:01 PM     Status:       registering Server
10/21/2009 4:37:01 PM     INFO:     srv_id = 1; signature = 34b1c3fe-58de-41f5-ac2f-52de9a8abb67
10/21/2009 4:37:01 PM     Status:     Scanning Registry on 20.0.0.163
10/21/2009 4:37:01 PM     Status:       registering instance 20.0.0.163
10/21/2009 4:37:19 PM     ERROR:     A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
10/21/2009 4:37:19 PM     WARNING:     Instance 20.0.0.163 is not presently running or unavailable. SQL Collector will not attempt connecting to the instance
10/21/2009 4:37:19 PM     Status:     Trying to obtain SQL Server version form the registry
10/21/2009 4:37:19 PM     INFO:     inst_id = 1
10/21/2009 4:37:19 PM     INFO:     version: 10.0.2531.0
10/21/2009 4:37:19 PM     WARNING:     No running SQL Server instances on the box
10/21/2009 4:37:19 PM     Status:       RUN  
10/21/2009 4:37:19 PM     Status:      Initializing collector: WMI
10/21/2009 4:37:19 PM     Status:     Running WMI collector
10/21/2009 4:37:19 PM     Status:      Opening Unit 1 (OS/CS)
10/21/2009 4:37:19 PM     Status:       Collecting Win32_OperatingSystem
10/21/2009 4:37:20 PM     Status:       Collecting Win32_ComputerSystem
10/21/2009 4:37:20 PM     Status:       Collecting Win32_Processor
10/21/2009 4:37:22 PM     ERROR:     Procedure or function 'spri_CPU' expects parameter '@Name', which was not supplied.
10/21/2009 4:37:22 PM     Status:      Closing Unit 1
10/21/2009 4:37:22 PM     ERROR:       dbo.spri_CPU
10/21/2009 4:37:22 PM     WARNING:       WMI Collector encountered critical error. Abandoning Collector.
10/21/2009 4:37:23 PM     ERROR:     dbo.spri_CPU
10/21/2009 4:37:23 PM     ERROR:     20.0.0.163: Collection failed;  Error:StorSyntaxErrorNonQuery;  Provider Error: 201
10/21/2009 4:37:23 PM     ERROR:     Critical Repository Failure
10/21/2009 4:37:23 PM         SQLH2 is shutting down
10/21/2009 4:37:23 PM         Closing Log

No SQLServer?! Huh?

Oct 21, 2009 at 9:43 PM

More info (I'm hogging this thread...feel free to comment/complain) :) Changed xml file to point to name instead of ip.

10/21/2009 4:40:00 PM         
10/21/2009 4:40:00 PM         Opening Log
10/21/2009 4:40:00 PM         SQLH2  ver. 2.1.4.0 3/16/2009 6:34:28 PM
10/21/2009 4:40:00 PM     Status:     Init
10/21/2009 4:40:00 PM     WARNING:     There are no PerfProviders in the config file
10/21/2009 4:40:00 PM     Status:      Initializing repository: (local)
10/21/2009 4:40:01 PM     Status:      Repository Database: SQLH2Repository
10/21/2009 4:40:01 PM     INFO:     host_id = 1
10/21/2009 4:40:01 PM     Status:     Starting RUN  
10/21/2009 4:40:01 PM     Status:     Registering Run
10/21/2009 4:40:01 PM     INFO:     run_id = 3
10/21/2009 4:40:01 PM     Status:     Starting Targets processing  
10/21/2009 4:40:01 PM     Status:     Initializing Target: HOSTINGDB02
10/21/2009 4:40:01 PM     Status:       registering Server
10/21/2009 4:40:01 PM     INFO:     srv_id = 2; signature = 91659b87-a159-4056-8903-307380805431
10/21/2009 4:40:01 PM     Status:     Scanning Registry on HOSTINGDB02
10/21/2009 4:40:01 PM     Status:       registering instance HOSTINGDB02
10/21/2009 4:40:01 PM     INFO:     inst_id = 1
10/21/2009 4:40:01 PM     INFO:     version: 10.0.2531.0
10/21/2009 4:40:01 PM     Status:       RUN  
10/21/2009 4:40:01 PM     Status:      Initializing collector: WMI
10/21/2009 4:40:01 PM     Status:     Running WMI collector
10/21/2009 4:40:01 PM     Status:      Opening Unit 1 (OS/CS)
10/21/2009 4:40:01 PM     Status:       Collecting Win32_OperatingSystem
10/21/2009 4:40:02 PM     Status:       Collecting Win32_ComputerSystem
10/21/2009 4:40:02 PM     Status:       Collecting Win32_Processor
10/21/2009 4:40:04 PM     ERROR:     Procedure or function 'spri_CPU' expects parameter '@Name', which was not supplied.
10/21/2009 4:40:04 PM     Status:      Closing Unit 1
10/21/2009 4:40:04 PM     ERROR:       dbo.spri_CPU
10/21/2009 4:40:04 PM     WARNING:       WMI Collector encountered critical error. Abandoning Collector.
10/21/2009 4:40:04 PM     ERROR:     dbo.spri_CPU
10/21/2009 4:40:04 PM     ERROR:     HOSTINGDB02: Collection failed;  Error:StorSyntaxErrorNonQuery;  Provider Error: 201
10/21/2009 4:40:04 PM     ERROR:     Critical Repository Failure
10/21/2009 4:40:04 PM         SQLH2 is shutting down
10/21/2009 4:40:04 PM         Closing Log

Ok... so no errors and weird messages but still no go. @Name not supplied?

Oct 27, 2009 at 6:51 AM

It appears your WMI provider didn't return CPU name. That is actually quite strange.

If you run debug version you will exact statement in the log.

This would be quite easy to fix in the code, although I'm not sure what to default it to. What is the CPU on that box?