SAP Knowledge Base Article - Preview

3275779 - Error 806 when querying MDA table - SAP ASE

Symptom

  • Error 806 in the module mda_fill_and_send_monCachedObject() with a stack trace is reported in the ASE errorlog while inserting data into saptools..DBH_SNAP_CACHEDOBJECTS:
       
    Error: 806, Severity: 21, State: 1
    Could not find virtual page for logical page 3435053312 in database 'XXX'.
    ************************************
    SQL causing error : INSERT INTO saptools..DBH_SNAP_CACHEDOBJECTS( COLLECT_MODE, SNAPSHOT_TIMESTAMP, CacheName, CachedKB, DBName,
    ************************************
        
  • The stack trace includes the following functions:
       
    log_to_virt
    virtmap
    bufgrab
    getpage_with_validation
    pg_get_alloc_page
    mda__collect_cached_ptninfo
    mda_fill_and_send_monCachedObject
    mda_std_populate_cache
    hdl_reraise 
    mda_exec
    VTABRemoteAccess::startScan(short, short, bool)
        
  • dbcc page output shows this page is not in the range of the database:
       
    1> dbcc page(XXX, 3435053312, 0)
    2> go
    Page -859913984 is not in the range of pages for database id <Y>
    DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions (or specific version if related only to a specific SAP Basis)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

806, Error: 806, saptools, DBH_SNAP_CACHEDOBJECTS, saptools..DBH_SNAP_CACHEDOBJECTS, MDA, monCachedObject, log_to_virt, virtmap, pg_get_alloc_page, mda__collect_cached_ptninfo, mda_fill_and_send_monCachedObject, mda_std_populate_cache, mda_exec, VTABRemoteAccess::startScan(short, short, bool) , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.