SAP Knowledge Base Article - Preview

2292790 - Alter Table Failed to Unpartition That May Produce Message 11051, Level 16, State 3 - SAP ASE

Symptom

  • A table fails to unpartition from a node that is just booted. 
  • A table fails to perform the alter table unpartition
  • Unpartition table may hit an error 16060, severity 20, state 1
  • error 16060, severity 20, state 1:
    You cannot modify the description of a system thread pool.
    Error out if 2901 is off
  • Msg 11051, Level 16, State 3:
    Server 'cluster_XYZ', Line 1:
    ALTER TABLE on the object 'fastload_tbl' failed. Table is currently being used
    by one or more other tasks. Retry your query later.

    (cluster_XYZ represents the name of the Server)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE).
  • Dataserver.
  • Linux on x86_64bit.
  • Linux on Power 64bit.

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

error 16060, severity 20, state 1, msg 11051, level 16, state 3, alter table, unpartition, fastload_tbl, CR#787245, CR787245, 787245 , 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.