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 for Me (Login required).

Search for additional results

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