cancel
Showing results for 
Search instead for 
Did you mean: 

Error in PREP_IMPORT_SQLDB_CLEARPATCHES

former_member183788
Active Participant
0 Kudos

Dear,

     Stuck with an error in EHP6 upgrade.

Severe error(s) occurred in phase PREP_IMPORT/SQLDB_CLEARPATCHES!

Log archive:"D:\usr\sap\NEQ\SUM\abap\log\SAPup_troubleticket_logs.SAR"

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

meaning:

  connect failed

tp=>sapparam(1c): No Profile used.

tp=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: Connect to NEQ failed (20130903085758, probably wrong environment).

SAPup> Process with PID 13604 terminated with status 232 at 20130903085758!

Accepted Solutions (1)

Accepted Solutions (1)

sunny_pahuja2
Active Contributor
0 Kudos

It looks like tp is not able to connect to the system. Could you please provide more logs for this phase?

Regards,

Sunny

former_member183788
Active Participant
0 Kudos

Sunny,

    Below the error.

SAPup_troubleticket.log

This trouble ticket was created by SAPup on 20130903085958

-------------------------------------------------------------

SAPup broke during phase SQLDB_CLEARPATCHES in module PREP_IMPORT / Import

Error Message: tp failed with return code 232, check D:\usr\sap\NEQ\SUM\abap\log\TPSQLSTD.OUT

-------------------------------------------------------------

-------------------------------------------------------------

Summary of SAPup:

-------------------------------------------------------------

SAPehpi Release:          lmt_004

SAPehpi Version:          SAPup release lmt_004 version 53.000

Start Release:                    701

Target Release:                    731

-------------------------------------------------------------

Summary of host system details:

-------------------------------------------------------------

SID:                              NEQ

Host:                              SAPtest

MS Host:                    SAPtest

GW Host:                    SAPtest

Start Path:                    D:\usr\sap\NEQ\DVEBMGS00\exe

Kernel Path:                    D:\usr\sap\NEQ\DVEBMGS00\exe

-------------------------------------------------------------

Summary of operating system details:

-------------------------------------------------------------

OS Type:                    Windows NT X86_64

OS Version:                    6.0

-------------------------------------------------------------

Summary of database details:

-------------------------------------------------------------

Database Type:                    mss

Database Version:          10.50.4000.00

-------------------------------------------------------------

Summary of RFC details:

-------------------------------------------------------------

Host:                              SAPtest

GW Host:                    SAPtest

Client:                              000

Destination:                    NEQ

Language:                    E

System No.:                    00

-------------------------------------------------------------

-------------------------------------------------------------

TPSQLSTD.OUT

SAPup> Starting subprocess in phase 'SCRIPT_CHK_TOOL4' at 20130903082849

    ENV: DBMS_TYPE=mss

    ENV: JAVA_HOME=C:\Program Files\Java\jdk1.6.0_24

    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

    ENV: PATH=D:\usr\sap\NEQ\DVEBMGS00\exe;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;D:\usr\sap\NEQ\SYS\exe\uc\NTAMD64

    ENV: SAPSYSTEMNAME=NEQ

    ENV: dbs_mss_schema=neq

EXECUTING D:\usr\sap\NEQ\DVEBMGS00\exe\tp.EXE  pf=D:\usr\sap\NEQ\SUM\abap\var\DEFAULT.TPP execdbscript NEQ -x CLCNVTAB.XQL

This is D:\usr\sap\NEQ\DVEBMGS00\exe\tp.EXE version 376.05.49 (release 710, unicode enabled)

Warning: unknown parameter DYNAMIC_PARAMETERS in parameter file (line 18).

Warning: unknown parameter DYNAMIC_PARAMETERS in parameter file (line 18).

tp finished with return code: 0

meaning:

  Everything OK

SAPup> Starting subprocess in phase 'PATCH_CHK2' at 20130903082851

    ENV: DBMS_TYPE=mss

    ENV: JAVA_HOME=C:\Program Files\Java\jdk1.6.0_24

    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

    ENV: PATH=D:\usr\sap\NEQ\DVEBMGS00\exe;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;D:\usr\sap\NEQ\SYS\exe\uc\NTAMD64

    ENV: SAPSYSTEMNAME=NEQ

    ENV: dbs_mss_schema=neq

