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
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.