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.