SAP Knowledge Base Article - Public

2218922 - Cannot Migrate Price List When the Price List is Too Huge

Symptom

You are going to migrate price list by using the migration tool, but system gives an application error.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Search for activity Migration of Price Lists.
  4. Open it and open the migration tool.
  5. Select the migration file and click Execute Migration Step by Step.
  6. In the Simulation step, you get error: Application Error or Service Call Failed error.

You are not able to migrate the price list into system.

Cause

Issue is caused by memory error in backend when uploading huge price list via the migration workbench.

Resolution

Workaround is to use the Excel Add-in to upload the price lists.

Solution:  3 Step Process

  • Download and install of ByD excel Add-in and install
  • Download  price list template and fill the data and upload Template
  • Upload Data via excel.

Detailed Steps:

  1. Download and install of ByD excel Add-in
  2. Go to Application and User Management work center-> Download Center -> SAP Add-in for Microsoft Excel
  3. Steps to download price list upload Template
  4. Go to Product and Service Portfolio work center -> Pricing view -> Select Price List in pricelist dropdown -> click Download button to get the price list template.
  5. Steps to Upload Data via excel.
  6. Click on login option and enter the following details in the popup.

Change URL details: https://  Customer system URL -> Enter Login with user credentials -> Enter Data and click on  Save Data to  option.

Note: For optimum perfomance, the number of line items on the price list are best limited to around 10000 or less.
This applies to the Excel Upload, the Data Migration and also the releasing or cancelling of price and discount lists.

See Also

Related case documents:

2121972  - Dump While Filtering  the Number of Items in the Price List

2614379 - Error Faced During Price List Upload

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

2919441 - You are Not Able to Cancel the Release of a Price List or Discount List

Keywords

Price List,  Migration, Line Items, 10000, 10.000, performance, 500, Excel , KBA , price list , migration , line items , SRD-CC-MIG-CNT , Migration: Content , How To

Product

SAP Business ByDesign all versions