SAP Knowledge Base Article - Public

3034345 - Error While Opening Custom DataSource: Query execution failed

Symptom

You are receiving below errors while opening the custom data source created from SDK:

No connection to search engine

The FSI entity VIEW (Name: YXYZ) has no core part, where YZXYZ is the custom query definition.

View definition YXYZ could not be found

Query execution failed

Dereferencing of the NULL reference

Unexpected error occured

Environment

SAP Cloud for Customer

SAP Business ByDesign

SAP Cloud Application Studio

Reproducing the Issue

  1. Login to UI.
  2. Navigate to Business Analytics work center view.
  3. Select Data Source view.
  4. Search and open the relevant data source.
  5. Error appears.

Cause

This usually happens if the data source and the associated FSI view is inactive in the backend.

Resolution

If the issue is happening in the development tenant, login to SDK and activate the data source and SADL file.

If the issue is in production tenant where the solution is uploaded, you can raise an incident to get the files activated.

Keywords

inactive FSI views Query definition is inactive in the backend , KBA , no connection to search engine , the fsi entity view has no core part , view definition cannot be found , AP-RC-BDS-ANA , ByDesign Studio Analytics , Problem

Product

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