SAP Knowledge Base Article - Preview

2784838 - Database dumps with no issues / but load fails with error - SAP ASE

Symptom

  • Dumps are generated with no errors reported. 
  • When trying to load the dumps, it fails:

    It is only after the load has successfully started. 

Backup Server: 4.188.1.1: Database mydb: 82759470 kilobytes (46%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 84504690 kilobytes (47%) LOADED.
Backup Server: 4.139.2.22: [105] The 'uncompress' call failed for database/archive device while working on stripe device
'/sybase/dbdump01/mydb_04.dmp' with error number 0 (Error 0). Refer to your operating system documentation for further details. Look for 'Jun 18 12:20:14 2019: A04: SYBMULTBUF ERROR: ' in the backup server errorlog for additional information from SYBMULTBUF.
Backup Server: 6.32.2.3: /sybase/dbdump01/mydb_02.dmp: volume not valid or not requested (server: , session id: 127.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Backup Server: 6.32.2.3: /sybase/dbdump01/mydb_06.dmp: volume not valid or not requested (server: , session id: 127.)

  • Loads also fail without any compression:

Database mydb: 5520022 kilobytes (3%) LOADED.
Database mydb: 7333044 kilobytes (4%) LOADED.
Database mydb: 9003726 kilobytes (5%) LOADED.
/sybase/dbdump01/mydb_9.dmp: volume not valid or not requested (server: , session id: 6.)
Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
/sybase/dbdump01/mydb_5.dmp: volume not valid or not requested (server: , session id: 6.)
Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
/sybase/dbdump01/mydb_8.dmp: volume not valid or not requested (server: , session id: 6.)

  • These errors are repeated for several files.  However, there is nothing wrong with the files.  They have been checked and double checked.
  • Check sysusages - and they match on both systems.


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.