3230037 - Manual backup of database fail with 1166 error - ASE on Business Suite

• Taking a database dump fails with the following error:
  
  

  dump database <SID> to '<path>' with compression = '101'
  go

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

• SAP Adaptive Server Enterprise (ASE) 16.0 on Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 Stand-alone

1166, sp_dbextend, sddone , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem