SAP Knowledge Base Article - Preview

2818056 - Error 4305 when loading a transaction dump taken after a failed transaction dump.

Symptom

Error message 4305 is reported when attempting to load a transaction log dump that was taken after previous transaction log dump failed.

Example sequence of events:

  1. dump database <db> to </dump_path/db.dmp>
  2. dump tran <db> to </dump_path/db_tran1.dmp>
  3. dump tran <db> to </dump_path/db_tran2.dmp>  <- this dump is not successful due to some failure with Backup Server
  4. dump tran <db> to </dump_path/db_tran3.dmp>

At this point, db_tran2.dmp might exist and is 0 bytes in size therefore cannot be loaded.

Now, upon loading:

  1. load database <db> from </dump_path/db.dmp>
  2. load tran <db> from </dump_path/db_tran1.dmp>
  3. load tran <db> from </dump_path/db_tran3.dmp>  <- this fails with 4305

Msg 4305, Level 16, State 1:
Server 'ase16', Line 1:
Specified dump file '/dumps/db_tran3.dmp' is out of sequence. Current time stamp is <earlier date> while dump was from <later date>.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Sybase, backupserver, dump, load, tranlog, CR819734, CR#819734, 819734, sequence, time stamp, transaction , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.