I have a
problem whereby I can't view information with the Web Reporting tool. For
example if I request the CD-ROM information for any given machine I get an
error back stating:
"usp_smsR04 cannot be
found”.
Contributed By: Hans Schefske [MVP SMS]
It sounds like you
have a missing stored procedure in your SQL database. Open up your SQL
Enterprise Manager and navigate to the SMS Database. Under it you will see
a section for 'Stored Procedures'.
Open it and look for the stored procedure called 'usp_smsR04'
(or the one you are getting the error on). If it's not there, then that's
why Web Reporting couldn’t find it. If it is there check the syntax to make
sure it is correct. You may have to recreate the missing Stored Procedure
by referencing another instance of a SMS database with Web Reports installed
(i.e. lab or test environment) that has the same Stored Procedure.
|