EXECUTING D:\usr\sap\NEQ\DVEBMGS00\exe\tp.EXE  pf=D:\usr\sap\NEQ\SUM\abap\var\DEFAULT.TPP execdbscript NEQ -x ..\var\OPENPATCHES.TQL

This is D:\usr\sap\NEQ\DVEBMGS00\exe\tp.EXE version 376.05.49 (release 710, unicode enabled)

Warning: unknown parameter DYNAMIC_PARAMETERS in parameter file (line 18).

Warning: unknown parameter DYNAMIC_PARAMETERS in parameter file (line 18).

tp finished with return code: 0

meaning:

  Everything OK

SAPup> Starting subprocess in phase 'SQLDB_CLEARPATCHES' at 20130903082851

    ENV: DBMS_TYPE=mss

    ENV: JAVA_HOME=C:\Program Files\Java\jdk1.6.0_24

    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

    ENV: PATH=D:\usr\sap\NEQ\SUM\abap\exe;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;D:\usr\sap\NEQ\SYS\exe\uc\NTAMD64

    ENV: SAPSYSTEMNAME=NEQ

    ENV: dbs_mss_schema=neq

EXECUTING D:\usr\sap\NEQ\SUM\abap\exe\tp.EXE  pf=D:\usr\sap\NEQ\SUM\abap\var\DEFAULT.TPP execdbscript NEQ -x ..\var\SQLDBSCRIPT.TQL

This is D:\usr\sap\NEQ\SUM\abap\exe\tp.EXE version 380.08.41 (release 720)

TRACE-INFO: 1:  [     dev trc,00000]  Tue Sep 03 08:28:51 2013                                                         2832  0.002832

TRACE-INFO: 2:  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 000007FEF0860000

TRACE-INFO: 3:                                                                                                         2433  0.005265

TRACE-INFO: 4:  [     dev trc,00000]      using "D:\usr\sap\NEQ\SUM\abap\exe\dbmssslib.dll"                              12  0.005277

TRACE-INFO: 5:  [     dev trc,00000]  Thread ID:4504                                                                  13040  0.018317

TRACE-INFO: 6:  [     dev trc,00000]  Thank You for using the SLODBC-interface                                           11  0.018328

TRACE-INFO: 7:  [     dev trc,00000]  Using dynamic link library 'D:\usr\sap\NEQ\SUM\abap\exe\dbmssslib.dll'             19  0.018347

TRACE-INFO: 8:  [     dev trc,00000]  dbmssslib.dll patch info                                                           52  0.018399

TRACE-INFO: 9:  [     dev trc,00000]    SAP patchlevel  0                                                                 9  0.018408

TRACE-INFO: 10:  [     dev trc,00000]    SAP patchno  438                                                                  9  0.018417

TRACE-INFO: 11:  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                                     14  0.018431

TRACE-INFO: 12:  [     dev trc,00000]    Last MSSQL DBSL patchno         438                                              10  0.018441

TRACE-INFO: 13:  [     dev trc,00000]    Last MSSQL DBSL patchcomment UPSERT using MERGE and a correction for ADBC (1887175)

TRACE-INFO: 14:                                                                                                           18  0.018459

TRACE-INFO: 15:  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 10.0 native                        10469  0.028928

TRACE-INFO: 16:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                            115  0.029043

TRACE-INFO: 17:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                          65466  0.094509

TRACE-INFO: 18:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                           3076  0.097585

TRACE-INFO: 19:  [     dev trc,00000]  Driver: sqlncli10.dll Driver release: 10.50.4000                                 3061  0.100646

TRACE-INFO: 20:  [     dev trc,00000]  GetDbRelease: 10.50.4000.00                                                       499  0.101145

TRACE-INFO: 21:  [     dev trc,00000]  GetDbRelease: Got DB release numbers (10,50,4000,0)                                13  0.101158

