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

Diagnosis
The E or F table of the source for the aggregate structure is largerthan the parameter BLOCKSIZE in table RSADMINC. To prevent the temporarydatabase memory from overflowing, the aggregate structure is dividedinto blocks. A characteristic whose value range is divided intointervals is used to divide the structure up into blocks. Then only datafrom such an interval is read from the source and written into theaggregate.
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), theruntime can be much longer, because ALL partitions have to be read foreach block read. The program first tries to use the appropriatepartition characteristic as the block characteristic and only usesanother 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, increasethis value. (This is of course only possible if your database supportspartitioning 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 enoughblocks can be created does the system take other characteristics, (forexample, the aggregate only contains 0CALYEAR). It can be the case thatthe blocks differ greatly in size, since the data is not shared outequally (such a check would be too time-consuming). Try to choose theBLOCKSIZE 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 blockswith a CHANGEID that is not equal to 0 have to be written into the Ftable of the aggregate - and also compressed later on. Try to avoid thiscase 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 databasesthat SAP BW supports. If no value is maintained in Customizing for theparameter BLOCKSIZE (activity in IMG: Parametersfor Aggregates), or if the value is 0, the SAP BW default value isused, 100,000,000 (exception: DB Informix = 10,000,000).