SAP Knowledge Base Article - Public

3277952 - DS fails to extract data from Odata adapter

Symptom

DS tries to extract data from Odata, but fails with error "RUN-058105: |<dataflow name>  Error preparing to read <Query Name>: <Exception occurs when executing 'begin' method of the adapter operation with ID [1]. (406) Not Acceptable [HTTP/1.1 406 Not Acceptable]>."

Environment

  • SAP BusinessObjects Data Services XI4.2 SP14 and higher version

Reproducing the Issue

  1. Create an Odata Adapter in Management Console.
  2. Create an Odata Adapter datastore in Designer.
  3. Set the Odata Adapter datastore 's Option "OData version" as "V4".
  4. Create a job to read data from the  Odata Adapter datastore's table.
  5. Run the job and it fails with error "RUN-058105: |<dataflow name>  Error preparing to read <Query Name>: <Exception occurs when executing 'begin' method of the adapter operation with ID [1]. (406) Not Acceptable [HTTP/1.1 406 Not Acceptable]>."

Cause

 Option "OData version" is "V4".

Resolution

Change the Odata datastore's option "Version" back to V2, and the issue will be resolved.

Keywords

DS, Odata, adapter,  query, 406, Acceptable  , KBA , EIM-DS-CON , Connectivity , Problem

Product

SAP Business ByDesign 2211