Azure Data Factory SAP CDC connector fails to load ODP names

arto pihlaja priva 0 Reputation points
2023-02-15T18:31:30.2433333+00:00

I want to connect to an SAP system using the SAP CDC connector. I'm not able to create the dataset, because the connector won't load any ODP names. The error message behind More says

Error code27153

*DetailsSap Odp operation 'ListOdpSourcesFromSap' failed. Error Number: '519', error message: 'ABAPCDS/ is not a valid context' Activity ID: df428b86-7356-4287-ab15-dc14e929eaa6
User's image

*
A similar error comes no matter which ODP context I choose, e.g. SAPI, ODF*SELF etc.
*
Seems something has changed about the SAP CDC connector.
The connection to the linked SAP systems is fine. I have used the same connector to the same system before, using the same user etc. Nothing on the SAP side has changed. I also tried with another SAP sandbox system that I've used before, with same results.
For apparences, the slash at the end of each ODP context name is something new. Before, it only read e.g. ABAP_CDS
The slash could be the reason why SAP won't identify the context.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,626 questions
{count} votes

1 answer

Sort by: Most helpful
  1. arto pihlaja priva 0 Reputation points
    2023-02-15T19:09:23.9966667+00:00

    Yes, confirming that by entering the values manually rather than using the dropdown values, I'm able to retrieve data.

    The dropdown values have an incorrect extra slash at the end that SAP doesn't recognize. I checked by debugging in SAP.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.