2

Closed

function 'spri_product' expects parameter '@ver'

description

This is the newset error since I started using the lastest version of the SQLH2.
 
ERROR: Procedure or function 'spri_product' expects parameter '@ver', which was not supplied.
10/22/2008 12:04:55 PM Status: Closing Unit 7
10/22/2008 12:04:55 PM ERROR: dbo.spri_product
10/22/2008 12:04:55 PM WARNING: WMI Collector encountered critical error. Abandoning Collector.
10/22/2008 12:04:55 PM ERROR: dbo.spri_product
10/22/2008 12:04:55 PM ERROR: BDC-TAPPDB001: Collection failed; Error:StorSyntaxErrorNonQuery; Provider Error: 201
10/22/2008 12:04:55 PM ERROR: Critical Repository Failure
10/22/2008 12:04:55 PM SQLH2 is shutting down
10/22/2008 12:04:55 PM Closing Log
 
Also getting this error with the lastestversion.
 
 
Status: Opening Unit 7 (Products)
10/17/2008 8:58:29 AM Status: Collecting Win32_Product
10/17/2008 8:58:33 AM ERROR: Procedure or function 'spri_product' expects parameter '@name', which was not supplied.
10/17/2008 8:58:33 AM Status: Closing Unit 7
10/17/2008 8:58:33 AM ERROR: dbo.spri_product
10/17/2008 8:58:33 AM WARNING: WMI Collector encountered critical error. Abandoning Collector.
10/17/2008 8:58:33 AM ERROR: dbo.spri_product
10/17/2008 8:58:33 AM ERROR: BDC-INTRA595: Collection failed; Error:StorSyntaxErrorNonQuery; Provider Error: 201
10/17/2008 8:58:33 AM ERROR: Critical Repository Failure
10/17/2008 8:58:33 AM SQLH2 is shutting down
10/17/2008 8:58:33 AM Closing Log
 
This version fixed reading from 64bit instances but the above instancea are both 32 bit
Closed Dec 19, 2008 at 8:29 PM by pgv
fixed in 2.1.003

comments

JeremyTBrown wrote Dec 15, 2008 at 1:35 PM

Seeing this issue on one of my servers as well, causes a catastrophic failure of the collector. For now I'll exclude this server from my scans until I can determine the root cause.