SAP Knowledge Base Article - Preview

2850272 - Error 857 : Cannot bind or unbind database to or from a cache - SAP ASE

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.