ASE fails to start with error 3475 after manually deleting rows in sysusages in an attempt to shrink tempdb:
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 'tempdb' (id 2). This process will retry at intervals of one minute.
ERROR: Can't get a new log page in db 2. num_left=1 num_in_plc=1.
SAP Adaptive Server Enterprise (ASE) all versions
SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
recover, bcp, 1105, tempdb, sysusages, manual , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this pageThis 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.