cancel
Showing results for 
Search instead for 
Did you mean: 

ASE Error SQL30012:08001

yasin_kurtulus
Explorer
0 Kudos

Hi,

I'm upgrading my sybase system from ehp6 to ehp7

I'm on PREP_IMPORT/TOOLIMPI phase

I face error ASE Error SQL30012:08001 in sapup.eco and system was down at the same time.

what can I do this situtation ?

Thank you

Sapup.eco file details:

SAPup> Starting subprocess in phase 'SCANDIR_EXTRACT' at 20140904112112

    ENV: DBMS_TYPE=syb

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

    ENV: PATH=C:\Windows\system32;D:\sybase\QAS\SCC-3_2\bin;C:\j2sdk1.4.2_28-x64\BIN;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\sybase\QAS\ASE-15_0\jobscheduler\bin;D:\sybase\QAS\ASE-15_0\dll;D:\sybase\QAS\ASE-15_0\bin;D:\sybase\QAS\OCS-15_0\lib3p64;D:\sybase\QAS\OCS-15_0\lib3p;D:\sybase\QAS\OCS-15_0\dll;D:\sybase\QAS\OCS-15_0\bin;D:\usr\sap\QAS\SYS\exe\uc\NTAMD64;\\DTYQAS\sapmnt\QAS\SYS\global\syb\NTAMD64\sybodbc;D:\sybase\QAS\DBISQL\bin

    ENV: SAPSYSTEMNAME=QAS

    ENV: dbs_syb_dbname=QAS

    ENV: dbs_syb_no_ext_check=1

    ENV: dbs_syb_port=4901

    ENV: dbs_syb_schema=SAPSR3

    ENV: dbs_syb_server=DTYQAS

    ENV: rsdb_ssfs_connect=1

EXECUTING C:\Windows\system32\msiexec.EXE /qn /norestart /i E:\UPGRADE\SUM\SUM\abap\exe\vcredist_x64.msi

### Phase PREP_INPUT/TOOLVERSION_INISYS:

### Phase PREP_INPUT/TOOLCHECKXML_INISYS:

### Phase PREP_INPUT/TOOLVERSION_INIEXE:

### Phase PREP_INPUT/TOOLCHECKXML_INIEXE:

### Phase PREP_INPUT/DBCONNCHK_INI:

### Phase PREP_INPUT/CHKSYSTYPE:

### Phase PREP_INPUT/SSFS_INI:

### Phase PREP_INPUT/MIG2NDDB_INI:

### Phase PREP_INPUT/DBQUERY_PRE:

### Phase PREP_INPUT/CONFCHK_IMP:

### Phase PREP_INPUT/READDATA_USRENV:

### Phase PREP_INPUT/READDATA_ORACLNT:

### Phase PREP_INPUT/ASCS_CHK:

### Phase PREP_INPUT/J2EE_CHK1:

### Phase PREP_INPUT/INSTANCELIST_PRE:

### Phase PREP_INPUT/CHECKSYSSTATUS_POST:

### Phase PREP_INPUT/HIAV_CHK:

### Phase PREP_INPUT/CHECK4SOLMAN:

### Phase PREP_INPUT/KX_CPYCHK:

### Phase PREP_INIT/DBCHK_INI:

### Phase PREP_INIT/SQLDB_LIST_AVERS_EXT:

### Phase PREP_INIT/SWITCHPARAM_UPGDIR:

### Phase PREP_INIT/REQ_J2EEUPG:

### Phase PREP_INIT/SETSYNC_PREP_STARTED:

### Phase PREP_INIT/VERSCHK_INI:

### Phase PREP_INIT/VALCHK_INI:

### Phase PREP_INIT/LMSEMAPHORE_SET:

### Phase PREP_INIT/EHP_CHK:

### Phase PREP_INIT/UNICODE_CHK_PRE:

### Phase PREP_INIT/SCANDIR_UPG1:

SAPup> Starting subprocess in phase 'SCANDIR_UPG1' at 20140904112243

    ENV: DBMS_TYPE=syb

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

    ENV: PATH=C:\Windows\system32;D:\sybase\QAS\SCC-3_2\bin;C:\j2sdk1.4.2_28-x64\BIN;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\sybase\QAS\ASE-15_0\jobscheduler\bin;D:\sybase\QAS\ASE-15_0\dll;D:\sybase\QAS\ASE-15_0\bin;D:\sybase\QAS\OCS-15_0\lib3p64;D:\sybase\QAS\OCS-15_0\lib3p;D:\sybase\QAS\OCS-15_0\dll;D:\sybase\QAS\OCS-15_0\bin;D:\usr\sap\QAS\SYS\exe\uc\NTAMD64;\\DTYQAS\sapmnt\QAS\SYS\global\syb\NTAMD64\sybodbc;D:\sybase\QAS\DBISQL\bin

    ENV: SAPSYSTEMNAME=QAS

    ENV: dbs_syb_dbname=QAS

    ENV: dbs_syb_no_ext_check=1

    ENV: dbs_syb_port=4901

    ENV: dbs_syb_schema=SAPSR3

    ENV: dbs_syb_server=DTYQAS

    ENV: rsdb_ssfs_connect=1

