How To Fix RSDD741 - Read table '&4' (size: '&3'), BLOCKSIZE=&1 ===> block characteristic '&2'

RSDD741 - Overview

• Message type: E = Error

• Message class: RSDD - Message class for data manager

• Message number: 741

• Message text: Read table '&4' (size: '&3'), BLOCKSIZE=&1 ===> block characteristic '&2'

What causes this issue?

The E or F table of the source for the aggregate structure is larger
than the parameter BLOCKSIZE in table RSADMINC. To prevent the temporary
database memory from overflowing, the aggregate structure is divided
into blocks. A characteristic whose value range is divided into
intervals is used to divide the structure up into blocks. Then only data
from such an interval is read from the source and written into the
aggregate.
Please note the following:
If the block characteristic is NOT the partition characteristic (the
request for the F table and a time characteristic for the E table), the
runtime can be much longer, because ALL partitions have to be read for
each block read. The program first tries to use the appropriate
partition characteristic as the block characteristic and only uses
another one if not enough blocks can be formed with it. In such a case,
it is very likely that the BLOCKSIZE is too small. If you can, increase
this value. (This is of course only possible if your database supports
partitioning and the InfoCube is also partitioned).
If the source is not partitioned, the program first takes the time
characteristics in the aggregate to form blocks. Only when not enough
blocks can be created does the system take other characteristics, (for
example, the aggregate only contains 0CALYEAR). It can be the case that
the blocks differ greatly in size, since the data is not shared out
equally (such a check would be too time-consuming). Try to choose the
BLOCKSIZE in such a way that the time characteristics can be used.
The least favorable option is to use a characteristic to form the blocks
that is not in the aggregate, but instead in the source. Then blocks
with a CHANGEID that is not equal to 0 have to be written into the F
table of the aggregate - and also compressed later on. Try to avoid this
case by changing the parameter BLOCKSIZE.
Unfortunately we do not have a general recommendation for the BLOCKSIZE,
since there are also large differences between the various databases
that SAP BW supports. If no value is maintained in Customizing for the
parameter BLOCKSIZE (activity in IMG: <DS:SIMG.RSDELTALIMIT>Parameters
for Aggregates</>), or if the value is 0, the SAP BW default value is
used, 100,000,000 (exception: DB Informix = 10,000,000).

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDD741 - Read table '&4' (size: '&3'), BLOCKSIZE=&1 ===> block characteristic '&2' ?

  The SAP error message RSDD741 typically occurs in the context of SAP BW (Business Warehouse) when there is an issue related to reading data from a table. This error message indicates that there is a problem with the block size or the characteristics of the data being read.
  
  Cause:
  
  Data Block Size: The error suggests that the block size of the data being read does not match the expected size. This can happen if the data model or the data source has been changed, or if there is a mismatch in the configuration.
  Characteristic Issues: The block characteristic mentioned in the error message may not be defined correctly or may not exist in the data model.
  Data Source Issues: There could be issues with the data source from which the data is being read, such as missing or corrupted data.
  Inconsistent Data: If the data in the InfoProvider is inconsistent or if there are issues