NW 7.20 upgrade using SUM error with SQL

[Former Member]

Hi All,

I am in the process of upgrading a client from NW 7.20 to 7.40. I have successfully done so with the DEV environment, but i seem to be having issues with the QA server.

SQL 2008 R2 is a distributed installation and resides on a different server. When SUM starts doing its system checks though, it looks locally for the OSQL and SQLCMD files. Unfortunately, these files arent on the server and cannot be installed due to company policy.

How should I go about upgrading the server?

Error message:

“Severe error(s) occurred in phase PREP_PRE_CHECK/INITPUT_PRE!

Last error code set: OSQL call failed for MSSUPGGETREL<br/>”

PHASES log:

1 ETQ201 Entering upgrade-phase "PREP_PRE_CHECK/INITPUT_PRE" ("20140529095730")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000'

4 ETQ399 Environment variables:

4 ETQ399   dbs_mss_schema=<null>

4 ETQ399   auth_shadow_upgrade=<null>

1 ETQ206 Executing pre-phase DB specific actions.

1 ETQ206 Executing pre-phase OS specific actions.

1 ETQ399 Reading value:

1 ETQ399 HKEY_CURRENT_USER\Environment\DIR_LIBRARY

1 ETQ399 failed:

1 ETQ399 ErrorMessage: The system cannot find the file specified.

1 ETQ200 Executing actual phase 'PREP_PRE_CHECK/INITPUT_PRE'.

1 ETQ207 Executing post-phase DB specific actions.

2 ETQ399 Empty putsteps - configuring at least parallel batches and main import processes.

2 ETQ399 Distribute 3 parallel processes to 2 tp and 2 R3trans.

3 ETQ399 20140529095731: PID 6188 execute 'T:\usr\sap\RQ3\SYS\exe\uc\NTAMD64\tp "pf=C:\SUM\abap\var\DEFAULT.TPP" getdbinfo RQ3' , output written to 'C:\SUM\abap\log\TOOLOUT.LOG'.

3 ETQ399 20140529095731: PID 6188 exited with status 0 (time 0.000 real)

3 ETQ399 20140529095731: PID 7248 execute 'C:\Windows\system32\cmd.exe /C copy C:\SUM\abap\bin\MSSUPGGETREL.SQL+C:\SUM\abap\bin\MSSUPGGETREL.SBK C:\SUM\abap\bin\MSSUPGGETREL.SQL' , output written to 'PERS.PRT'.

3 ETQ399 20140529095731: PID 7248 exited with status 0 (time 0.000 real)

1EETQ399 Calling registered function with pattern 'INITPUT*' failed!

1EETQ399 Last error code set is: OSQL call failed for MSSUPGGETREL

1EETQ204 Upgrade phase "INITPUT_PRE" aborted with severe errors ("20140529095731")

Regards,

Nish

[former_member185239]

Dear Nishalan,

You need to install SQLCMD (MSSQL Native Client ) on the CI. Install the MSSQL Native client and it will resolve your issue.

With Regards

Ashutosh Chaturvedi

[Former Member]

Thanks for the quick reply Ashutosh!!!

If I install the required SQL client for the upgrade to continue...would I be able to uninstall it after the upgrade?

[former_member185239]

Hi Nishalan,

Yes you can.

With Regards

Ashutosh Chaturvedi