EXECUTING C:\Windows\system32\msiexec.EXE /qn /norestart /i E:\UPGRADE\SUM\SUM\abap\exe\vcredist_x64.msi

### Phase PREP_INIT/TOOLVERSION_UPG1:

### Phase PREP_INIT/TOOLCHECKXML_UPG1:

### Phase PREP_INIT/SETSYNC_INFO_FINISHED:

### Phase PREP_INIT/CLNT_CHK_INI:

### Phase PREP_INIT/PATCH_CHK1:

### Phase PREP_INIT/JOB_RSUPDTEC:

### Phase PREP_INIT/GEN_TAIASAP:

### Phase PREP_INIT/INIT_CNTRANS_PRE:

### Phase PREP_INIT/JOB_RSDB4090:

### Phase PREP_INIT/CHK_DB6_REG_PRE:

### Phase PREP_INIT/CHK_DB6_PAR_INI:

### Phase PREP_INIT/SPACECHK_INI:

### Phase PREP_INIT/DBPREP_CHK:

### Phase PREP_INIT/ASU_CHK:

### Phase PREP_INIT/ADDON_INFO:

### Phase PREP_INIT/ADDON_SPEC1:

### Phase PREP_INIT/ADDON_TREAS:

### Phase PREP_INIT/ADDON_WFM:

### Phase PREP_INIT/ADDON_DMC:

### Phase PREP_INIT/ADDON_CMS:

### Phase PREP_INIT/ADDON_FND:

### Phase PREP_INIT/UCMIG_DECISION:

### Phase PREP_INIT/ACE_CHK:

### Phase PREP_INIT/CRM_BILL:

### Phase PREP_INIT/PR_DBPAR:

### Phase PREP_INIT/CHECKPROF_INI:

### Phase PREP_INIT/DB2_CHECKNOTES_INI:

### Phase PREP_INIT/LC_CHECK:

### Phase PREP_IMPORT/DMPSPC_INI:

### Phase PREP_IMPORT/READDATA:

### Phase PREP_IMPORT/PATCHCONT_RDATAEXT:

### Phase PREP_IMPORT/NEWKERNLIB_CHK1:

SAPup> Starting subprocess in phase 'NEWKERNLIB_CHK1' at 20140904112304

    ENV: DBMS_TYPE=syb

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

    ENV: Path=D:\sybase\QAS\SCC-3_2\bin;C:\j2sdk1.4.2_28-x64\BIN;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\sybase\QAS\ASE-15_0\jobscheduler\bin;D:\sybase\QAS\ASE-15_0\dll;D:\sybase\QAS\ASE-15_0\bin;D:\sybase\QAS\OCS-15_0\lib3p64;D:\sybase\QAS\OCS-15_0\lib3p;D:\sybase\QAS\OCS-15_0\dll;D:\sybase\QAS\OCS-15_0\bin;D:\usr\sap\QAS\SYS\exe\uc\NTAMD64;\\DTYQAS\sapmnt\QAS\SYS\global\syb\NTAMD64\sybodbc;D:\sybase\QAS\DBISQL\bin

    ENV: SAPSYSTEMNAME=QAS

    ENV: dbs_syb_dbname=QAS

    ENV: dbs_syb_no_ext_check=1

    ENV: dbs_syb_port=4901

    ENV: dbs_syb_schema=SAPSR3

    ENV: dbs_syb_server=DTYQAS

    ENV: rsdb_ssfs_connect=1

EXECUTING E:\UPGRADE\SUM\SUM\abap\exe\tp.EXE -V

This is E:\UPGRADE\SUM\SUM\abap\exe\tp.EXE version 380.18.94 (release 741, unicode enabled)

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

tp information

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

kernel release                741

kernel make variant           741_REL

DBMS client library                                          

DBSL shared library version   741.10

compiled on                   NT 6.0 6002 x86 MS VC++ 16.00 for NTAMD64

compiled for                  64 BIT

compilation mode              UNICODE

compile time                  Aug 14 2014 00:06:12

update level                  0

patch number                  47

source id                     0.047

RKS compatibility level       0

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

supported environment

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

database (SAP, table SVERS)   700

                              710

                              701

                              702

                              703

                              711

                              720

                              730

                              731

                              732

                              738

                              740

                             

DBMS server

   15.7

operating system

Windows NT 5.1

Windows NT 5.2

Windows NT 6.0

Windows NT 6.1

Windows NT 6.2

Windows NT 6.3

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

tp patch information

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

( 0.005) Missing batch versions after upgrade (note 1888943)

( 0.014) Wrong ABAP loads after import into running system (note 1899663)

( 0.014) Anonymization on demand (note 1947037)

( 0.017) TPSTAT cleanup (note 1963317)

