Symptom
- Binding a database to a named cache
- Fails with errors 857 & 19828:
sp_bindcache cache_name, db_name
Msg 857, Level 16, State 1:
Server 'svrname', Procedure 'sp_bindcache', Line 414:
Command Failed: Cannot bind or unbind database 'db_name' to or from a cache as it is currently in use.
If it is a user created temporary database, it is considered to be in use if some session is assigned to it. Refer to the users manual for more detail.
Msg 19828, Level 16, State 1:
Server 'svrname', Procedure 'sp_bindcache', Line 421:
Cache binding failed for database 'db_name'
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
SAP Solution Manager 7.2
Keywords
sp_bindcache command , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.