SAP Knowledge Base Article - Preview

2717151 - ASE logs Error 3475 and The logsegment shows negative value in sp_helpsegment report.

Symptom

The logsegment reports a negative used_page value when sp_helpsegment report is issued.  ASE errorlog reports the following for the database.

ERROR: Can't get a new log page in dbid 12 (num_left=5, num_in_plc=21, num_in_plc_at_start=26, num_newlogpgs_allocated=1).
Rebuilt syslogs gam for dbid 12
ERROR: Can't get a new log page in dbid 12 (num_left=5, num_in_plc=5, num_in_plc_at_start=5, num_newlogpgs_allocated=1).
Error: 3475, Severity: 21, State: 7
There is no space available in SYSLOGS to log a record for which space has been reserved in database '<db_name>' (id 12). This process will retry at intervals of one minute.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.x
SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

log page, 3475, negative value. , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.