( 0.018) Wrong access on table TPSTAT (note 1963317)

( 0.020) Transports in mixed AS400/Windows environments (note 1973389)

( 0.024) TPSTAT cleanup IV (note 1963317)

( 0.024) Sporadic error message 'transport in buffer too long or unknown' (note 1979970)

( 0.030) Import stop during upgrade not working (note 2002203)

( 0.031) TPSTAT cleanup on windows (note 1963317)

( 0.036) Long waiting time when calling tp via RFC (note 2012502)

( 0.047) Imports are executed incompletely (note 2048110)

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

dbsl patch information

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

( 0.005) 741: system does not start (note 1896684)

( 0.011) SYB: Configuring the cache size (note 1909273)

( 0.013) Sybase ASE: SUM:RUN_RSAIMMERGE_TRANSFER fails (note 1954359)

( 0.030) SYB: enable SQL break (note 2001461)

( 0.035) Sybase IQ:remote connection to IQ 16.0 SP8 (note 2016130)

( 0.042) SYB: transaction log full  causes too many connections err (note 2021158)

( 0.044) SYB: dump/signal 11 when setting ST05 trace (note 2043464)

### Phase PREP_IMPORT/CNV_CHK_IMP:

### Phase PREP_IMPORT/ICNVCHK_IMP:

### Phase PREP_IMPORT/SCRIPT_CHK_TOOL4:

### Phase PREP_IMPORT/TRBATCHK_IMP:

### Phase PREP_IMPORT/CLNT_CHK_IMP:

### Phase PREP_IMPORT/INTCHK_IMP:

### Phase PREP_IMPORT/SPACECHK_IMP:

### Phase PREP_IMPORT/PATCH_CHK2:

### Phase PREP_IMPORT/SQLDB_CLEARTOOLIMP:

### Phase PREP_IMPORT/SQLDB_CLEARPATCHES:

### Phase PREP_IMPORT/GENBUFFER_TOOLIMP:

### Phase PREP_IMPORT/TOOLIMP_TOOLDEL_PRE:

SAPup> Starting subprocess in phase 'TOOLIMP_TOOLDEL_PRE' at 20140904112330

    ENV: DBMS_TYPE=syb

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

    ENV: PATH=D:\usr\sap\QAS\DVEBMGS06\exe;D:\sybase\QAS\SCC-3_2\bin;C:\j2sdk1.4.2_28-x64\BIN;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\sybase\QAS\ASE-15_0\jobscheduler\bin;D:\sybase\QAS\ASE-15_0\dll;D:\sybase\QAS\ASE-15_0\bin;D:\sybase\QAS\OCS-15_0\lib3p64;D:\sybase\QAS\OCS-15_0\lib3p;D:\sybase\QAS\OCS-15_0\dll;D:\sybase\QAS\OCS-15_0\bin;D:\usr\sap\QAS\SYS\exe\uc\NTAMD64;\\DTYQAS\sapmnt\QAS\SYS\global\syb\NTAMD64\sybodbc;D:\sybase\QAS\DBISQL\bin

    ENV: SAPSYSTEMNAME=QAS

    ENV: dbs_syb_dbname=QAS

    ENV: dbs_syb_no_ext_check=1

    ENV: dbs_syb_port=4901

    ENV: dbs_syb_schema=SAPSR3

    ENV: dbs_syb_server=DTYQAS

    ENV: rsdb_ssfs_connect=1

EXECUTING D:\usr\sap\QAS\DVEBMGS06\exe\tp.EXE "pf=E:\UPGRADE\SUM\SUM\abap\var\DEFAULT.TPP" import all QAS

This is D:\usr\sap\QAS\DVEBMGS06\exe\tp.EXE version 380.08.41 (release 720, unicode enabled)

This is D:\usr\sap\QAS\DVEBMGS06\exe\R3trans.exe version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

unicode enabled version

D:\usr\sap\QAS\DVEBMGS06\exe\R3trans.exe finished (0000).

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

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

tp finished with return code: 0

meaning:

  Everything OK

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

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

### Phase PREP_IMPORT/TOOLIMPD:

SAPup> Starting subprocess in phase 'TOOLIMPD' at 20140904112344

    ENV: DBMS_TYPE=syb

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

    ENV: PATH=D:\usr\sap\QAS\DVEBMGS06\exe;D:\sybase\QAS\SCC-3_2\bin;C:\j2sdk1.4.2_28-x64\BIN;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\sybase\QAS\ASE-15_0\jobscheduler\bin;D:\sybase\QAS\ASE-15_0\dll;D:\sybase\QAS\ASE-15_0\bin;D:\sybase\QAS\OCS-15_0\lib3p64;D:\sybase\QAS\OCS-15_0\lib3p;D:\sybase\QAS\OCS-15_0\dll;D:\sybase\QAS\OCS-15_0\bin;D:\usr\sap\QAS\SYS\exe\uc\NTAMD64;\\DTYQAS\sapmnt\QAS\SYS\global\syb\NTAMD64\sybodbc;D:\sybase\QAS\DBISQL\bin

    ENV: SAPSYSTEMNAME=QAS

    ENV: dbs_syb_dbname=QAS

    ENV: dbs_syb_no_ext_check=1

    ENV: dbs_syb_port=4901

    ENV: dbs_syb_schema=SAPSR3

    ENV: dbs_syb_server=DTYQAS

    ENV: rsdb_ssfs_connect=1