TRACE-INFO: 22:  [     dev trc,00000]  Can't run non-UNICODE-DbSl against UNICODE database                              3241  0.104399

TRACE-INFO: 23:  [     dev trc,00000]  CheckCodepageType failed. Connect terminated.                                      25  0.104424

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

meaning:

  connect failed

tp=>sapparam(1c): No Profile used.

tp=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: Connect to NEQ failed (20130903082851, probably wrong environment).

SAPup> Process with PID 13268 terminated with status 232 at 20130903082851!

SAPup> Starting subprocess in phase 'SQLDB_CLEARPATCHES' at 20130903084008

    ENV: DBMS_TYPE=mss

    ENV: JAVA_HOME=C:\Program Files\Java\jdk1.6.0_24

    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

    ENV: PATH=D:\usr\sap\NEQ\SUM\abap\exe;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;D:\usr\sap\NEQ\SYS\exe\uc\NTAMD64

    ENV: SAPSYSTEMNAME=NEQ

    ENV: dbs_mss_schema=neq

EXECUTING D:\usr\sap\NEQ\SUM\abap\exe\tp.EXE  pf=D:\usr\sap\NEQ\SUM\abap\var\DEFAULT.TPP execdbscript NEQ -x ..\var\SQLDBSCRIPT.TQL

This is D:\usr\sap\NEQ\SUM\abap\exe\tp.EXE version 380.08.41 (release 720)

TRACE-INFO: 1:  [     dev trc,00000]  Tue Sep 03 08:40:08 2013                                                         2886  0.002886

TRACE-INFO: 2:  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 000007FEEC5A0000

TRACE-INFO: 3:                                                                                                           14  0.002900

TRACE-INFO: 4:  [     dev trc,00000]      using "D:\usr\sap\NEQ\SUM\abap\exe\dbmssslib.dll"                              11  0.002911

TRACE-INFO: 5:  [     dev trc,00000]  Thread ID:14236                                                                  1907  0.004818

TRACE-INFO: 6:  [     dev trc,00000]  Thank You for using the SLODBC-interface                                           11  0.004829

TRACE-INFO: 7:  [     dev trc,00000]  Using dynamic link library 'D:\usr\sap\NEQ\SUM\abap\exe\dbmssslib.dll'             19  0.004848

TRACE-INFO: 8:  [     dev trc,00000]  dbmssslib.dll patch info                                                           52  0.004900

TRACE-INFO: 9:  [     dev trc,00000]    SAP patchlevel  0                                                                 9  0.004909

TRACE-INFO: 10:  [     dev trc,00000]    SAP patchno  438                                                                 10  0.004919

TRACE-INFO: 11:  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                                     14  0.004933

TRACE-INFO: 12:  [     dev trc,00000]    Last MSSQL DBSL patchno         438                                              10  0.004943

TRACE-INFO: 13:  [     dev trc,00000]    Last MSSQL DBSL patchcomment UPSERT using MERGE and a correction for ADBC (1887175)

TRACE-INFO: 14:                                                                                                           18  0.004961

TRACE-INFO: 15:  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 10.0 native                          974  0.005935

TRACE-INFO: 16:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                            111  0.006046

TRACE-INFO: 17:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                          79416  0.085462

TRACE-INFO: 18:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                           3118  0.088580

TRACE-INFO: 19:  [     dev trc,00000]  Driver: sqlncli10.dll Driver release: 10.50.4000                                 3073  0.091653

TRACE-INFO: 20:  [     dev trc,00000]  GetDbRelease: 10.50.4000.00                                                       300  0.091953

TRACE-INFO: 21:  [     dev trc,00000]  GetDbRelease: Got DB release numbers (10,50,4000,0)                                12  0.091965

TRACE-INFO: 22:  [     dev trc,00000]  Can't run non-UNICODE-DbSl against UNICODE database                              3147  0.095112

TRACE-INFO: 23:  [     dev trc,00000]  CheckCodepageType failed. Connect terminated.                                      29  0.095141

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

meaning:

  connect failed

tp=>sapparam(1c): No Profile used.

tp=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: Connect to NEQ failed (20130903084008, probably wrong environment).

