Symptom
- Taking a database dump fails with the following error:
dump database <SID> to '<path>' with compression = '101'
goMsg 1166, Level 16, State 4:
Server '<database>', 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.
- Auto expansion of the logsegment is enabled on the database
- The following errors are reported in the <SID> log when auto expansion was execute:
- sddone: write error on virtual disk 7 block 68038656:
sddone: No space left on device - Error: 9004, Severity: 24, State: 1
I/O error detected on disk buffer 0x0x2e03e99f0 for page request 12633600, dbid 4.
- sddone: write error on virtual disk 7 block 68038656:
- When auto expansion tries to resize the ASE disk device, The following errors are reported:
- Asynchronous database initialization terminated prematurely for database '<database>'. Use DBCC DBREPAIR(SID, async_database_init, start) to restart it if required as uninitialized pages will incur a small performance penalty when they are first referenced.
background task message: Threshold action procedure 'sp_dbxt_extend_db' fired in db '<database>' on segment 'logsegment'. Space left: 327680 logical pages ('5120M'). - background task message: DISK RESIZE name = '<name>', size = '5120.0M' -- Db: <database> Segment: logsegment
basis_dsizecheck: attempt to write page 70785024 on device '<device>' failed, system error is: No space left on device
dresize: Cannot resize <file>. No space left on device. - Error: 5166, Severity: 16, State: 1
DISK RESIZE encountered an error while attempting to open/resize the physical file '<file>'. Please consult the ASE error log (in the ASE boot directory) for more details. - Error: 5113, Severity: 17, State: 1
Disk update for logical device = '<device>' with physical path '<path to device>' and virtual device number 7 failed. Please refer to ASE errorlog for more information
- Asynchronous database initialization terminated prematurely for database '<database>'. Use DBCC DBREPAIR(SID, async_database_init, start) to restart it if required as uninitialized pages will incur a small performance penalty when they are first referenced.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 on Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 Stand-alone
Product
SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions
Keywords
1166, sp_dbextend, sddone , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.