SAP Knowledge Base Article - Preview

2036081 - Errors 16072 and 18273 when attempting to drop user-defined thread pool and user-defined execution class - SAP ASE

Symptom

  • ASE 15.7 and up
  • Having user-defined thread pool and user-defined execution class, user binds execution class to a client application / login / stored procedure / default execution class.  Getting error when dropping thread pool and execution class:
    1> drop thread pool test_pool
    2> go
    Msg 16072, Level 16, State 1:
    Server 'sp110', Line 1:
    Threadpool test_pool is in use by an execution class definition. Delete the execution class before trying to drop the threadpool.
    1> sp_dropexeclass EC_test
    2> go
    Msg 18273, Level 16, State 1:
    Server 'sp110', Procedure 'sp_dropexeclass', Line 95:
    Either 'EC_test' is being used so it cannot be dropped or an internal error occurred. Check server errorlog for any additional information.
    (return status = 1)

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and up

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

thread pool,execution class , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.