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 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 Hybris Cloud for Customer

SAP Business ByDesign

SAP Cloud Applications Studio

Reproducing the Issue

  1. Login to Cloud Applications Studio
  2. Go to View-> Repository Explorer
  3. Select and expand object "SalesPriceList'
  4. Select query "QueryByGroupCode" and run operation "Execute Query"
  5. After run "Execute Query", "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 before firing the query.

You can initialize the BO by using query->Query By Group Code

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

Resolution

  1. Login to Cloud Applications Studio
  2. Go to View-> Repository Explorer
  3. Select and expand object "SlaesPriceList'
  4. Select query "QueryByGroupCode" and run operation "Execute Query"
  5. Fill in PLALL1/PLPRICE1/PLDISC1 in the pop-up window
  6. Click "OK"

Keywords

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

Product

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