I am using ADF copy activity to copy data from Azure SQL DB to Azure SQL DB using MI authentication. issue in coping data

Question

I am using ADF copy activity to copy data from Azure SQL DB to Azure SQL DB using MI authentication. issue in coping data

Chimmili, Madhan 5

I am using ADF copy activity to copy data from Azure SQL DB to Azure SQL DB using MI authentication. all tables are available in both source and sink

Issue:

all the required permissions were already available for source and sink but data is not coping into sink table saying below error.

Failure happened on 'Sink' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Cannot find the object "dbo.appointment" because it does not exist or you do not have permissions.,Source=.Net SqlClient Data Provider,SqlErrorNumber=1088,Class=16,ErrorCode=-2146232060,State=11,Errors=[{Class=16,Number=1088,State=11,Message=Cannot find the object "dbo.appointment" because it does not exist or you do not have permissions.,},],'.

but when I tried 14 tables to copy data only 6 tables copy activity's are failing with above error.

and also

when tried to copy data from sink table to same table it is working.
when tried to preview data , it is showing preview

never came across this kind of issue. could anyone help me in resolving this.

Thanks in advance.

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-06-14T20:19:32.9866667+00:00

Hello Chimmili, Madhan

Welcome to the MS Q&A platform.

As per the error message, "Cannot find the object "dbo.appointment" because it does not exist or you do not have permissions"

this could be due to incorrect object name/schema or insufficient permissions.

Since you mentioned that the required permissions were already available for the source and sink, please Check if the object name and schema name are correct. Ensure the object exists in the sink database and the schema name is correct.

1 answer

Your answer

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-06-14T20:19:32.9866667+00:00

Hello Chimmili, Madhan

Welcome to the MS Q&A platform.

As per the error message, "Cannot find the object "dbo.appointment" because it does not exist or you do not have permissions"

this could be due to incorrect object name/schema or insufficient permissions.

Since you mentioned that the required permissions were already available for the source and sink, please Check if the object name and schema name are correct. Ensure the object exists in the sink database and the schema name is correct.

Answer 1

Chimmili, Madhan 5

Hello BhargavaGunnam,

the object exists in the sink database and the schema name is correct too.

I got actual issue, issue is I have mapped identity column from source to sink where MI Auth don't have identity insert permission.

when I tried removing identity mapping issue got resolved, where ADF able to copy data.

Thanks BhargavaGunnam for the response

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-06-17T03:42:01.4433333+00:00

Hello Chimmili, Madhan

Glad to know that you were able to resolve the issue, and thanks for sharing the details, as it helps the community look for answers to similar questions.
Sidra Naseem 0 Reputation points

2024-08-20T07:12:50.2766667+00:00

it was helpful. thanks!

Share via

I am using ADF copy activity to copy data from Azure SQL DB to Azure SQL DB using MI authentication. issue in coping data

1 answer

Your answer