VS2019 SSDT - Object reference not set to an instance of an object

olioxenfrees 6 Reputation points
2021-01-15T00:13:52.183+00:00

Hello,

I'm beginning a Database Project using SSDT in Visual Studio 2019 and am currently facing issues loading tables in the SQL Server Object Explorer. After connecting to the Azure DB (SQL Server 12.0.2000.8), I'm receiving the error "Object reference not set to an instance of an object"

56942-image.png

The error seems to imply a broken dependency somewhere from my tables. Stored procedures, Views, and other objects seem to load fine, as do the tables from other databases.

I'm quite new to SSDT and SQL Server in general so any advice on how to proceed with debugging would be much appreciated.

Thanks!

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,826 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-01-15T02:37:46.207+00:00

    Hi @olioxenfrees ,

    Did you find any related error information from system log?

    Did you try to restart your VS 2019 and run the VS 2019 as administrator?

    If not work, try to delete %LocalAppData%\Microsoft\VisualStudio\nn(version number)\ComponentModelCache and restart Visual Studio.

    If they all not work, try to restart your local machine or try the other suggestions from this similar thread.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.