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@]