We have created a CDS view on a S/4HANA Table. Connections are working fine. We are not able to fetch the data with option of first full load then incremental in data flow by considering the data size. When we do for only incremental load it executed fine on first execution but on the second run it's sending below mentioned error and no dump on SAP system. Do suggest. We are getting the below mentioned error with incremental load.
Job failed due to reason: at Source 'SAPSource': Error Message: DF-SAPODP-012 - SapOdp copy activity failure with run id: 368458d1-b007-48da-ac1a-fecf51282614, error code: 2200 and error message: ErrorCode=SapOdpOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Sap Odp operation 'Execute function module RODPS_REPL_ODP_PREFETCH with pointer 20230403070047.000030000' failed. Error Number: '666', error message: 'An exception with the type CX_SY_OPEN_SQL_DB was raised, but was not handled locally or declared ina RAISING clause.',Source=Microsoft.DataTransfer.Runtime.SapRfcHelper,'
Is it something related to CDS view?
Created CDS with limited records and created track with Timestamp column. My end result is able to fetch incremental records.
