2556199 - Error 12920 running dbcc CHECKSTORAGE or CHECKREPAIR - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2556199 - Error 12920 running dbcc CHECKSTORAGE or CHECKREPAIR - SAP ASE

Symptom

  • dbcc checkverify or checkrepair cannot be executed
  • Error 12920 is raised by ASE:
    Error: 12920 Severity 16
    The last completed DBCC CHECKSTORAGE for this database has been processed.
    You must perform another DBCC CHECKSTORAGE before you can use CHECKVERIFY or CHECKREPAIR.
    Use sp_dbcc_summary_report to view the DBCC operations performed. 
     
  • Table dbccdb..dbcc_operation_log displays operations for dbcc checkstorage (optype =2) and
  • Another operation in the same sequence number as the dbcc checkstorage operation (in this example opid = 86) are displayed:

     
    select * from dbccdb..dbcc_operation_log
     go
     dbid   opid     optype  suid             start                                       finish                                  seq       id               maxseq
     ------ ------      ------      -----------      -------------------------------         -------------------------------     ------      -----------    ------
     5       86         2          10334          Nov  1 2017  9:53PM            Nov  1 2017  9:53PM         NULL   NULL         1
     5       86         3          10334          Nov  1 2017 10:12PM           Nov  1 2017 10:12PM        1          NULL         NULL

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) - all versions

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , 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 ONE Support launchpad (Login required).

Search for additional results

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