SAP Knowledge Base Article - Preview

2850272 - Unable to bind named cache to a database - SAP ASE

Symptom

When trying to bind a user created cache to a database getting the following errors:

1> sp_bindcache <dbname>_cache,<dbname>
2> go
Msg 857, Level 16, State 1:
Server 'svrname', Procedure 'sp_bindcache', Line 414:
Command Failed: Cannot bind or unbind database '<dbname>' 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 '<dbname>'.
(return status = 1)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

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 ONE Support launchpad (Login required).

Search for additional results

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