ADF copy activity is failed due to the source side error

Question

Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Divide by zero error encountered.',Source=,''Type=System.Data.SqlClient.SqlException,Message=Divide by zero error encountered.,Source=.Net SqlClient Data Provider,SqlErrorNumber=8134,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=8134,State=1,Message=Divide by zero error encountered.,},],'

Answer 1

@Ramanjaneyulu, Maram Venkata

Looks like the Azure Data Factory (ADF) copy activity has failed due to an error on the source side. The error message indicates that a divide by zero error occurred during a database operation. This means that the operation attempted to divide a number by zero, which is not possible as division by zero is undefined.

To troubleshoot this issue, you'll need to identify the source of the divide by zero error and take corrective action. Here are some steps you can take:

Check the source data for any columns or expressions that may contain a division by zero. If you find any, you'll need to modify the data to avoid the division by zero.

Review the copy activity's query to see if it includes any expressions that divide a number by zero. If it does, you'll need to modify the query to avoid the division by zero.

Check with the source system's administrator to see if there are any known issues that could cause a divide by zero error. If there are, you may need to work with them to resolve the issue.

Answer 2

I have same problem, Couldn't fix it by this guidance, please let me know if you have any other idea