Skip to main content

[Collect / Data Services] Build Error: “The maximum message size quota..."

Ben Bauer
  • Updated

Version - All released versions of Collect, SAP Data Services 14.2.X

Issue

When attempting to build a table in Collect using the "SAP Data Services" or "SAP Data Services using RFC" package type, the following error is generated: 

 “Build package for ‘tablename’ failed The maximum message size quota for incoming messages (65536) has been exceeded.”

Cause

A large number of batch jobs existing in a single Data Services repository.  [DSP70-453]

Resolution

WARNING: You must be running a 7.1.4 (or later) release of the SST/DSP product to resolve this issue.  Prior to this release, there is a serious bug related to assigning different Collect sources to different repositories.  The bug causes batch jobs to be built in the wrong repository.  [DSP70-807]

To avoid this error, create and register an additional repository for separate Collect sources to minimize the chance of overloading the communication between Collect and Data Services.  Each Data Services repository used by Collect should be dedicated to Collect.  In other words, no other tools or users should be creating batch jobs in the repositories that are being used by Collect.

To configure a source for SAP Data Services:

  1. Go to the Collect -> Targets -> 'Sources' -> {vertical} -> {Advanced Settings} tab.
  2. Click 'Edit'.
  3. Select the name of the target source repository from the [Data Services ID] list box.
    • NOTE: If this field is blank, the repository set at the target level is used. Consider creating and registering an additional repository for separate target sources to minimize the chance of overloading the communication between Collect and Data Services.
  4. Select a database connection type from the [Data Services Connection Type] list box to connect to the source database if using SAP Data Services.
    • NOTE: Refer to SAP documentation for details about the types of Data Services connections.
    • NOTE: If the Data Services Connection Type is SAP Application for a Target Source, the Test Connection icon is disabled on the Target Sources page Horizontal View for that Target Source. Connections to SAP can only be made through Data Services or RFC.
  5. Click 'Save'.

Other Workarounds (useful for SST/DSP releases prior to 7.1.4)

There are a few options to try to eliminate the error.

  • Register only 1 source in each Collect target that will be using Data Servcies package types.  Then register a different repository to each Collect target.  This is similar to the solution listed in the Resolution section.
  • Make your Collect target and Collect source names as short as possible.  These names are included in the name of the batch jobs that are created.  Shorter batch job names will allow for more batch jobs to be built before the "maximum message size" error appears.
  • Access the repository with the Data Services designer and ensure that only the Batch Jobs you need Collect to run are there.  All others should be removed.

Related articles