Solution : https://service.sap.com/sap/support/notes/1161733 (SAP Service marketplace login required)
Summary :
This SAP Note provides guidance for resolving SQL Server-specific issues encountered during enhancement package installations on SAP NetWeaver 7.0 systems. Key mentions include the transition from using SAPehpi to the Software Update Manager (SUM) for most scenarios except those listed in SAP Note 1302772, which are still handled by SAPehpi. Detailed corrections and preparatory steps are outlined to address mismatches and potential errors during the upgrade phases. The note emphasizes continuous updates and the initial conditions like not having specific environment variables set, ensuring system compatibility with newer SQL Server versions, and required adjustments for successful installations. This note is essential for technicians managing SAP system updates specifically involving SQL Servers to ensure smooth and error-free enhancement package installations.
Key words :
installationdate section description -----------------------------------------------------------------------10/aug/10 3 tp execdbscript19/nov/08 3 phase main_newbas/tabim_post13/oct/08 5 phase main_shdcre/run_rsdbscpy02/12/10 3 prevent main_newbas/tabim_upg problem02/12/10 5 handle main_newbas/tabim_upg problem21/01/11 5 phase parmvnt_shd31/05/11 6 harmless dbif_dsql2_obj_unknowns21/jun/11 5 blocked ume_strings-access prevents instance startup21/jun/11 5, familyid=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c&displaylang=en, familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en, \\sapmnt\<sapsid>\sys\exe\<nuc uc>\<platform>\, 156-[microsoft][sql native client][sql server]incorrect syntax, find stored procedure sap_upg_getrelease14/oct/11 5 error, sum-phase start-j2ee-dual-stack fails, 3 etp399 create3 etp399 index [/bobf/obm_ncat~ctk], phase main_shdrun/pardist_shd basis26/mar/12 3 detect, repair schema/user msimatch----------------------------------------------------------------------- 1 important general information
Related Notes :
| 1656672 | tp getdbobjsize returns size 0 for all objects |
| 1626284 | Central Note - Software Update Manager 1.0 SP04 [lmt_005] |
| 1591328 | Central Note - Software Update Manager 1.0 SP03 [lmt_008] |
| 1492873 | tp execdbscript -- operations are not executed on database |
| 1474270 | Incorrect disk space analysis on Win/MSS |
| 1377270 | NOT NULL-columns missing defaults |
| 1302772 | Central Note - SAP Enhancement Package Installer 7.00 |
| 1276490 | Error during basis EhP 1 on SQL Server 2008 |
| 1260968 | COPYTOSHADOW: R3trans loses reports |
| 1260665 | Error in upgrade phase MAIN_SHDCRE/RUN_RSDBSCPY |
| 1152240 | Setting Up Microsoft SQL Server 2008 (R2) |
| 1086375 | User ID/Schema ID inconsistency in SQL database |
| 1076022 | Release planning for Microsoft SQL Server 2008 (R2) |