on 12-22-2015 11:52 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Closing this thread as we did a fresh installation with Oracle11g and were able to complete the support pack update.
Regards,
Nikilesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.