SAP Knowledge Base Article - Preview

2613482 - Error 17523 when executing sp_dropsegment - SAP ASE


  • Trying to drop some space from one segment but it is not getting dropped in one database. The execution of sp_dropsegment fails with error 17523:

Msg 17523, Level 16, State 1:
Server 'ASE', Procedure 'sp_dropsegment', Line 342:
Segment 'default' does not reference device 'device1'.
(return status = 1)

  • Database size is not reduced.
  • Database status went to mixed log and data after dropping logsegment, but it was not mixed log and data before dropping the segment.
  • The requirement is to remove that logsegment space.



SAP Adaptive Server Enterprise (ASE) 15.7


SAP Adaptive Server Enterprise 15.7


drop segment, remove log segment, level , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.