Share via

Invalid Object Name Error in Azure Data Factory

Monica Manoharan 66 Reputation points
2022-02-07T07:16:01.777+00:00

Hello Team,

I have a linked service (service 1) already created a database and thats being reference by many other datasets in the Azure data factory. As a feature, new tables and stored procedures has been added to the database. But, these newly added tables and stored procedures are not being listed in the drop down while creating a dataset. But, when I create a new Linked Service (Service 2) pointing to the same database and try to create a dataset, new tables are being listed out.

so, what will happen to the existing connection, if the linked service (service 1) is deleted ?

also, is there a way to possibly list down the newly created tables and stored procedures with the existing linked service (service 1) itself ?

Thanks

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,749 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,651 Reputation points
    2022-02-07T08:08:42.54+00:00

    As I understand, the datasets pointing to Linked Service 2 is showing up all the DB Objects but the datasets pointing to Linked Service 1 is not.

    In this case, just cross check, what is the different between configuration of both the Linked services. Probably something is missing / invalid in Linked Service 1. Also check if test connection is successful for Linked service 1.

    Overall, you just need only one Linked service here.