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 and then execute your query.

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

  • 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 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. Fill in PLALL1/PLPRICE1/PLDISC1 in 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.

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