SAPup> Process with PID 13768 terminated with status 232 at 20130903084008!

SAPup> Starting subprocess in phase 'SQLDB_CLEARPATCHES' at 20130903085106

    ENV: DBMS_TYPE=mss

    ENV: JAVA_HOME=C:\Program Files\Java\jdk1.6.0_24

    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

    ENV: PATH=D:\usr\sap\NEQ\SUM\abap\exe;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;D:\usr\sap\NEQ\SYS\exe\uc\NTAMD64

    ENV: SAPSYSTEMNAME=NEQ

    ENV: dbs_mss_schema=neq

EXECUTING D:\usr\sap\NEQ\SUM\abap\exe\tp.EXE  pf=D:\usr\sap\NEQ\SUM\abap\var\DEFAULT.TPP execdbscript NEQ -x ..\var\SQLDBSCRIPT.TQL

This is D:\usr\sap\NEQ\SUM\abap\exe\tp.EXE version 380.08.41 (release 720)

TRACE-INFO: 1:  [     dev trc,00000]  Tue Sep 03 08:51:06 2013                                                         2935  0.002935

TRACE-INFO: 2:  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 000007FEF0860000

TRACE-INFO: 3:                                                                                                           13  0.002948

TRACE-INFO: 4:  [     dev trc,00000]      using "D:\usr\sap\NEQ\SUM\abap\exe\dbmssslib.dll"                              11  0.002959

TRACE-INFO: 5:  [     dev trc,00000]  Thread ID:13576                                                                  1907  0.004866

TRACE-INFO: 6:  [     dev trc,00000]  Thank You for using the SLODBC-interface                                           11  0.004877

TRACE-INFO: 7:  [     dev trc,00000]  Using dynamic link library 'D:\usr\sap\NEQ\SUM\abap\exe\dbmssslib.dll'             31  0.004908

TRACE-INFO: 8:  [     dev trc,00000]  dbmssslib.dll patch info                                                           52  0.004960

TRACE-INFO: 9:  [     dev trc,00000]    SAP patchlevel  0                                                                10  0.004970

TRACE-INFO: 10:  [     dev trc,00000]    SAP patchno  438                                                                  9  0.004979

TRACE-INFO: 11:  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                                     14  0.004993

TRACE-INFO: 12:  [     dev trc,00000]    Last MSSQL DBSL patchno         438                                              10  0.005003

TRACE-INFO: 13:  [     dev trc,00000]    Last MSSQL DBSL patchcomment UPSERT using MERGE and a correction for ADBC (1887175)

TRACE-INFO: 14:                                                                                                           18  0.005021

TRACE-INFO: 15:  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 10.0 native                          977  0.005998

TRACE-INFO: 16:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                            111  0.006109

TRACE-INFO: 17:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                          81990  0.088099

TRACE-INFO: 18:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                           3111  0.091210

TRACE-INFO: 19:  [     dev trc,00000]  Driver: sqlncli10.dll Driver release: 10.50.4000                                 3083  0.094293

TRACE-INFO: 20:  [     dev trc,00000]  GetDbRelease: 10.50.4000.00                                                       304  0.094597

TRACE-INFO: 21:  [     dev trc,00000]  GetDbRelease: Got DB release numbers (10,50,4000,0)                                12  0.094609

TRACE-INFO: 22:  [     dev trc,00000]  Can't run non-UNICODE-DbSl against UNICODE database                              3191  0.097800

TRACE-INFO: 23:  [     dev trc,00000]  CheckCodepageType failed. Connect terminated.                                      30  0.097830

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

meaning:

  connect failed

tp=>sapparam(1c): No Profile used.

tp=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: Connect to NEQ failed (20130903085106, probably wrong environment).

SAPup> Process with PID 13688 terminated with status 232 at 20130903085106!

SAPup> Starting subprocess in phase 'SQLDB_CLEARPATCHES' at 20130903085109

    ENV: DBMS_TYPE=mss

    ENV: JAVA_HOME=C:\Program Files\Java\jdk1.6.0_24

    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

    ENV: PATH=D:\usr\sap\NEQ\SUM\abap\exe;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;D:\usr\sap\NEQ\SYS\exe\uc\NTAMD64

    ENV: SAPSYSTEMNAME=NEQ

    ENV: dbs_mss_schema=neq

