SAP Knowledge Base Article - Preview

2882962 - error 4352 while loading tran dump - SAP ASE

Symptom

LOAD TRAN on a db with shrunk log segments fails with Error 4352 - with traceflag 3182 we see -

> LOAD TRAN <SID> FROM '/backup_test/log/<SID>.TRAN.20200114.233002.14925.000'
2> go
Backup Server session id is: 190. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name '<SID>2001414A7A ' section number 1 mounted on disk file '/backup_test/log/<SID>.TRAN.20200114.233002.14925.000'
Backup Server: 4.166.1.1: Using dbiosize of 1048576 bytes for device /backup_test/log/<SID>.TRAN.20200114.233002.14925.000.
Backup Server: 4.165.1.1: Using iocount of 6 for device /backup_test/log/<SID>.TRAN.20200114.233002.14925.000.
Backup Server: 4.166.1.2: Using zonesize of 6291456 bytes for device /backup_test/log/<SID>.TRAN.20200114.233002.14925.000.
Backup Server: 4.166.1.3: Using blocksize of 65536 bytes for device /backup_test/log/<SID>.TRAN.20200114.233002.14925.000.
Backup Server: 4.165.1.2: Using numzones of 4 for device /backup_test/log/<SID>.TRAN.20200114.233002.14925.000.
Backup Server: 4.165.1.3: Using archcnt of 1 for device /backup_test/log/<SID>.TRAN.20200114.233002.14925.000.
Backup Server: 4.165.1.4: Using dbdevcnt of 83 for device /backup_test/log/<SID>.TRAN.20200114.233002.14925.000.
Backup Server: 4.166.1.4: Using pagesize of 16384 bytes for device /backup_test/log/<SID>.TRAN.20200114.233002.14925.000.
lddb__map_segments_and_holes: Source: dbsize=1277952000 logsize=81920000 holsize_log=18350080 holsize_dat=0 imrslogsize=0
lddb__map_segments_and_holes: Target: dbsize=1329070080 logsize=81920000 holsize_log=0 holsize_dat=0 imrslogsize=0
lddb__map_segments_and_holes: Segments dont match. remap_segments=1 datamatch=0 logmatch=1 imrslogmatch=1 force_noremap=0 tgt_dedicated_log=1 dmp_dedicated_log=1
lddb__map_segments_and_holes: datsize=1247150080 datsize_dmp=1196032000 mldsize=1329070080 mldsize_dmp=1277952000 extra_datsize_dmp=0
lddb__map_segments_and_holes: holsize_log_left=18350080 holsize_dat_left=0
lddb__map_segments_and_holes: Log needs to be rebuilt. logmatch=1 logsize + holsize_log=81920000 logsize_dmp + holsize_log_dmp=100270080 logmatch=1
Msg 4352, Level 16, State 1:
Server '<SID>', Line 1:
ASE cannot load this delta transaction dump (option 'enable delta tran dump' was set) because the number of logical pages in the source database log (81920000) is smaller than in the target (100270080). Please, add 18350080 log pages to database '<SID>' and retry.

 

This is an erroneous message. Actual issue that the location for the shrunk segments is marked incorrectly in sysusages.

Marked as 11 when it should be 9.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Enterprise Resource Planning (ERP) 6.0

Product

SAP ERP 6.0

Keywords

CR#818137, CR818137, 818137, load transaction , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.