SAP Knowledge Base Article - Preview

2056295 - ALTER TABLE / CREATE CLUSTERED INDEX / DROP INDEX fails with error 14127 "Cannot drop or modify partition descriptor" - SAP ASE

Symptom

  • ALTER TABLE ... LOCK command executed to change the lock scheme for a large table may run for a lengthy time
  • CREATE CLUSTERED INDEX command may run for a lengthy time
  • ALTER TABLE ... LOCK or CREATE CLUSTERED INDEX or DROP INDEX command fails (possibly after some hours) with ASE error 14127:

    Msg 14127, Level 16, State 2:
    Server 'SYBASE', Line 1:
    Cannot drop or modify partition descriptor database 'mydb' (23), object 'mytable' (430621546), index 'mytable' (0), partition 'mytable_430621546' (430621546) as it is in use. Please retry your command later. Total reference count '8'. Task reference count '4'.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

"CREATE CLUSTERED INDEX" , "alter lock scheme" , "alter table lock", "drop index" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.