Hi,
We are getting the following error while execution of ADF pipeline:
Failure happened on 'Source' side. ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147187341, error message: The database operation timed out; this may be due to a leading wildcard value being used in a filter condition. Please consider removing filter conditions on leading wildcard values, as these filter conditions are expensive and may cause timeouts..,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'
Query in the source, indeed contains the following filter conditions with wildcards but they are necessary:
In the past, there were times when ADF pipeline has run successfully.
<filter>
<condition attribute="kns_nameofvaccinator" operator="not-like" value="%\%" />
<condition attribute="kns_batchnumber" operator="not-like" value="%\%" />
<condition attribute="kns_nameofvaccinator" operator="not-like" value="%/%" />
<condition attribute="kns_batchnumber" operator="not-like" value="%/%" />
<condition attribute="kns_nameofvaccinator" operator="not-like" value="%|%" />
<condition attribute="kns_batchnumber" operator="not-like" value="%|%" />
<condition attribute="kns_batchnumber" operator="not-like" value="%"%" />
In the past, there were times when ADF pipeline has run successfully.
Anyone any ideas?
