Azure data factory pipeline copy activity failure

Question

I am getting " The new name (table name) is already in use as a object name and would a duplicate that is not permitted" in Azure data factory pipeline using copy activity. This pipeline will get triggered when a code is executed and a file is written to a specific path in ADLS. Is it failing because code is executed with in some seconds gap because copy of data from adls and SQL dB will only take up to 25 minutes for few data sets..
Please help if we can fix this error by any other way other than communicating to the person who executes the code back to back within seconds to wait for few minutes before executing the code the next time

Answer 1

Hi @Arunkumar R ,

Thank you for posting query in Microsoft Q&A Platform.

As per my understanding you are getting error " The new name (table name) is already in use as a object name and would a duplicate that is not permitted" in ADF copy activity. Correct me if my understanding is wrong.

This kind of error will come you are trying to create object(Table of Stored procedure or View etc..) which is already present in database. Or when you try to create a object with same name of database name or with same name of any other object in DB.

Could you please cross check is your Copy activity trying create table or any object?

What exactly your code is doing? From where your code is taking data and loading in to ADL file? As of now I don't see anything from code which may cause this error. Kindly check above points and see if that helps.

You can use below query to see if object already exists in DB.

SELECT *  
 from sys.objects  
 where name = 'YourName'  

Hope this helps. Please let us know if any further queries.

---------
Please consider hitting Accept Answer. Accepted answers helps community as well.