SAP Knowledge Base Article - Preview

3484901 - Database dump failed with Msg 1166 after database auto expansion failure Error 7452 - SAP ASE

Symptom

  • Database dump

    dump database <SID> to "/file/path/...:
    go
  • Results in error 1166 and error 6913:

    Msg 1166, Level 16, State 4:
    Server '<SID>', Line 1:
    You cannot execute the command 'DUMP' on database '<SID>' because it was created with asynchronous initialization and it has not been fully initialized.
    Retry the command later.

    Msg 6913, Level 16, State 1:
    Server '<SID>', Line 1:
    DUMP DATABASE <SID> FULL is unable to clear the list of changed database pages.
    Future incremental dumps will be unnecessarily large until the next successful full DUMP DATABASE.

  • The ASE errorlog prints message 7452 indicating tha previous database auto expansion failed:

    Msg 7452
    Failed to find specified threshold in threshold cache on instance 1 for database <SID> (4), segment <n>, free space <nnn>.
    Use 'dbcc thresholds' to see the threshold cache contents.

  • There is no process is running the "CRDB AUINIT" command from sysprocesses but there is row of class="42" from sysattributes:

    select spid from master..sysprocesses where cmd="CRDB AUINIT"
    go
     spid
     ------

    -> 0 rows affected

    select class, object_type, object from master..sysattributes where class="42" and object=db_id("<SID>")
    go

    class   object_type  object  
    ------- -------------- --------
        42    D                4

    -> 1 row affected


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 & SP04 for Business Suite
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

dump, 1166, 6913, CR,  829509, 7452, threshold cache,  thresholds , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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 for Me (Login required).

Search for additional results

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