SAP Knowledge Base Article - Preview

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

Symptom

  • 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


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.