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 for Me (Login required).

Search for additional results

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