SAP Knowledge Base Article - Public

2688945 - OData Error "An unexpected error occurred when accessing the entity data model'

Symptom

You are running a OData query to retrieve report information, and the following error occurs: 'An unexpected error occurred when accessing the entity data model'.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics > Design Reports
  2. Find the report XYZ
  3. Select the report and click on Build OData Queries button
  4. Set the relevant filters to the report using the OData query builder
  5. Click on Generate Data Query once everything is set up
  6. Test the query
  7. See the following message appears: An unexpected error occurred when accessing the entity data model.

Cause

This error message is retrieved because you have added variable selections on one or more report fields from Report Wizard, on step 4 Characteristic Properties.

Resolution

Remove the variable selections from the report, and the OData query will run successfully. Please filter/restrict the report results using the OData query builder.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign 1802 ; SAP Business ByDesign 1805 ; SAP Business ByDesign 1808 ; SAP Business ByDesign 1811