User configuration issue in azure pipeline in data factory

Rohit Boddu 466 Reputation points
2020-11-02T07:43:01.883+00:00

Hi,

one of my users is facing below issue i am not able to find out why he is getting such error ..

error code : 2402
Failure type : user configuration issue
details : execution failed against sql server with error number 15165 .. could not found object or do not have permission..

i researched on google if i can get any article for this but couldnt find.
how to tackle with this issue.

Regards,
Rohit

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,996 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,833 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,746 Reputation points
    2020-11-04T10:58:17.083+00:00

    The error says "couldn't find object" so cross check once if that DB name, Schema name and table name is correct and schema, table exists


    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    2 people found this answer helpful.
    0 comments No comments

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.