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

[Former Member]

Hi All,

We are in process of updating our PI 7.1 machine to Stack 20 using SUM and we are facing the below error in the preprocessing phase,

When checked the SAPup.ECO logs found the below error,

"

EXECUTING D:\usr\sap\NPI\SUM\abap\exe\tp.EXE "pf=D:\usr\sap\NPI\SUM\abap\var\ACTUPG.TPP" put NPI

This is D:\usr\sap\NPI\SUM\abap\exe\tp.EXE version 380.40.04 (release 722, unicode enabled)

Looking for effective putsteps ... ... ready (looking for putsteps)

stopping on error 12 during DD ACTIVATION

tp returncode summary:

TOOLS: Highest return code of single steps was: 12

WARNS: Highest tp internal warning was: 0118

tp finished with return code: 12

meaning:

  A tool used by tp aborted

tp=>sapparam(1c): No Profile used.

tp=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: stopping on error 12 during DD ACTIVATION

SAPup> Process with PID 9024 terminated with status 12 at 20151222004549!"

"

After checking other logs in the log directory of SUM found this error in the log YI3A235815.NPI,

"

EDO533X*** Activate objects at level "1"

4 EDO631 * Parallel execution with maximal "2" concurrent tasks *

4 EDO677 Total of "7.074" objects with &3"3.850.200" costs in &2"29" tasks

3WEDO644X"00:43:56" <- task "00006" receiving error ["sapnw03_NPI_04"] "(4 Sek)"

3WEDO641             RC="2": "SQL error 2812 occurred: Could not find stored pro""cedure 'sap_get_index_type'."

4 ED0349             Objects: "TABL /BDL/JOBWATCH" - "TABL /SDF/BW_PC_STACK_LT"

3WEDO644 "00:43:58" <- task "00005" receiving error ["sapnw03_NPI_04"] "(7 Sek)"

3WEDO641             RC="2": "SQL error 2812 occurred: Could not find stored pro""cedure 'sap_get_index_type'."

4 ED0349             Objects: "DTEL SWL_DYNCOL1" - "TABL /BDL/HOST"

3WEDO644 "00:44:01" <- task "00007" receiving error ["sapnw03_NPI_04"] "(5 Sek)"

3WEDO641             RC="2": "SQL error 2812 occurred: Could not find stored pro""cedure 'sap_get_index_type'."

4 ED0349             Objects: "TABL /SDF/CCBC_V_OBJ_CRIT_S" - "TABL /SDF/CPH_ENDDATE"

3WEDO644 "00:44:04" <- task "00009" receiving error ["sapnw03_NPI_04"] "(3 Sek)"

3WEDO641             RC="2": "SQL error 2812 occurred: Could not find stored pro""cedure 'sap_get_index_type'."

4 ED0349             Objects: "TABL /SDF/DSWP_CCMS_NONAVAIL_DETAIL" - "TABL /SDF/LOAD_HISTORY"

3WEAD010 "Reduce number of processes for" "sapnw03_NPI_04" "to" "1"

3WEDO644 "00:44:04" <- task "00008" receiving error ["sapnw03_NPI_04"] "(6 Sek)"

3WEDO641             RC="2": "SQL error 2812 occurred: Could not find stored pro""cedure 'sap_get_index_type'."

4 ED0349             Objects: "TABL /SDF/CPH_STARTDATE" - "TABL /SDF/DSWP_CCMS_MSG_VALUE"

3WEAD010 "Reduce number of processes for" "sapnw03_NPI_04" "to" "0""

"

I have already checked the note  460268 - SQL error 2812: Could not find stored procedure but it was not helpful as I could not execute any scripts on my shadow instance. Also I have changed the tp file downloading the latest one from market place, not helpful though.

Kindly help me get through this.

P.S : We are on SQL 2008 and Windows 2003

Regards,

Nikilesh

[cherry_tian · Accepted solution]

Hi， Nikilesh

Which support package were the system on before you started upgrade? And what is the SQL Server release before? Why I ask so is because when SAP PI 7.1 was produced, SQl Server 2008 was not yet available. Therefore, the 7.1 product versions do not support SQl Server 2008 (R2) in their initial release. Please see note 1076022 about the details.

The minimum support package level of PI 7.1 for SQl Server 2008 is SAP_BASIS SP8.

So if you were on SQL Server 2005 with lower SP than SP8, you need to upgrade the stack 20 on SQL Server 2005 first and then upgrade SQl Server to 2008.

Best regards.

Cherry.

[Former Member · Accepted solution]

Hi Cherry,

It is a freshly installed PI 7.1 Dual stack machine on MS SQL 2008. I had checked for the compatibility for PI 7.1 on MS SQL 2008 on Win 2003 before installing and we did not face any problem then. Now when we are updating the patches we are encountering this error.

The SAP_BASIS version is SP4.

How would you suggest us to proceed in this scenario?

Regards,

Nikilesh

[cherry_tian · Accepted solution]

Hi， Nikilesh

On PAM (product availability matrix),  additional information column has a note to reminder checking note 1076022 for the entry MS SQL 2008 and WIN 2003 of PI 7.1. So it is important to check the note for additional information about product PI 7.1.

Note 1076022 says, you cannot use the Netweaver 7.1 installation package to install a new SAP system on SQL Server 2008 (R2). As a workaround, you need to install on SQL Server 2005 , apply the required SAP_BASIS and SAP_BW support packages, apply a supported SAP kernel and then upgrade the database release to SQL Server 2008 (R2).

I am afraid there will be a lot of unexpected errors in the coming processing because the current scenario hasn't been tested and supported. So I suggest you following note 1076022's instruction to re-install the PI 7.1.

Best regards.

Cherry

[Former Member]

Closing this thread as we did a fresh installation with Oracle11g and were able to complete the support pack update.

Regards,

Nikilesh

[Sriram2009]

Hi Nikilesh,

Just do the full system restart and then try again in the same phase, Still if the problem persists update the latest log.

Regards

SS

[Former Member]

Hi,

Check this note

555623 - SQL error 208 or 2812 in a SQL script

Regards,

Prithviraj.

[Former Member]

Hi Sriram,

Even after restarting the whole server we encountered the same error.

@Prithiviraj,

Thank you for the note, but I think its not useful in this scenario.

Regards,

Nikilesh