SAP Knowledge Base Article - Preview

3027663 - Dropping a temporary object failed with Error 696 - SAP ASE

Symptom

  • Dropping a temporary object failed with Error 696.
  • Error: 696, Severity: 21, State: 1 An attempt was made to fetch logical page '3144' from cache 'tempdb_cache'. Page belongs to database 'tempdb' (2), object '<Unknown>' (0), index '<Unknown>' (0), partition '<Unknown>' (444436258) and not to database 'tempdb' (2), object '#bulk_00054710001243314' (1401067778), index '#bulk_00054710001243314' (0), partition '#bulk_00054710001243314_1401067778' (1401067778). Restart of ASE will clear the error.

  • Stacktrace includes:

    wrongpage
    getpage_with_validation
    getpage__noscan
    pg_latchoam
    pg_ptndeall
    trunc__ptn
    trunctab__phys
    trunctab
    dropo
    drop_with_retry
    tmp_s_free
    s_pop
    s_cleanframe
    clean_process
    kill_proc


Read more...

Environment

Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.