SAP Knowledge Base Article - Public

3079750 - Error When Opening, Downloading, Extracting or Querying Price List or Discount List

Symptom

You are trying to open, download, extract or read via the web service a Price List or Discount List put the download or data extraction fails due to a time out error.

Environment

SAP Business ByDesign

Reproducing the Issue

We are using Price Lists as an example.

Reproducing the Download:

  1. Go to the Product and Service Portfolio work center.
  2. Select the Price List view.
  3. Select the Price List XYZ (XYZ represents the name of the Price List).
  4. Open the Price List via the Name hyperlink.
    After some time a dump occurs.

Reproducing the Download:

  1. Go to the Product and Service Portfolio work center.
  2. Select the Price List view.
  3. Select the Price List XYZ (XYZ represents the name of the Price List).
  4. Click on the Download button.
    After some time a dump occurs.
  5. Open The Price List XYZ.
  6. Click on the Download button in the Factsheet.
    After some time a dump occurs.

Reproducing the Data Extraction:

  1. Go to the Application and User Management work center. 
  2. Select the Data Extraction view. 
  3. Click on the New button.
  4. Enter a Run ID and then choose the Extraction Object FLEX_PRICE_LIST - Price Lists
  5. Click add row and then provide the selection criteria.
  6. Click on Activate and Run.
  7. In the Application Log you can see that the Run finished with error. 
  8. When opening the respective Application Log ID the following error is displayed:
    RFC exception SYSTEM_FAILURE raised; No more memory available 

Cause

The Price List XYZ is a high volume Price List and exceeds 10000 items.

For optimum performance, the number of line items in a price list are best limited to around 10000 or lesser.

Resolution

You should consider splitting your price list into multiple price list so they dont exceed 10000 items.

If you need to extract a high volume Price List or Discount List from the system you can use the web service ManageSalesPriceListIn with the operation Read price lists with filter.

Please see the following Blog for details on how to use the web service and the operation: Price List and Discount List Read with Pagination in SAP Business ByDesign Cloud ERP

Please note that with Release 2502 we introduced a Filter Option for the Data Extraction of Price Lists and Discount Lists:

You can now filter Sales Price Lists and Discount Lists that are in Released status and have a specific validity start date or validity end date along with the filter option Price List ID or Discount List ID using newly added data extraction objects , FLEX_DISCOUNT_LIST01-Discount List (with Filters),

FLEX_PRICE_LIST_1 - Price List (with Filters),

Selection criteria parameters:

  • Price List ID or Discount List ID
  • Status (Enter 3 for Released Status) (Other Statuses : 1- Not Released, 2-Partially Released, 5-Release Canceled)
  • Validity Start Date (should be maintained in YYYYMMDD format)
  • Validity End Date (should be maintained in YYYYMMDD format)

Keywords

Data Extraction; Price List; Discount List; Download; Extract; Read; Query; Dump; System Error; Memory; Time Out; 10000; limitation; , KBA , AP-PMD-SPS , Sales Price Specification. , Problem

Product

SAP Business ByDesign all versions