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:
- Go to the Product and Service Portfolio work center.
- Select the Price List view.
- Select the Price List XYZ (XYZ represents the name of the Price List).
- Open the Price List via the Name hyperlink.
After some time a dump occurs.
Reproducing the Download:
- Go to the Product and Service Portfolio work center.
- Select the Price List view.
- Select the Price List XYZ (XYZ represents the name of the Price List).
- Click on the Download button.
After some time a dump occurs. - Open The Price List XYZ.
- Click on the Download button in the Factsheet.
After some time a dump occurs.
Reproducing the Data Extraction:
- Go to the Application and User Management work center.
- Select the Data Extraction view.
- Click on the New button.
- Enter a Run ID and then choose the Extraction Object FLEX_PRICE_LIST - Price Lists
- Click add row and then provide the selection criteria.
- Click on Activate and Run.
- In the Application Log you can see that the Run finished with error.
- 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
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