SAP Knowledge Base Article - Public

2697858 - OData Query for Data Sources Does Not Work

Symptom

The OData query that was created via the Build OData Queries in data sources does not work. It results in the error message 'The request URI is not valid' (in Chrome only).

Environment

SAP Cloud for Customer

SAP Business ByDesign

Reproducing the Issue

  1. Make sure that your system is set up for this OData service as described in the help center article 'OData API for Data Sources'.
  2. Go to the Business Analytics work center, view Design Data Sources.
  3. Search for your data source and make sure that it is exposed.
  4. Click on Build OData Queries.
  5. Make the required selections and set filters if needed and click on Generate Data Query.
  6. Copy the link the is displayed in the OData Query box and paste it into a browser.

The link will not work. In Chrome, you will see the error message 'The request URI is not valid'.

Cause

Your user is a business user, however this service is only enabled for technical users.

Resolution

When logging into OData, make sure that you use the technical user defined in the communication arrangement (see step 2 of the mentioned help center article).

After this make sure to save and reactivate the communication arrangement

See Also

Help Center: Extract Data from Data Sources Using OData

OData Webinar

Keywords

OData, data source, analytics, generate data query, generate metadata query, the request URI is not valid , KBA , the request url is not valid , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Cloud for Customer core applications all versions