Dynamics Community Forum Thread Details

ADF pipeline failed - Copy data from Dynamics 365 to Dynamics 365

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="%&quot;%" />



In the past, there were times when ADF pipeline has run successfully.



Anyone any ideas?