SAP Knowledge Base Article - Preview

3247394 - Error SQL1105 "Can't allocate spac

Symptom

2 issues, unrelated

1. Error 1105 + 3475 on SID SPA

2. 1105 on default on saptools

SPA during recovery

00:0007:00000:00017:2022/08/07 13:24:15.95 server  ERROR: Can't get a new log page in dbid 4 (num_left=258, num_in_plc=259, num_in_plc_at_start=259, num_newlogpgs_allocated=0).
00:0007:00000:00017:2022/08/07 13:24:15.95 server  ERROR: Can't get a new log page in dbid 4 (num_left=258, num_in_plc=258, num_in_plc_at_start=258, num_newlogpgs_allocated=0).
...
00:0004:00000:00017:2022/08/07 13:24:19.07 server  Rebuilt syslogs gam for dbid 4

=> DB did come online
00:0008:00000:00017:2022/08/07 13:29:26.79 server  Database 'SPA' is now online.

Then immediately reporting 1105 and shortly followed by 34754

00:0002:00000:00023:2022/08/07 13:29:31.09 server  Can't allocate space for object 'ATM_MSG_LOG' in database 'saptools' because 'default' 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.
00:0006:00000:00096:2022/08/07 13:30:01.53 server  Error: 1105, Severity: 17, State: 2

00:0004:00000:00159:2022/08/07 13:38:35.73 server  ERROR: Can't get a new log page in dbid 4 (num_left=10, num_in_plc=10, num_in_plc_at_start=10, num_newlogpgs_allocated=0).
..
00:0006:00000:00159:2022/08/07 13:38:46.85 server  Error: 3475, Severity: 21, State: 7
00:0006:00000:00159:2022/08/07 13:38:46.85 server  There is no space available in SYSLOGS to log a record for which space has been reserved in database 'SPA' (id 4). This process will retry at intervals of one minute.

 

2. saptools out of space (1105 default)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16 SP03 PL10 for Business Suite
  • SAP NetWeaver (NW) - All versions
  • SAP Solution Manager (SOLMAN) 7.x ABAP

Product

SAP Solution Manager 7.2

Keywords

CR827003, CR#827003, 827003 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

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.