EXECUTING D:\usr\sap\NEQ\SUM\abap\exe\tp.EXE  pf=D:\usr\sap\NEQ\SUM\abap\var\DEFAULT.TPP execdbscript NEQ -x ..\var\SQLDBSCRIPT.TQL

This is D:\usr\sap\NEQ\SUM\abap\exe\tp.EXE version 380.08.41 (release 720)

TRACE-INFO: 1:  [     dev trc,00000]  Tue Sep 03 08:51:09 2013                                                         2677  0.002677

TRACE-INFO: 2:  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 000007FEEC5A0000

TRACE-INFO: 3:                                                                                                           13  0.002690

TRACE-INFO: 4:  [     dev trc,00000]      using "D:\usr\sap\NEQ\SUM\abap\exe\dbmssslib.dll"                              10  0.002700

TRACE-INFO: 5:  [     dev trc,00000]  Thread ID:12828                                                                  1902  0.004602

TRACE-INFO: 6:  [     dev trc,00000]  Thank You for using the SLODBC-interface                                           11  0.004613

TRACE-INFO: 7:  [     dev trc,00000]  Using dynamic link library 'D:\usr\sap\NEQ\SUM\abap\exe\dbmssslib.dll'             19  0.004632

TRACE-INFO: 8:  [     dev trc,00000]  dbmssslib.dll patch info                                                           51  0.004683

TRACE-INFO: 9:  [     dev trc,00000]    SAP patchlevel  0                                                                 9  0.004692

TRACE-INFO: 10:  [     dev trc,00000]    SAP patchno  438                                                                  9  0.004701

TRACE-INFO: 11:  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                                     13  0.004714

TRACE-INFO: 12:  [     dev trc,00000]    Last MSSQL DBSL patchno         438                                              11  0.004725

TRACE-INFO: 13:  [     dev trc,00000]    Last MSSQL DBSL patchcomment UPSERT using MERGE and a correction for ADBC (1887175)

TRACE-INFO: 14:                                                                                                           17  0.004742

TRACE-INFO: 15:  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 10.0 native                          980  0.005722

TRACE-INFO: 16:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                            111  0.005833

TRACE-INFO: 17:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                          65937  0.071770

TRACE-INFO: 18:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                           3064  0.074834

TRACE-INFO: 19:  [     dev trc,00000]  Driver: sqlncli10.dll Driver release: 10.50.4000                                 3120  0.077954

TRACE-INFO: 20:  [     dev trc,00000]  GetDbRelease: 10.50.4000.00                                                       301  0.078255

TRACE-INFO: 21:  [     dev trc,00000]  GetDbRelease: Got DB release numbers (10,50,4000,0)                                13  0.078268

TRACE-INFO: 22:  [     dev trc,00000]  Can't run non-UNICODE-DbSl against UNICODE database                              3151  0.081419

TRACE-INFO: 23:  [     dev trc,00000]  CheckCodepageType failed. Connect terminated.                                      28  0.081447

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

meaning:

  connect failed

tp=>sapparam(1c): No Profile used.

tp=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: Connect to NEQ failed (20130903085109, probably wrong environment).

SAPup> Process with PID 2060 terminated with status 232 at 20130903085109!

SAPup> Starting subprocess in phase 'SQLDB_CLEARPATCHES' at 20130903085758

    ENV: DBMS_TYPE=mss

    ENV: JAVA_HOME=C:\Program Files\Java\jdk1.6.0_24

    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

    ENV: PATH=D:\usr\sap\NEQ\SUM\abap\exe;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;D:\usr\sap\NEQ\SYS\exe\uc\NTAMD64

    ENV: SAPSYSTEMNAME=NEQ

    ENV: dbs_mss_schema=neq

