on 11-01-2012 5:39 PM
In an effort to support pack our production ECC system (PE1) from ECC 6.0 Support pack 4 to support pack 5. I am doing some test support packing on our
sandbox system (SE3). This is single ABAP stack server (windows 2008R2 backended in SQL 2008 R2), that has been restored with our production ECC DB (PE1) and is functioning fine. I am only getting partly started with
the SUM install process, stalling out on the following error:
Severe error(s) occured in phase PREP_PRE_CHECK/INITPUT_PRE!
Last error code set: OSQL call failed for MSSUPGGETREL<br/>
I have googled all over the web and can't seem to find anything on it. I'm hoping that I am missing something easy. Has anyone experienced this problem before and figured out how to rectify?
Thanks in advance
Hello,
Please check the Note #1690835 - MSS: Add. Info. - Software Update Manager 1.0 SP4.
------------------------------------------------------------
o 23/April/2010
ABAP/ABAP+JAVA:
SQLCMD must be installed on the central instance host as a
prerequisite for any update (EhP installation) of an SAP system
running on SQL Server 2005 and higher. Especially in case of a
distributed SAP system (i.e. database instance and central
instance are not running on the same host), SQLCMD might not be
installed when following the SAP installation documentation.
SQLCMD is part of the "Feature Pack for Microsoft SQL Server" and
can be downloaded at:
- http://www.microsoft.com/downloads/details.aspx?familyid=d09c1
d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en (for SQL Server
2005)
- http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E
9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en (for SQL Server
2008)
- http://www.microsoft.com/download/details.aspx?id=29065 (for
SQL 2012) -> Microsoft® SQL Server® 2012 Command Line
Utilities
You can check whether SQLCMD is installed by calling the
following command from the command line:
sqlcmd -?
SQLCMD shows the version at the beginning of the output, e.g.
Version 9.00.4035.00 NT AMD64.
If sqlcmd can still not be found, check if the path to sqlcmd
(usually %ProgramFiles%\Microsoft SQL Server\<ver>\Tools\Binn) is
part of your PATH environment variable. If this is not the case,
please add the path to the PATH envrionment variable and restart
SUM.
---------------------------------------------------------------------
please check this.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Gaurav - Thanks for the reply - your advise solved my issue.
For future people who experience the problem I downloaded and installed the 'Microsoft SQL Server 2008 Command Line Utilities' found here > http://www.microsoft.com/en-us/download/details.aspx?id=16177 on the affected server
After doing this I had to update the system 'path' variable to include C:\Program Files\Microsoft SQL Server\100\Tools\Binn on the server as well
I then restarted SUM and was able to get past the 'OSQL call failed for MSSUPGGETREL' error. Thanks again
Hi Gaurav,
I am sorry to writing this to old blog, I got same error during my SUM process for upgrading GRC plugins on ECC system.
Error is:-
Severe error(s) occurred in phase PREP_PRE_CHECK/DBCHK_PRE!
Last error code set: OSQL call failed for MSSUPGGETREL<br/>
I see sqlcmd.exe and dll's and environment variables- system patch updated with C:\Program Files\Microsoft SQL Server\100\Tools\Binn
can you/anyone tell me solution to over come this.
Thanks,
Venu
To give you more information...
errors from SAPup.log..
CURRENTPHASE PREP_PRE_CHECK/DBCHK_PRE
...started at 20150611195326
# DB Environment for SAPup:
# DBATYPE MSSQL
# DBAHOME NOTFOUND
# DBAEXE NOTFOUND\bin
# DBACONN "SE1"
# DBAVERS 11.00.3460.00
# SAPVERS 740
# DBASUBTYPE STANDARD
# DBAOPSYS SAME_SYS
# DBA2CONN ""
..finished at 20150611195327 with status ABORTED.
# Error message set: 'OSQL call failed for MSSUPGGETREL
'
...begin dialog at 20150611195328
Hi Steve,
Make sure that the environment variables dbms_type, MSSQL_SERVER MSSQL_DBNAME, MSSQL_SCHEMA are set correctly for your <sid>adm-user.
check this note 1684408
Still if you get error update me with SUM/abap/log/ recent log files
Thanks,
Venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.