SAP Knowledge Base Article - Preview

3461356 - Error 940 after HK WASH and HKGC raised 1105 errors - ASE

Symptom

  • The follow errors are reported in the ASE error log:

Error: 1105, Severity: 17, State: 4
server  Can't allocate space for object 'syslogs' in database '<database>' 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: 940, Severity: 26, State: 11
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = 0, system task keep = 1, name ='<database>'

Error: 6103, Severity: 17, State: 1
Unable to do cleanup for the killed process; received Msg 940.
WARNING: spid 21958 with suid 49428 and curdbid 27 has an active transaction in dbid 27 with xactid (0, 0).

  • The following stack is also reported:

pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
hdl_default
s_handle
exc__raise
exc_raise
dbt_unkeep
xact_end_session
xact__endxact
xact__commitxact
xact__commit_local
xact_commit
s_execute
sequencer
execproc
s_execute
sequencer
tdsrecv_language
hdlr+0xeb8

  • The "keep" and "system task keep" is growing reported from continuous 940 errors:

Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = 0, system task keep = 1, name = '<database>'.
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = 0, system task keep = 1, name = '<database>'.
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = -1, system task keep = 1, name = '<database>'.
.
.
.
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = -1, system task keep = 37, name = '<database>'.
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = -1, system task keep = 37, name = '<database>'.
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = 0, system task keep = 38, name = '<database>'.


Read more...

Environment

SAP Adaptive Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0.4

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.