EXECUTING D:\usr\sap\QAS\DVEBMGS06\exe\tp.EXE "pf=E:\UPGRADE\SUM\SUM\abap\var\TOOLIMPD.TPP" put QAS

This is D:\usr\sap\QAS\DVEBMGS06\exe\tp.EXE version 380.08.41 (release 720, unicode enabled)

Looking for effective putsteps ... ... ready (looking for putsteps)

This is D:\usr\sap\QAS\DVEBMGS06\exe\R3trans.exe version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

unicode enabled version

D:\usr\sap\QAS\DVEBMGS06\exe\R3trans.exe finished (0000).

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

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

This is D:\usr\sap\QAS\DVEBMGS06\exe\R3trans.exe version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

unicode enabled version

D:\usr\sap\QAS\DVEBMGS06\exe\R3trans.exe finished (0000).

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

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

This is D:\usr\sap\QAS\DVEBMGS06\exe\R3trans.exe version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

unicode enabled version

D:\usr\sap\QAS\DVEBMGS06\exe\R3trans.exe finished (0000).

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

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

tp finished with return code: 4

meaning:

  A tool used by tp produced warnings

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

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

SAPup> Process with PID 3444 terminated with status 4 at 20140904112634!

### Phase PREP_IMPORT/MVNTAB_TOOL:

### Phase PREP_IMPORT/TOOLIMPI:

SAPup> Starting subprocess in phase 'TOOLIMPI' at 20140904112652

    ENV: DBMS_TYPE=syb

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

    ENV: PATH=D:\usr\sap\QAS\DVEBMGS06\exe;D:\sybase\QAS\SCC-3_2\bin;C:\j2sdk1.4.2_28-x64\BIN;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\sybase\QAS\ASE-15_0\jobscheduler\bin;D:\sybase\QAS\ASE-15_0\dll;D:\sybase\QAS\ASE-15_0\bin;D:\sybase\QAS\OCS-15_0\lib3p64;D:\sybase\QAS\OCS-15_0\lib3p;D:\sybase\QAS\OCS-15_0\dll;D:\sybase\QAS\OCS-15_0\bin;D:\usr\sap\QAS\SYS\exe\uc\NTAMD64;\\DTYQAS\sapmnt\QAS\SYS\global\syb\NTAMD64\sybodbc;D:\sybase\QAS\DBISQL\bin

    ENV: SAPSYSTEMNAME=QAS

    ENV: dbs_syb_dbname=QAS

    ENV: dbs_syb_no_ext_check=1

    ENV: dbs_syb_port=4901

    ENV: dbs_syb_schema=SAPSR3

    ENV: dbs_syb_server=DTYQAS

    ENV: rsdb_ssfs_connect=1

EXECUTING D:\usr\sap\QAS\DVEBMGS06\exe\tp.EXE "pf=E:\UPGRADE\SUM\SUM\abap\var\TOOLIMPI.TPP" put QAS

This is D:\usr\sap\QAS\DVEBMGS06\exe\tp.EXE version 380.08.41 (release 720, unicode enabled)

Looking for effective putsteps ... ... ready (looking for putsteps)

This is D:\usr\sap\QAS\DVEBMGS06\exe\R3trans.exe version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

unicode enabled version

2EETW000 sap_dext called with msgnr "1":

2EETW000 ---- db call info ----

2EETW000 function:   db_rtab

2EETW000 fcode:      RT_READ_FOR_UPDATE

2EETW000 tabname:    TRBAT3                       

2EETW000 len (char): 358

2EETW000 key:        PSAPK701EHP          000000000037R    20140904112656E:\UPGRADE\SUM\SUM\abap\tmp\SAPI701EHP_01684_01684_000000.QAS                                                          

2EETW000 retcode:    1

