ADF: Error while using SAP CDC incremental load

Question

ADF: Error while using SAP CDC incremental load

Kuersat1 25

I want to extract data from a CDS-View using the CDC Connector in Data Factory. However, I encounter the following error when executing the dataflow:

Job failed due to reason: at Source 'source1': Please check error message, if it contains SAP server related error stacktrace, please contact SAP admin for assistance. Otherwise, please contact Microsoft support for further assistance. Error Message: fail to import schema, with reason: Retry Request, fail to reach https://dmweuaksig1aks.svc.datafactory.azure.com/sparkjob/forwardRequest with with code: 500, exception:, detailed exception: com.microsoft.datafactory.dataflow.common.service.httpclient.HttpRequest$$anon$2.process(HttpRequest.scala:81)

org.apache.http.protocol.ImmutableHttpProcessor.process(ImmutableHttpProcessor.java:142)

org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:190)

org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)

org.apache.http.impl.execchain.ServiceUnavailableRetryExec.execute(ServiceUnavailableRetryExec.java:85)

org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110)

org.apache.http.impl.client.InternalHttpClient.doExecute(Int

Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-07-19T18:48:49.0266667+00:00

Hello Ace,

Welcome to the Microsoft Q&A forum.

Per the error message, there might be an issue with the SAP server.

Please verify whether the SAP server is up and running. Also, check that the SAP CDC connector is properly configured in Azure Data Factory.

See the below document:

https://github.com/MicrosoftDocs/azure-docs/blob/main/articles/data-factory/sap-change-data-capture-prepare-linked-service-source-dataset.md
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-07-21T17:00:40.6466667+00:00

Hello Ace,

I am checking to see if you got a chance to look into my earlier response.
Kuersat1 25 Reputation points

2023-07-24T12:03:02.4166667+00:00

Hello BhargavaGunnam-MSFT,

I have ensured that the SAP server is running, and the CDC connector has been configured correctly. The error message persists.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-07-25T19:07:20.2466667+00:00

Hello Ace,

Thanks for the confirmation. As the next steps, I would suggest filing a support request so a support engineer can look deeper into the logs to troubleshoot the issue further. If you don't have a support plan, I can enable one-time free support for you to work closely on this matter.

I am looking forward to hearing from you.
Kuersat1 25 Reputation points

2023-07-26T10:14:35.6366667+00:00

Hello BhargavaGunnam-MSFT,

I don't have a support plan, but I would appreciate it if you could enable one-time free support for me.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-07-26T14:46:37.6866667+00:00

Hello Ace,

Could you please send an email to AzCommunity@microsoft.com with the below details so that we can enable one-time-free support for you?

Email subject: <Attn - Bhargava : Microsoft Q&A Thread title>

Thread URL: <Microsoft Q&A Thread>

Subscription ID: <your subscription id>

Looking forward to your reply.

Regards,

BhargavaGunnam-MSFT

AzCommunity@microsoft.com