Software Update Manager (SUM) - OSQL call failed for MSSUPGGETREL error

[Former Member]

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

[former_member189797 · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Gaurav,

My issue is also solved.

Marco

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

Thanks for the reply & Snote.  The variables are set accurately.  I have attached a copy of the main log files if you want to check them out.  Perhaps they will lend a clue. Thanks again

MSSTPINFO.txt.zip

TOOLOUT.txt.zip

SAPup_troubleticket.txt.zip

[Former Member]

Hi Venkat,

I am patching our Solution Manager 7.1 to the latest patch available using SUM (also at the latest patch) and getting stuck exactly at the same point. Environment variables are also correctly set.

Thanks for any input you can provide.

Marco