SAP Knowledge Base Article - Public

2626001 - Error "HTTP 500 (InternalServerError)" Appears while Executing Query QueryByGroupCode of Business Object SalesPriceList in the Repository Explorer

Symptom

You receive an error message "HTTP 500 (InternalServerError- Dump or unhandled exception in backend)" when you execute the query QueryByGroupCode of Business Object SalesPriceList in Repository Explorer.

Environment

  • SAP Cloud for Customer
  • SAP Business ByDesign
  • SAP Cloud Applications Studio

Reproducing the Issue

  1. Login to SAP Cloud Applications Studio.
  2. Go to View -> Repository Explorer.
  3. Select and expand business object SalesPriceList.
  4. Select the query QueryByGroupCode and run operation Execute Query.
  5. After running "Execute Query", the "Query Parameter Selection" window pops up.
  6. Click OK.
  7. Error message "HTTP 500 (InternalServerError- Dump or unhandled exception in backend)" appears.

Cause

SalesPriceList is a generic BO which stores both Price and Discounts. Therefore, you need to use SalesPriceList BO to fire the query. As this BO stores both price and discount, it is mandatory to initialize the BO with the related groud cope and then execute your query.

You can initialize the BO by using query -> Query By Group Code. The below codes are:

  • PLPRICE1 - If you want to query price lists.
  • PLDISC1 - If you want to query discount lists.
  • PLALL1 - It will initialize with both, so you can query either discounts or prices.

Resolution

  1. Login to SAP Cloud Applications Studio.
  2. Go to View-> Repository Explorer.
  3. Select and expand business object SalesPriceList.
  4. Select the query "QueryByGroupCode" and run operation Execute Query.
  5. Fill in PLPRICE1, PLDISC1 or PLALL1 in the "Lower Boundary Value" field from the pop-up window.
  6. Click OK.

After performing these steps, you are then be able to run the query you were initially trying to.

Note: Executing the SelectAll query does not require any parameters.

Keywords

QueryByGroupCode, SalesPriceList, Repository, Explorer , KBA , csg_q , AP-RC-BDS-QRY , ByDesign Studio BO Queries , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions