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

• 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'.

SAP Adaptive Server Enterprise (ASE) all versions

"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