SAP Knowledge Base Article - Preview

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

Symptom

  • Database dump get error 1166:
    1> dump database <SID> to "/file/path/...:
    2> go
    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.

  • You find that the dump failed with Msg 1166 after previous database auto expansion failed with Error 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:
    1> select spid from master..sysprocesses where cmd="CRDB AUINIT"
    2> go
     spid
     ------

    (0 rows affected)

    1> select * from master..sysattributes where class="42" and object=db_id("<SID>")
    2> go
     class  attribute object_type
             object_cinfo
             object      object_info1 object_info2 object_info3 int_value
             char_value
             text_value
             image_value
             comments
             object_cinfo2
             object_datetime
     ------ --------- -----------
             -------------------------------------------------------------------------------------------------
             ----------- ------------ ------------ ------------ -----------
             -------------------------------------------------------------------------------------------------
             -------------------------------------------------------------------------------------------------
             -------------------------------------------------------------------------------------------------
             -------------------------------------------------------------------------------------------------
             -------------------------------------------------------------------------------------------------
             -------------------------------
         42         0 D
             NULL
                       4     42135040        65536            3        NULL
             NULL
             NULL
             NULL
             NULL
             NULL
                                        NULL

    (1 row affected)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL09 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.