2EETW000 sql error:  1105 [ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free extents. If you

2EETW125 SQL error "1105" during "" access: "[ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment."

D:\usr\sap\QAS\DVEBMGS06\exe\R3trans.exe finished (0012).

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

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

TRACE-INFO: 1:  [     dev trc,00000]  Thu Sep 04 11:26:53 2014                                                         1402  0.001402

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

TRACE-INFO: 3:                                                                                                           19  0.001421

TRACE-INFO: 4:  [     dev trc,00000]      using "D:\usr\sap\QAS\DVEBMGS06\exe\dbsybslib.dll"                             12  0.001433

TRACE-INFO: 5:  [     dev trc,00000]  database is local: connect_timeout: 3                                           16640  0.018073

TRACE-INFO: 6:  [     dev trc,00000]  Thread ID:2864                                                                    111  0.018184

TRACE-INFO: 7:  [     dev trc,00000]  lib_dbsl 720 08/01/2013 11:14:00                                                   30  0.018214

TRACE-INFO: 8:  [     dev trc,00000]  720_EXT build                                                                      20  0.018234

TRACE-INFO: 9:  [     dev trc,00000]  Using dynamic link library 'D:\usr\sap\QAS\DVEBMGS06\exe\dbsybslib.dll'            44  0.018278

TRACE-INFO: 10:  [     dev trc,00000]  dbsybslib.dll patch info                                                          107  0.018385

TRACE-INFO: 11:  [     dev trc,00000]    SAP patchlevel  0                                                                24  0.018409

TRACE-INFO: 12:  [     dev trc,00000]    SAP patchno  500                                                                 19  0.018428

TRACE-INFO: 13:  [     dev trc,00000]    Last SYBASE DBSL patchlevel 0                                                    22  0.018450

TRACE-INFO: 14:  [     dev trc,00000]    Last SYBASE DBSL patchno         440                                             25  0.018475

TRACE-INFO: 15:  [     dev trc,00000]    Last SYBASE DBSL patchcomment Sybase IQ: Enable remote/secondary connect to SAP Sybase I (1737415)

TRACE-INFO: 16:                                                                                                           46  0.018521

TRACE-INFO: 17:  [     dev trc,00000]  lpc:(local) connection used on DTYQAS                                              99  0.018620

TRACE-INFO: 18:  [     dev trc,00000]  lpc:(local) connection used on DTYQAS                                          539159  0.557779

TRACE-INFO: 19:  [     dev trc,00000]  spid 87 comm rd ODBC                                                            40303  0.598082

TRACE-INFO: 20:  [     dev trc,00000]  spid 117 unc rd ODBC                                                              479  0.598561

TRACE-INFO: 21:  [     dev trc,00000]  Driver: Adaptive Server Enterprise Driver release: 15.7.0.1270                    961  0.599522

TRACE-INFO: 22:  [     dev trc,00000]  Driver full version: SAP ASE ODBC Driver/15.7/SP127 PL/P/AMD64/Windows/drvmain/Build 1270/64-bit/Normal/Tue Jun 10 UTC 01:06:37 2014/SQLLEN8

TRACE-INFO: 23:                                                                                                           35  0.599557

TRACE-INFO: 24:  [     dev trc,00000]  Driver uses SQLLEN8                                                                16  0.599573

TRACE-INFO: 25:  [     dev trc,00000]  GetServerInfo version: Adaptive Server Enterprise/15.7/EBF 22777 SMP SP122 /P/X64/Windows Server/ase157sp12x/3662/64-bit/OPT/Sat Apr 19 01:26:01 2014

TRACE-INFO: 26:                                                                                                          858  0.600431

TRACE-INFO: 27:  [     dev trc,00000]  GetServerInfo release: 15.7.0.122                                                 450  0.600881

TRACE-INFO: 28:  [     dev trc,00000]  GetServerInfo architecture: x86_64                                                 13  0.600894

TRACE-INFO: 29:  [     dev trc,00000]  GetServerInfo edition: P                                                           11  0.600905

TRACE-INFO: 30:  [     dev trc,00000]  GetServerInfo byte width: 64 bit                                                   10  0.600915

TRACE-INFO: 31:  [     dev trc,00000]  DbSlConnect hdl: 0                                                               1380  0.602295

TRACE-INFO: 32:  [     dev trc,00000]  trace file set                                                                     12  0.602307

TRACE-INFO: 33:  [     tptrc.c,01036]   trace level switched from 2 to 1                                               10779  0.613086

TRACE-INFO: 34:  [     dev trc,00000]  Thu Sep 04 11:27:21 2014                                                      28049824  28.662910

TRACE-INFO: 35:  [     dev trc,00000]  ERROR: -1 in function ExeNormalModify (execute) [line 21986]                       11  28.662921

TRACE-INFO: 36:  [     dev trc,00000]  (1105) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for objec

TRACE-INFO: 37:                                                                                                           27  28.662948

TRACE-INFO: 38:  [     dev trc,00000]  t 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free e

TRACE-INFO: 39:                                                                                                           20  28.662968

TRACE-INFO: 40:  [     dev trc,00000]  xtents. If you ran out of space in syslogs, dump the transaction log. Otherwise,

TRACE-INFO: 41:                                                                                                           22  28.662990

TRACE-INFO: 42:  [     dev trc,00000]   use ALTER DATABASE to increase the size of the segment.                           15  28.663005

TRACE-INFO: 43:  [     dev trc,00000]  sql statement is ==> DELETE FROM "D1GEN" WHERE "WHAT" = ?                          33  28.663038

TRACE-INFO: 44:                        /* R3:RTAB:0 T:D1GEN */

TRACE-INFO: 45:  [     dev trc,00000]  0,OPTIONS1,OPTIONS2,OPTIONS3,PID,HOST,OVERTAKER,FALSEPOS FROM TRBAT2 WHERE "FUNC

TRACE-INFO: 46:                                                                                                           22  28.663060

TRACE-INFO: 47:  [     dev trc,00000]  ERROR: -1 in function GetTranState (SQLExecDirect failed) [line 33013]           1283  28.664343

TRACE-INFO: 48:  [     dev trc,00000]  evaluation of transaction state failed.                                            41  28.664384

TRACE-INFO: 49:  [    dbtrtab ,00000]  ***LOG BY4=>sql error 1105   performing DEL on table D1GEN                        

TRACE-INFO: 50:                                                                                                           69  28.664453

TRACE-INFO: 51:  [    dbtrtab ,00000]  ***LOG BY0=>[ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

TRACE-INFO: 52:                                                                                                           54  28.664507

HALT 20140904112721

tp returncode summary:

TOOLS: Highest return code of single steps was: 16

ERRORS: Highest tp internal error was: 0234

TRACE-INFO: 53:  [     dev trc,00000]  ERROR: -1 in function DoPing (SQLExecDirect failed) [line 21297]                 3725  28.668232

TRACE-INFO: 54:  [     dev trc,00000]  (1105) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for objec

TRACE-INFO: 55:                                                                                                           28  28.668260

TRACE-INFO: 56:  [     dev trc,00000]  t 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free e

TRACE-INFO: 57:                                                                                                           22  28.668282

TRACE-INFO: 58:  [     dev trc,00000]  xtents. If you ran out of space in syslogs, dump the transaction log. Otherwise,

TRACE-INFO: 59:                                                                                                           21  28.668303

TRACE-INFO: 60:  [     dev trc,00000]   use ALTER DATABASE to increase the size of the segment.                           16  28.668319

TRACE-INFO: 61:  [     dev trc,00000]  ERROR: -1 in function GetTranState (SQLExecDirect failed) [line 33013]           1158  28.669477

TRACE-INFO: 62:  [     dev trc,00000]  evaluation of transaction state failed.                                            40  28.669517

TRACE-INFO: 63:  [     dev trc,00000]  Connection Test during Rollback failed                                             30  28.669547

TRACE-INFO: 64:  [     dev trc,00000]  ERROR: -1 in function ExeNormalModify (execute) [line 21986]                    16538  28.686085

TRACE-INFO: 65:  [     dev trc,00000]  (1105) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for objec

TRACE-INFO: 66:                                                                                                           28  28.686113

TRACE-INFO: 67:  [     dev trc,00000]  t 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free e

TRACE-INFO: 68:                                                                                                           23  28.686136

TRACE-INFO: 69:  [     dev trc,00000]  xtents. If you ran out of space in syslogs, dump the transaction log. Otherwise,

TRACE-INFO: 70:                                                                                                           21  28.686157

TRACE-INFO: 71:  [     dev trc,00000]   use ALTER DATABASE to increase the size of the segment.                           16  28.686173

TRACE-INFO: 72:  [     dev trc,00000]  statement id is ==> [3 TPSTAT                                   536870913 20130812110055]

TRACE-INFO: 73:                                                                                                           35  28.686208

TRACE-INFO: 74:  [     dev trc,00000]                                                                                      8  28.686216

TRACE-INFO: 75:  [     dev trc,00000]  ERROR: -1 in function GetTranState (SQLExecDirect failed) [line 33013]           1052  28.687268

TRACE-INFO: 76:  [     dev trc,00000]  evaluation of transaction state failed.                                            44  28.687312

TRACE-INFO: 77:  [    dbtrtab ,00000]  ***LOG BY4=>sql error 1105   performing UPD on table TPSTAT                       

TRACE-INFO: 78:                                                                                                           48  28.687360

TRACE-INFO: 79:  [    dbtrtab ,00000]  ***LOG BY0=>[ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

TRACE-INFO: 80:                                                                                                           49  28.687409

TRACE-INFO: 81:  [     dev trc,00000]  ERROR: -1 in function ExeNormalModify (execute) [line 21986]                     2675  28.690084

TRACE-INFO: 82:  [     dev trc,00000]  (1105) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for objec

TRACE-INFO: 83:                                                                                                           28  28.690112

TRACE-INFO: 84:  [     dev trc,00000]  t 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free e

TRACE-INFO: 85:                                                                                                           20  28.690132

TRACE-INFO: 86:  [     dev trc,00000]  xtents. If you ran out of space in syslogs, dump the transaction log. Otherwise,

TRACE-INFO: 87:                                                                                                           20  28.690152

TRACE-INFO: 88:  [     dev trc,00000]   use ALTER DATABASE to increase the size of the segment.                           16  28.690168

TRACE-INFO: 89:  [     dev trc,00000]  sql statement is ==> UPDATE "TPLOGNAMES" SET "BEGINTIME" = ? ,"ENDTIME" = ? WHERE "DIRTYPE" = ? AND "

TRACE-INFO: 90:                                                                                                           31  28.690199

TRACE-INFO: 91:  [     dev trc,00000]  LOGTYPE" = ? AND "LOGNAME" = ?                                                     17  28.690216

TRACE-INFO: 92:                        /* R3:RTAB:0 T:TPLOGNAMES */

TRACE-INFO: 93:  [     dev trc,00000]  TION" = ? ORDER BY AS4POS                                                          19  28.690235

TRACE-INFO: 94:                        /* R3::0 T:TRBAT2 */

TRACE-INFO: 95:  [     dev trc,00000]  ERROR: -1 in function GetTranState (SQLExecDirect failed) [line 33013]           1261  28.691496

TRACE-INFO: 96:  [     dev trc,00000]  evaluation of transaction state failed.                                            39  28.691535

TRACE-INFO: 97:  [    dbtrtab ,00000]  ***LOG BY4=>sql error 1105   performing UPD on table TPLOGNAMES                   

TRACE-INFO: 98:                                                                                                           43  28.691578

TRACE-INFO: 99:  [    dbtrtab ,00000]  ***LOG BY0=>[ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

TRACE-INFO: 100:                                                                                                           48  28.691626

TRACE-INFO: 101:  [     dev trc,00000]  ERROR: -1 in function ExeNormalModify (execute) [line 21986]                    27051  28.718677

TRACE-INFO: 102:  [     dev trc,00000]  (1105) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for objec

TRACE-INFO: 103:                                                                                                           27  28.718704

TRACE-INFO: 104:  [     dev trc,00000]  t 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free e

TRACE-INFO: 105:                                                                                                           22  28.718726

TRACE-INFO: 106:  [     dev trc,00000]  xtents. If you ran out of space in syslogs, dump the transaction log. Otherwise,

TRACE-INFO: 107:                                                                                                           21  28.718747

TRACE-INFO: 108:  [     dev trc,00000]   use ALTER DATABASE to increase the size of the segment.                           16  28.718763

TRACE-INFO: 109:  [     dev trc,00000]  statement id is ==> [3 TPLOGNAMES                               536870913 20110915111059]

TRACE-INFO: 110:                                                                                                           34  28.718797

TRACE-INFO: 111:  [     dev trc,00000]                                                                                      7  28.718804

TRACE-INFO: 112:  [     dev trc,00000]  ERROR: -1 in function GetTranState (SQLExecDirect failed) [line 33013]           9133  28.727937

TRACE-INFO: 113:  [     dev trc,00000]  evaluation of transaction state failed.                                            48  28.727985

TRACE-INFO: 114:  [    dbtrtab ,00000]  ***LOG BY4=>sql error 1105   performing UPD on table TPLOGNAMES                   

TRACE-INFO: 115:                                                                                                           60  28.728045

TRACE-INFO: 116:  [    dbtrtab ,00000]  ***LOG BY0=>[ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

TRACE-INFO: 117:                                                                                                           49  28.728094

TRACE-INFO: 118:  [     dev trc,00000]  DbSlCommit after transaction was aborted: only rollback permitted                  30  28.728124

TRACE-INFO: 119:  [    dbcon   ,00000]  ***LOG BZY=>unexpected return code 1          calling DbSlCommit                   43  28.728167

TRACE-INFO: 120:  [    dbcon   ,00000]  ***LOG BYJ=>database function COMMIT     for connection R/3        failed          23  28.728190

HALT 20140904112721

tp finished with return code: 234

meaning:

  uncaught error -> function err_exit called

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

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

1105  sap_dext called with msgnr 951.

ec: 10; msgid: 00; retf: 0.

ERROR: uncaught internal error: [ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

ERROR: EXIT(16) -> process ID is: 4944

ERROR: uncaught internal error: [ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

ERROR: EXIT(16) -> process ID is: 4944

SAPup> Process with PID 4944 terminated with status 234 at 20140904112722!

### Phase PREP_IMPORT/TOOLIMPI:

SAPup> Starting subprocess in phase 'TOOLIMPI' at 20140904114512

    ENV: DBMS_TYPE=syb

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

    ENV: PATH=D:\usr\sap\QAS\DVEBMGS06\exe;D:\sybase\QAS\SCC-3_2\bin;C:\j2sdk1.4.2_28-x64\BIN;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\sybase\QAS\ASE-15_0\jobscheduler\bin;D:\sybase\QAS\ASE-15_0\dll;D:\sybase\QAS\ASE-15_0\bin;D:\sybase\QAS\OCS-15_0\lib3p64;D:\sybase\QAS\OCS-15_0\lib3p;D:\sybase\QAS\OCS-15_0\dll;D:\sybase\QAS\OCS-15_0\bin;D:\usr\sap\QAS\SYS\exe\uc\NTAMD64;\\DTYQAS\sapmnt\QAS\SYS\global\syb\NTAMD64\sybodbc;D:\sybase\QAS\DBISQL\bin

    ENV: SAPSYSTEMNAME=QAS

    ENV: dbs_syb_dbname=QAS

    ENV: dbs_syb_no_ext_check=1

    ENV: dbs_syb_port=4901

    ENV: dbs_syb_schema=SAPSR3

    ENV: dbs_syb_server=DTYQAS

    ENV: rsdb_ssfs_connect=1

EXECUTING D:\usr\sap\QAS\DVEBMGS06\exe\tp.EXE "pf=E:\UPGRADE\SUM\SUM\abap\var\TOOLIMPI.TPP" put QAS

This is D:\usr\sap\QAS\DVEBMGS06\exe\tp.EXE version 380.08.41 (release 720, unicode enabled)

TRACE-INFO: 1:  [     dev trc,00000]  Thu Sep 04 11:45:12 2014                                                         1440  0.001440

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

TRACE-INFO: 3:                                                                                                           18  0.001458

TRACE-INFO: 4:  [     dev trc,00000]      using "D:\usr\sap\QAS\DVEBMGS06\exe\dbsybslib.dll"                             13  0.001471

TRACE-INFO: 5:  [     dev trc,00000]  database is local: connect_timeout: 3                                           15546  0.017017

TRACE-INFO: 6:  [     dev trc,00000]  Thread ID:5012                                                                     77  0.017094

TRACE-INFO: 7:  [     dev trc,00000]  lib_dbsl 720 08/01/2013 11:14:00                                                   18  0.017112

TRACE-INFO: 8:  [     dev trc,00000]  720_EXT build                                                                      13  0.017125

TRACE-INFO: 9:  [     dev trc,00000]  Using dynamic link library 'D:\usr\sap\QAS\DVEBMGS06\exe\dbsybslib.dll'            27  0.017152

TRACE-INFO: 10:  [     dev trc,00000]  dbsybslib.dll patch info                                                           81  0.017233

TRACE-INFO: 11:  [     dev trc,00000]    SAP patchlevel  0                                                                13  0.017246

TRACE-INFO: 12:  [     dev trc,00000]    SAP patchno  500                                                                 12  0.017258

TRACE-INFO: 13:  [     dev trc,00000]    Last SYBASE DBSL patchlevel 0                                                    14  0.017272

TRACE-INFO: 14:  [     dev trc,00000]    Last SYBASE DBSL patchno         440                                             15  0.017287

TRACE-INFO: 15:  [     dev trc,00000]    Last SYBASE DBSL patchcomment Sybase IQ: Enable remote/secondary connect to SAP Sybase I (1737415)

TRACE-INFO: 16:                                                                                                           27  0.017314

TRACE-INFO: 17:  [     dev trc,00000]  lpc:(local) connection used on DTYQAS                                              59  0.017373

TRACE-INFO: 18:  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]      6986  0.024359

TRACE-INFO: 19:  [     dev trc,00000]  (30012) [08001] [SAP][ASE ODBC Driver]Client unable to establish a connection

TRACE-INFO: 20:                                                                                                           30  0.024389

TRACE-INFO: 21:  [     dev trc,00000]  syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                                   27  0.024416

TRACE-INFO: 22:  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4036]      2808  0.027224

TRACE-INFO: 23:  [     dev trc,00000]  (30012) [08001] [SAP][ASE ODBC Driver]Client unable to establish a connection

TRACE-INFO: 24:                                                                                                           27  0.027251

TRACE-INFO: 25:  [     dev trc,00000]  syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                                   25  0.027276

TRACE-INFO: 26:  [     dev trc,00000]  Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=DTYQAS;port=4901;uid=SAPSR3;db=QAS;pwd=xxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=2;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=3;ProtocolCapture=cap_p4344_comm_rd;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;

TRACE-INFO: 27:                                                                                                           72  0.027348

TRACE-INFO: 28:  [    dblink  ,00000]  ***LOG BY2=>sql error 30012  performing CON                                       317  0.027665

TRACE-INFO: 29:  [    dblink  ,00000]  ***LOG BY0=>[ASE Error SQL30012:08001][SAP][ASE ODBC Driver]Client unable to establish a connection[ASE Error SQL30012:08001][SAP][ASE ODBC Driver]Client unable to establish a connection

TRACE-INFO: 30:                                                                                                           35  0.027700

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 QAS failed (20140904114512, probably wrong environment).

SAPup> Process with PID 4344 terminated with status 232 at 20140904114522!

Accepted Solutions (1)

Accepted Solutions (1)

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Yasin,

***LOG BY0=>[ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'syslogs' in database 'QAS' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment

Refer: SyBooks Online (Archive)

Goto Page Manager error - error 1105

Regards,

Divyanshu

divyanshu_srivastava3
Active Contributor
yasin_kurtulus
Explorer
0 Kudos

Thank you Divyanshu

I ran this command 

Dump tran SID with truncate_only

Go

it passed the phase

Actually I was running truncate command other systems to cleaning logs I didnt think that command will work while upgrade

I appreciate it.

Answers (0)