2167818 - sp_bindcache command fails due to level0 transaction and 864 error - ASE

Symptom

sp_bindcache command fails due to error message below:

Msg 864, Level 16, State 1:
Server 'servername', Procedure 'sp_bindcache', Line 303:
Command Failed: Cannot bind object 'xxxx', dbid '5' to cache
because you have active level0 scans on the target object. Retry the command
after terminating the scans.

Environment

SAP Adaptive Server Enterprise (ASE) All versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

sp_bindcache, dlevel0cnt , 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.