SQL error 2812 occurred: Could not find stored procedure 'sap_get_index_type'. .)

[Former Member]

PLEASE give me the solution on high priority.

INFO       2014-11-20 04:16:58.314 [iaxxrfcimp.cpp:1011]

           CAbRfcImpl::callFunction

Executing function call INST_EXECUTE_REPORT.

TRACE      2014-11-20 04:16:58.314 [iaxxrfcimp.cpp:1035]

           CAbRfcImpl::performFunctionCall

Calling function module: INST_EXECUTE_REPORT

ERROR      2014-11-20 04:16:58.768 [iaxxrfcimp.cpp:1068]

           CAbRfcImpl::performFunctionCall

FRF-00025  Unable to call function. Error message: SQL error 2812 occurred: Could not find stored procedure 'sap_get_index_type'. .

TRACE      2014-11-20 04:16:58.768 [iaxxrfcimp.cpp:1069]

           CAbRfcImpl::performFunctionCall

RFC failure or system exception raised

TRACE      2014-11-20 04:16:58.768 [iaxxrfcimp.cpp:1070]

           CAbRfcImpl::performFunctionCall

SQL error 2812 occurred: Could not find stored procedure 'sap_get_index_type'.

INFO       2014-11-20 04:16:58.768 [iaxxbjsco.cpp:546]

           CIaJSCo::disconnect_nothrow(000:DDIC:EN:sandbox:00::PRD:)

RFC connection closed.

[Former Member]

Hi,

It's not fully clear to me what you are doing to raise this error. Are you running SWPM? Or are you already using the System after you've upgraded SQL Server to 2012?

Can you goto Transaction ST04 --> Configuration --> Script Maintenance and run all Scripts? This should recreate all SAP written Stored Procedures in the database.

Regards,

Beate

[Sriram2009]

Hi Sagar

1.  You can refer the SAP Note for Error message "SQL error 2812 occurred: Could not find stored"

460268 - SQL error 2812: Could not find stored procedure

2. You can refer the SAP Notes for  upgrade MS Sql 2012

683447 - SAP Tools for MS SQL Server

1651862 - Release planning for Microsoft SQL Server 2012

BR

SS

[Former Member]

i am upgrading the database MSS 2005 to 2012 on windows server 2012

[luisdarui]

Hello Sagar,

Have you gone through the following notes before upgrading your system?

1651862 - Release planning for Microsoft SQL Server 2012

1732161 - SAP Systems on Windows Server 2012 (R2)

Regards,

Luis Darui