Cannot find the object \"NidSitesTest\" because it does not exist or you do not have permissions.

RXR 121 Reputation points
2022-06-13T13:37:17.153+00:00

@Nasreen Akter @KranthiPakala-MSFT @ShaikMaheer-MSFT

Please review this query

I'm login as root user. So I have all the permissions to do truncate or delete. Please help me to resolve this issue.

{"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'NidSitesTestUpdate': shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object \"NidSitesTest\" because it does not exist or you do not have permissions.","Details":"shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object \"NidSitesTest\" because it does not exist or you do not have permissions.\n\tat

![210856-image.png][3] [3]: /api/attachments/210856-image.png?platform=QnA

211134-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,218 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,506 Reputation points Microsoft Employee
    2022-06-14T11:24:33.627+00:00

    Hi @RXR ,

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

    From error message it seems either table NidSitesTestUpdate not exists in SQL Db or User ID used in linked service to connect to SQL Db doesn't have permissions to access table NidSitesTestUpdate.

    Kindly check above both the cases to resolve the issue. If tables exists in Db then make sure if permissions are there to work with that table for your user Id to perform select and updates.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.