SQL error 2812: Could not find stored procedure.doc

起因：是在一台测试服务器上，安装了多个测试Instance，一次在安装Solution Manager时，将其覆盖在ERP上；

现象：一是登录时显示SAP菜单出错，报错START_CALL_SICK，Database inconsistency: Start Transaction SICK.但运行SICK还是出错，注意到"Can't execute sap_check_if_sick".但运行一些模块Tcode似乎没问题；

二是在激活DDIC object时出错，报错SQL error 2812 occured: Could not find stored procedure 'sap_get_object_type'.

设想：可能是错误的安装删除了SQL procedure

在现象二的帮助里，有The stored procedure must be created in the database. To do this, follow the instructions in SAP Note 460268.

Note Language: English Version: 1 Validity: Valid from 14.12.2001
Summary
Symptom
The following error message is displayed in the status bar or written to a
log file when executing a DDIC function:
SQL error 2812: Could not find stored procedure ...
More Terms
MSSPROCS
Cause and Prerequisites
As of Release 6.20, the access to the database for the return of system
catalog data is executed with stored procedures. These are called in
function modules of the SFMSS_SYSCAT group.
If such a stored procedure is missing, the above SQL Server error message
is issued. It is then transferred to the status bar or the log via the
functions modules.
Solution
Solution
Proceed as follows:
o Execute the MSSPROCS report in SE38.
o Choose the version of your SQL Server as the Database Release value
and confirm with Enter.
o Select the missing stored procedure in the table control.
o Choose "Start". A log must be displayed notifying you that the
procedure was successfully executed.

解决:按照Note上的指引，执行MSSPROCS，选择SQL版本9.0(SQL2000是8.0,SQL2005是9.0),程序已自动选择应安装的组件，点开始运行，很快就运行完提示一系列的脚本已执行。

问题解决。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/167898/viewspace-1008632/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/167898/viewspace-1008632/