EXECUTING D:\usr\sap\NEQ\SUM\abap\exe\tp.EXE  pf=D:\usr\sap\NEQ\SUM\abap\var\DEFAULT.TPP execdbscript NEQ -x ..\var\SQLDBSCRIPT.TQL

This is D:\usr\sap\NEQ\SUM\abap\exe\tp.EXE version 380.08.41 (release 720)

TRACE-INFO: 1:  [     dev trc,00000]  Tue Sep 03 08:57:58 2013                                                         2893  0.002893

TRACE-INFO: 2:  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 000007FEF0860000

TRACE-INFO: 3:                                                                                                           13  0.002906

TRACE-INFO: 4:  [     dev trc,00000]      using "D:\usr\sap\NEQ\SUM\abap\exe\dbmssslib.dll"                              11  0.002917

TRACE-INFO: 5:  [     dev trc,00000]  Thread ID:13348                                                                  1908  0.004825

TRACE-INFO: 6:  [     dev trc,00000]  Thank You for using the SLODBC-interface                                           11  0.004836

TRACE-INFO: 7:  [     dev trc,00000]  Using dynamic link library 'D:\usr\sap\NEQ\SUM\abap\exe\dbmssslib.dll'             18  0.004854

TRACE-INFO: 8:  [     dev trc,00000]  dbmssslib.dll patch info                                                           53  0.004907

TRACE-INFO: 9:  [     dev trc,00000]    SAP patchlevel  0                                                                 9  0.004916

TRACE-INFO: 10:  [     dev trc,00000]    SAP patchno  438                                                                  9  0.004925

TRACE-INFO: 11:  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                                     13  0.004938

TRACE-INFO: 12:  [     dev trc,00000]    Last MSSQL DBSL patchno         438                                              11  0.004949

TRACE-INFO: 13:  [     dev trc,00000]    Last MSSQL DBSL patchcomment UPSERT using MERGE and a correction for ADBC (1887175)

TRACE-INFO: 14:                                                                                                           18  0.004967

TRACE-INFO: 15:  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 10.0 native                          979  0.005946

TRACE-INFO: 16:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                            111  0.006057

TRACE-INFO: 17:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                          95605  0.101662

TRACE-INFO: 18:  [     dev trc,00000]  lpc:(local) connection used on SAPtest                                           3103  0.104765

TRACE-INFO: 19:  [     dev trc,00000]  Driver: sqlncli10.dll Driver release: 10.50.4000                                 3400  0.108165

TRACE-INFO: 20:  [     dev trc,00000]  GetDbRelease: 10.50.4000.00                                                       306  0.108471

TRACE-INFO: 21:  [     dev trc,00000]  GetDbRelease: Got DB release numbers (10,50,4000,0)                                13  0.108484

TRACE-INFO: 22:  [     dev trc,00000]  Can't run non-UNICODE-DbSl against UNICODE database                              3163  0.111647

TRACE-INFO: 23:  [     dev trc,00000]  CheckCodepageType failed. Connect terminated.                                      29  0.111676

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

meaning:

  connect failed

tp=>sapparam(1c): No Profile used.

tp=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: Connect to NEQ failed (20130903085758, probably wrong environment).

SAPup> Process with PID 13604 terminated with status 232 at 20130903085758!


sunny_pahuja2
Active Contributor
0 Kudos

Here is the error:

TRACE-INFO: 22:  [     dev trc,00000]  Can't run non-UNICODE-DbSl against UNICODE database                              3163  0.111647

TRACE-INFO: 23:  [     dev trc,00000]  CheckCodepageType failed. Connect terminated.                                      29  0.111676

It looks you updated non-unicode dbsl in your kernel while kernel is unicode. Please check.

Thanks

Sunny

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ish,

Please try using the latest R3trans and tp files.

Best Regards,

Anita

former_member183107
Contributor
0 Kudos

Hi Ish,

1. Go to command prompt ans use R3trans -d aand paste the output over here.

2. Check whether database is up or not.

3. Check whether listener is running or not.

4. Check the  enc variables of your system like SAPLOCALHOST,SAPSYSTEMNAME,DBMS_TYPE etc.

5. Check the entries of the hosts and services file.

Regards,

Himanshu