Designer load encountered an error

Designer load encountered an error This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions. Answered by: Question I just added SSDT to my Visual Studio 2010 Ultimate running on Windows 7 Pro 64 bits. I added a SQL Server 2008 database to a SQL Server 2012 Developer Edition 64 […]

Содержание

  1. Designer load encountered an error
  2. Answered by:
  3. Question
  4. Answers
  5. All replies
  6. Designer load encountered an error
  7. Asked by:
  8. Question
  9. All replies
  10. Designer load encountered an error
  11. Asked by:
  12. Question
  13. All replies

Designer load encountered an error

This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Answered by:

Question

I just added SSDT to my Visual Studio 2010 Ultimate running on Windows 7 Pro 64 bits.

I added a SQL Server 2008 database to a SQL Server 2012 Developer Edition 64 bits.

I connected SSDT to my SQL 2012 Instance and opened my database.

When I right click on any table and select «View Designer» it takes a while to show me the TSQL panel and a while later SSDT shows an error message saying

The designer encountered an error while loading the table definition».

VS error window has two entries:

Error 1 The target database schema could not be retrieved. Unable to reconnect to database. RFQ 0 0

Error 2 Failed to obtain schema information from database MYRFQ.RFQ.
Please close any open editors for this database, check your connection to this database, and refresh the database in Server Explorer. RFQ 0 0

If I conncect to SQL Server and the database with SQL Server Management Studio (the same Windows User) I am able to work the table definition without any problem.

I was able to edit a table definition once (without changing anything).

If I try to add a new table, I receive the same eror message.

Answers

We are unable to reproduce the issue, will re-open the investigation if the trace information is provided, Thanks

  • Proposed as answer by alvarom-MSFT Member Wednesday, August 22, 2012 9:18 PM
  • Marked as answer by Janet Yeilding Monday, August 27, 2012 8:54 PM

Is there any other information displayed in the «Data Tools Operations» window (you can open it via the menu View -> Other Windows -> Data Tools Operations)

Also, is it a very large schema? How long does it take between launching the designer and getting the error message on the designer surface?

Is there any other information displayed in the «Data Tools Operations» window (you can open it via the menu View -> Other Windows -> Data Tools Operations)

Also, is it a very large schema? How long does it take between launching the designer and getting the error message on the designer surface?

Thank you for your message alvarom-MSFT.

The first time I clicked on my Database Icon in the SQL Server Object Explorer it took 54 seconds to import the database model (29 tables).

I clicked refresh and after 95 seconds the Data Tools Operations window reported «Unable to import database model».

I closed VS and tried to design a table (without opening my VS Solution) after connecting to the database (it took 85 secs this time to import the database model), and after 20 secs it showed the designer without errors. I tried with another table and it worked Ok. again.

I opened my solution and tried again. This time also worked Ok. ?!

I closed VS. Reopened it, opened my solution, connected to the database from the SQL Server Object Explorer and I got again the error message, after 95 seconds.

I tried to design a table and after 27 secs it showed the error message

The designer encountered an error while loading the table definition».

I closed VS. Reopened it. Opened my solution. Tried to connect to my database and, after 95 secs, I got the «Unable to import database model» error message.

Closed again VS. Reopened it. I Tried to connect to my database without first opening my solution and I got the same erroe message «Unable to import database model» after 95 secs.

I don´t think the schema is very large as databases go. and the problem seems random, although very frequent.

The PC I am using for this has 2 GB RAM. Could memory be the cause?

Источник

Designer load encountered an error

This forum is closed. Thank you for your contributions.

Asked by:

Question

When attempting to update a table’s definition (i.e. «Open Table Definition..») the design surface fails to load.
However the T-SQL pane loads normally. It appears that the designer pane shows the Loading.. message endlessly. and then fails with error: «The designer encountered an error..».

— I tried to set the QueryTimeout longer, but no luck still.

— I can access/update the database with direct querites in the same VS environment, so it’s definitely not a connection or permissions problem.

— This only happens with the new Azure SQL database I created yesterday. With all other SQL databases that I run on Azure everything works okay (again, in the same VS environment).

I have Visual Studio Express 2012 for Web
Version 11.0.61030.00 Update 4

Thanks for any help,

The designer encountered an error during communicating with the Azure SQL database table. Whether the table is very large or not?

If the issue only occurred in specific Azure SQL databases, please check whether they have some special configurations and please open table definition for other table in the specific Azure SQL database to confirm whether the issue only occurs with the specific table.

In order to resolve this issue, please reboot your machine, run VS as admin, connect to the specific Azure SQL database from Database Explorer and open Table Definition for a table to check the result. If rebooting machine did not resolve this issue, please run VS as safe mode and reset your VS settings through Tools->Import and Export settings->Reset all settings->…..

I also suggest that you create a new user account and run VS under this new account to check whether the same issue will occur. If the issue will disappear under new user account, your user profile is corrupt. You have to create a new account and copy current user info to it

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Thank you, Crystal

The problem occurs with all tables in just 1 Azure database which I created a few days ago.
With all other Azure databases that I run under the same VS there are no problems.

The tables contain no data, and the definitions are very simple (see a sample below).

The T-SQL pane opens normally but the designer surface fails to load.

The corrupted VS user idea does not make sense, because if that was the case, all databases under my VS would have the same issue?

I will try reboot..

CREATE TABLE [dbo].[tbADPROVIDER] (
[Id] INT NOT NULL,
[name] VARCHAR (36) NOT NULL,
[curr] CHAR (3) NOT NULL,
[lastpolldate] DATETIME NULL,
[def_bid] FLOAT (53) NOT NULL,
[def_dailybudget] FLOAT (53) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);

Reboot didn’t help.

It just loads endlessly (several min).. and eventually fails.

These are errors:

Error 5 The target database schema could not be retrieved. Unable to reconnect to database: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. adagency2014 0 0

Error 6 Failed to obtain schema information from database epr78crzts.database.windows.net.adagency2014.
Please close any open editors for this database, check your connection to this database, and refresh the database in Server Explorer. adagency2014 0 0

Since this timeout issue only occurred with all tables in one Azure database, then this issue is more related to the specific Azure database instead of Visual Studio. If VS is the issue, then all Azure databases would not work correctly in VS Database Explorer.

Many other people got the similar/same timeout issue, please see:

Some solutions were provided, I summarize them and please follow the solutions below to check the result:

  1. Edit your windows registry (via RegEdit.exe) and change the value of «QueryTimeoutSeconds» from 60 to 480 or higher and then restart VS2013 to make the timeout value can be taken. Restarting VS is an important step.
  2. Upgrade to the latest Azure tool in VS Tools->Extension and Updates, disconnect to Azure database from VS, then connect to Azure Sql database again
  3. Close other opened editors for the Azure database and refresh the Azure database in Database Explorer

If all suggestions above does not resolve the issue, I don’t have other good suggestions because this issue involves Azure database technology, I am not Azure SQL Database expert, I suggest consulting this issue on Azure SQL Database forum because this issue is on the specific Azure SQL database, Azure database experts there can provide you better solutions.

Thank you for your understanding and support.

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Источник

Designer load encountered an error

This forum is closed. Thank you for your contributions.

Asked by:

Question

When attempting to update a table’s definition (i.e. «Open Table Definition..») the design surface fails to load.
However the T-SQL pane loads normally. It appears that the designer pane shows the Loading.. message endlessly. and then fails with error: «The designer encountered an error..».

— I tried to set the QueryTimeout longer, but no luck still.

— I can access/update the database with direct querites in the same VS environment, so it’s definitely not a connection or permissions problem.

— This only happens with the new Azure SQL database I created yesterday. With all other SQL databases that I run on Azure everything works okay (again, in the same VS environment).

I have Visual Studio Express 2012 for Web
Version 11.0.61030.00 Update 4

Thanks for any help,

The designer encountered an error during communicating with the Azure SQL database table. Whether the table is very large or not?

If the issue only occurred in specific Azure SQL databases, please check whether they have some special configurations and please open table definition for other table in the specific Azure SQL database to confirm whether the issue only occurs with the specific table.

In order to resolve this issue, please reboot your machine, run VS as admin, connect to the specific Azure SQL database from Database Explorer and open Table Definition for a table to check the result. If rebooting machine did not resolve this issue, please run VS as safe mode and reset your VS settings through Tools->Import and Export settings->Reset all settings->…..

I also suggest that you create a new user account and run VS under this new account to check whether the same issue will occur. If the issue will disappear under new user account, your user profile is corrupt. You have to create a new account and copy current user info to it

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Thank you, Crystal

The problem occurs with all tables in just 1 Azure database which I created a few days ago.
With all other Azure databases that I run under the same VS there are no problems.

The tables contain no data, and the definitions are very simple (see a sample below).

The T-SQL pane opens normally but the designer surface fails to load.

The corrupted VS user idea does not make sense, because if that was the case, all databases under my VS would have the same issue?

I will try reboot..

CREATE TABLE [dbo].[tbADPROVIDER] (
[Id] INT NOT NULL,
[name] VARCHAR (36) NOT NULL,
[curr] CHAR (3) NOT NULL,
[lastpolldate] DATETIME NULL,
[def_bid] FLOAT (53) NOT NULL,
[def_dailybudget] FLOAT (53) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);

Reboot didn’t help.

It just loads endlessly (several min).. and eventually fails.

These are errors:

Error 5 The target database schema could not be retrieved. Unable to reconnect to database: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. adagency2014 0 0

Error 6 Failed to obtain schema information from database epr78crzts.database.windows.net.adagency2014.
Please close any open editors for this database, check your connection to this database, and refresh the database in Server Explorer. adagency2014 0 0

Since this timeout issue only occurred with all tables in one Azure database, then this issue is more related to the specific Azure database instead of Visual Studio. If VS is the issue, then all Azure databases would not work correctly in VS Database Explorer.

Many other people got the similar/same timeout issue, please see:

Some solutions were provided, I summarize them and please follow the solutions below to check the result:

  1. Edit your windows registry (via RegEdit.exe) and change the value of «QueryTimeoutSeconds» from 60 to 480 or higher and then restart VS2013 to make the timeout value can be taken. Restarting VS is an important step.
  2. Upgrade to the latest Azure tool in VS Tools->Extension and Updates, disconnect to Azure database from VS, then connect to Azure Sql database again
  3. Close other opened editors for the Azure database and refresh the Azure database in Database Explorer

If all suggestions above does not resolve the issue, I don’t have other good suggestions because this issue involves Azure database technology, I am not Azure SQL Database expert, I suggest consulting this issue on Azure SQL Database forum because this issue is on the specific Azure SQL database, Azure database experts there can provide you better solutions.

Thank you for your understanding and support.

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Источник

Again another problem with designtoolsserver (from #6420)

Ok, so i got new error (updated to latest preview version from VS2022)

[16:25:46.8925168] Creating VSCodeDomDesignerLoader
[16:25:47.6300184] Processed 'System.Design' in 00:00:02.4840523
[16:25:47.6830170] Added 'System.Design'
[16:25:47.6840173] Loaded System.Drawing.Design in 00:00:00.0000227 [thread 56]
[16:25:47.6890185] Processed 'System.Drawing.Design' in 00:00:00.0055732
[16:25:47.6900189] Added 'System.Drawing.Design'
[16:25:48.8251525] [Thread 1] Creating design-time ITypeResolutionService.
[16:25:50.5392459] Start processing enqueued assemblies
[16:25:50.5392459] Loaded Microsoft.WinForms.DesignTools.Protocol in 00:00:00.0000178 [thread 79]
[16:25:50.7015014] Processed 'Microsoft.WinForms.DesignTools.Protocol' in 00:00:00.1625103
[16:25:50.7055005] Added 'Microsoft.WinForms.DesignTools.Protocol'
[16:25:50.7055005] Loaded Microsoft.WinForms.DesignTools.Client in 00:00:00.0000282 [thread 61]
[16:25:50.8610191] Processed 'Microsoft.WinForms.DesignTools.Client' in 00:00:00.1546868
[16:25:50.8630155] Added 'Microsoft.WinForms.DesignTools.Client'
[16:25:51.3873048] [Thread 68] Launching server...
[16:26:53.4778102] OutputGroupService didn't return output group DesignerRuntimeImplementationProjectOutputGroup.
[16:26:53.4778102] Could not retrieve DesignerRuntimeImplementationProjectOutputGroupPaths for current project.
[16:26:54.1809027] System.InvalidOperationException: Designer load encountered an error. Please ensure that the project can be built successfully.
                      at Microsoft.DotNet.DesignTools.Client.Host.ProjectInfoProvider.<GetProjectInfoAsync>d__4.MoveNext()
                   --- End of stack trace from previous location where exception was thrown ---
                      at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
                      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                      at Microsoft.DotNet.DesignTools.Client.Host.ServerHostFactory.<CreateHostAsync>d__7.MoveNext()
                   --- End of stack trace from previous location where exception was thrown ---
                      at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
                      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                      at Microsoft.DotNet.DesignTools.Client.DesignToolsClientLoader.<CreateClientAsync>d__28.MoveNext()
                   --- End of stack trace from previous location where exception was thrown ---
                      at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
                      at Microsoft.VisualStudio.Telemetry.WindowsErrorReporting.WatsonReport.GetClrWatsonExceptionInfo(Exception exceptionObject)
[16:26:54.3889082] Cannot update selection in server process as Session is not connected.

Updated to latest visual studio 2022 preview. Using .net6.0

And in designer display this:

image

And again i just created empty winforms project, and project can be built.

image

Same workaround from #6420

I must close then reopen project to design tools server start

I’ve problem with Visual Studio 2012 Ultimate.

I inserted a «Sql Server Database», and when I try to «Add new table» after a while I get this problem

The designer encountered an error while loading the table definition

and two errors in «Error List»

  1. The target database schema could not be retrieved. Unable to reconnect to database.

  2. Failed to obtain schema information from database
    (LocalDB)v11.0.C:USERSSRDJANDOCUMENTSVISUAL STUDIO 2012WEBSITESWEBSITE3APP_DATADATABASE.MDF.
    Please close any open editors for this database, check your connection to this database, and refresh the database in Server Explorer. C:USERSSRDJANDOCUMENTSVISUAL STUDIO 2012WEBSITESWEBSITE3APP_DATADATABASE.MDF

What can I do to get this working?

Picture

Patrick's user avatar

Patrick

17.4k6 gold badges69 silver badges83 bronze badges

asked Nov 28, 2012 at 17:07

DocNet's user avatar

4

I had the same issue, but it get resolved when I use «SQL Server Object Explorer» instead of «server explorer» to add new tables.

answered Jun 26, 2014 at 10:40

rawel's user avatar

rawelrawel

2,87525 silver badges32 bronze badges

1

Please check that the login you are using to connect to the database in VS has the necessary permissions to create tables.

answered Mar 12, 2013 at 9:23

sean's user avatar

seansean

10.8k8 gold badges47 silver badges56 bronze badges

Use «SQL Server Object Explorer» instead «server explorer» but close all the database connections that appear in the server explorer.

From the SQL server object explorer add the local SQL server and that’s it, works like a charm.

answered Jan 19, 2016 at 23:59

pedrommuller's user avatar

pedrommullerpedrommuller

15.6k9 gold badges75 silver badges124 bronze badges

0

I know this is a really old issue but in case anyone else didn’t have any luck with the answers above: what worked for me was simply disconnecting from the server and reconnecting.

answered Apr 2, 2015 at 18:31

starlord7's user avatar

starlord7starlord7

1,0342 gold badges9 silver badges14 bronze badges

Follow these steps:

  1. Right click on Data Connection
  2. Click Add Connection
  3. Select your Data Source
  4. Browse to the existing database file on your system (e.g. C:UserspcnameDocumentsdatabasefile.mdf)
  5. Click on Test Connection
  6. If connection succeeded then problem should be solved, otherwise try it after restarting Visual Studio

Nathan Tuggy's user avatar

Nathan Tuggy

2,23527 gold badges30 silver badges38 bronze badges

answered Mar 19, 2015 at 14:57

ashvin kumbhani's user avatar

Restarting Visual Studio fixed it for me. I’d had it open for a month or more.

Might be worth it to some people to try this simple step first before digging in deep.

answered Aug 24, 2017 at 21:27

Dennis T --Reinstate Monica--'s user avatar

To solve this problem do the following steps:

  1. Go to VS Tools → Options → Database Tools → Query And Views Designer.

  2. Set «Cancel Long Running Query» after 240 second.

  3. Delete all connections in «SQL server explorer» and «SQL Server Objects Explorer» — (this step is very important).

  4. Reopen VS and recreate your connections.

double-beep's user avatar

double-beep

4,85916 gold badges32 silver badges41 bronze badges

answered May 6, 2018 at 11:59

Ahmad Ezzat's user avatar

I had the same issue with visual studio 2013, because of wrong database name.

To solve it, go to Server explorer → right click on your database → Modify connection… → under «Connect to a database name:» select your correct database name.

double-beep's user avatar

double-beep

4,85916 gold badges32 silver badges41 bronze badges

answered Mar 10, 2016 at 10:32

Amit's user avatar

AmitAmit

511 silver badge2 bronze badges

If you are not using integrated security (Windows Authentication), then make sure the db user has the «db owner» role.

double-beep's user avatar

double-beep

4,85916 gold badges32 silver badges41 bronze badges

answered Feb 19, 2018 at 10:15

user3658516's user avatar

  • Remove From My Forums
  • Question

  • Hello

    When attempting to update a table’s definition (i.e. «Open Table Definition..») the design surface fails to load.

    However the T-SQL pane loads normally. It appears that the designer pane shows the Loading.. message endlessly,.. and then fails with error: «The designer encountered an error..».

    — I tried to set the QueryTimeout longer, but no luck still.

    — I can access/update the database with direct querites in the same VS environment, so it’s definitely not a connection or permissions problem.

    — This only happens with the new Azure SQL database I created yesterday. With all other SQL databases that I run on Azure everything works okay (again, in the same VS environment).

    I have Visual Studio Express 2012 for Web 
    Version 11.0.61030.00 Update 4

    Thanks for any help,

    Armin

    • Edited by

      Wednesday, October 15, 2014 12:03 PM

    • Moved by
      Amanda Zhu
      Thursday, October 23, 2014 1:49 AM
      customer’s issue is not on Visual Studio IDE, it is more related to SQL Server Azure database, I suggested that customer consults on SQL Server Azure forum for better support,customer accepted my suggestion, so I move this thread here.

  • Remove From My Forums
  • Вопрос

  • Hi,

    I was working on a simple Winforms C# project. I created a few of TableAdapters using the designer and attached them to datagridviews on my form. After realizing that i did not want one of the tables I went to the XSD designer and deleted it. After that the project still excutes ok but the form designer is unable to display the form in design view I get the following error:

    One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. Clicking on each error will take you to the line of code that caused it. 

    I am not looking for a response to this problem (creating prototype, kicking the tires ;-)) but hopefully Microsoft will address this issue with some sort of fix. The designer should probably utilize some referential integiry rules (cascade or restirct) before it allows one to remove items that will cause it not to function properly.

    Regards

    FredV

Ответы

The designer encountered an error while loading the table definition

Fix

Restarting computer

Failed Attempts

  • Tried reconnecting to Azure db
  • Tried restarting Visual Studio 2017
  • Tried using Visual Studio 2015

Other Odd Behaviors

This was the first time using Visual Studio 2017 (just installed).

An empty web project created.

Connected to Azure db previously created couple years ago and has been in use.

«View Designer» was working initially.

Right before breaking, I just created a new column and new unique index to 3 tables.

Initially unable to «View Designer» on those tables, but able to on the other tables.

After several attempts, unable to «View Designer» on all tables with VS2017 and 2015.

Disconnected and reconnected with no success.

Restarting Visual Studio with no success.

Rebooting my system (running Visual Studio) appears to have fixed the problem.

My guess is some connection was held up… but doesn’t make a lot of sense restarting application would fix that problem.

Home

  • home
  • articles
  • quick answersQ&A

    • Ask a Question
    • View Unanswered Questions
    • View All Questions
    • View C# questions
    • View Python questions
    • View Javascript questions
    • View C++ questions
    • View Java questions
  • discussionsforums

    • CodeProject.AI Server
    • All Message Boards…
    • Application Lifecycle>
      • Running a Business
      • Sales / Marketing
      • Collaboration / Beta Testing
      • Work Issues
    • Design and Architecture
    • Artificial Intelligence
    • ASP.NET
    • JavaScript
    • Internet of Things
    • C / C++ / MFC>
      • ATL / WTL / STL
      • Managed C++/CLI
    • C#
    • Free Tools
    • Objective-C and Swift
    • Database
    • Hardware & Devices>
      • System Admin
    • Hosting and Servers
    • Java
    • Linux Programming
    • Python
    • .NET (Core and Framework)
    • Android
    • iOS
    • Mobile
    • WPF
    • Visual Basic
    • Web Development
    • Site Bugs / Suggestions
    • Spam and Abuse Watch
  • featuresfeatures

    • Competitions
    • News
    • The Insider Newsletter
    • The Daily Build Newsletter
    • Newsletter archive
    • Surveys
    • CodeProject Stuff
  • communitylounge

    • Who’s Who
    • Most Valuable Professionals
    • The Lounge  
    • The CodeProject Blog
    • Where I Am: Member Photos
    • The Insider News
    • The Weird & The Wonderful
  • help?

    • What is ‘CodeProject’?
    • General FAQ
    • Ask a Question
    • Bugs and Suggestions
    • Article Help Forum
    • About Us

Copyright © CodeProject, 1999-2023
All Rights Reserved.

Web03
2.8:2023-01-23:1

CodeProject,
20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8
+1 (416) 849-8900

Designer load encountered an error

This forum is closed. Thank you for your contributions.

Asked by:

Question

When attempting to update a table’s definition (i.e. «Open Table Definition..») the design surface fails to load.
However the T-SQL pane loads normally. It appears that the designer pane shows the Loading.. message endlessly. and then fails with error: «The designer encountered an error..».

— I tried to set the QueryTimeout longer, but no luck still.

— I can access/update the database with direct querites in the same VS environment, so it’s definitely not a connection or permissions problem.

— This only happens with the new Azure SQL database I created yesterday. With all other SQL databases that I run on Azure everything works okay (again, in the same VS environment).

I have Visual Studio Express 2012 for Web
Version 11.0.61030.00 Update 4

Thanks for any help,

All replies

The designer encountered an error during communicating with the Azure SQL database table. Whether the table is very large or not?

If the issue only occurred in specific Azure SQL databases, please check whether they have some special configurations and please open table definition for other table in the specific Azure SQL database to confirm whether the issue only occurs with the specific table.

In order to resolve this issue, please reboot your machine, run VS as admin, connect to the specific Azure SQL database from Database Explorer and open Table Definition for a table to check the result. If rebooting machine did not resolve this issue, please run VS as safe mode and reset your VS settings through Tools->Import and Export settings->Reset all settings->…..

I also suggest that you create a new user account and run VS under this new account to check whether the same issue will occur. If the issue will disappear under new user account, your user profile is corrupt. You have to create a new account and copy current user info to it

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Thank you, Crystal

The problem occurs with all tables in just 1 Azure database which I created a few days ago.
With all other Azure databases that I run under the same VS there are no problems.

The tables contain no data, and the definitions are very simple (see a sample below).

The T-SQL pane opens normally but the designer surface fails to load.

The corrupted VS user idea does not make sense, because if that was the case, all databases under my VS would have the same issue?

I will try reboot..

CREATE TABLE [dbo].[tbADPROVIDER] (
[Id] INT NOT NULL,
[name] VARCHAR (36) NOT NULL,
[curr] CHAR (3) NOT NULL,
[lastpolldate] DATETIME NULL,
[def_bid] FLOAT (53) NOT NULL,
[def_dailybudget] FLOAT (53) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);

Reboot didn’t help.

It just loads endlessly (several min).. and eventually fails.

These are errors:

Error 5 The target database schema could not be retrieved. Unable to reconnect to database: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. adagency2014 0 0

Error 6 Failed to obtain schema information from database epr78crzts.database.windows.net.adagency2014.
Please close any open editors for this database, check your connection to this database, and refresh the database in Server Explorer. adagency2014 0 0

Since this timeout issue only occurred with all tables in one Azure database, then this issue is more related to the specific Azure database instead of Visual Studio. If VS is the issue, then all Azure databases would not work correctly in VS Database Explorer.

Many other people got the similar/same timeout issue, please see:

Some solutions were provided, I summarize them and please follow the solutions below to check the result:

  1. Edit your windows registry (via RegEdit.exe) and change the value of «QueryTimeoutSeconds» from 60 to 480 or higher and then restart VS2013 to make the timeout value can be taken. Restarting VS is an important step.
  2. Upgrade to the latest Azure tool in VS Tools->Extension and Updates, disconnect to Azure database from VS, then connect to Azure Sql database again
  3. Close other opened editors for the Azure database and refresh the Azure database in Database Explorer

If all suggestions above does not resolve the issue, I don’t have other good suggestions because this issue involves Azure database technology, I am not Azure SQL Database expert, I suggest consulting this issue on Azure SQL Database forum because this issue is on the specific Azure SQL database, Azure database experts there can provide you better solutions.

Thank you for your understanding and support.

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Источник

Designer load encountered an error

This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Answered by:

Question

I just added SSDT to my Visual Studio 2010 Ultimate running on Windows 7 Pro 64 bits.

I added a SQL Server 2008 database to a SQL Server 2012 Developer Edition 64 bits.

I connected SSDT to my SQL 2012 Instance and opened my database.

When I right click on any table and select «View Designer» it takes a while to show me the TSQL panel and a while later SSDT shows an error message saying

The designer encountered an error while loading the table definition».

VS error window has two entries:

Error 1 The target database schema could not be retrieved. Unable to reconnect to database. RFQ 0 0

Error 2 Failed to obtain schema information from database MYRFQ.RFQ.
Please close any open editors for this database, check your connection to this database, and refresh the database in Server Explorer. RFQ 0 0

If I conncect to SQL Server and the database with SQL Server Management Studio (the same Windows User) I am able to work the table definition without any problem.

I was able to edit a table definition once (without changing anything).

If I try to add a new table, I receive the same eror message.

Answers

We are unable to reproduce the issue, will re-open the investigation if the trace information is provided, Thanks

  • Proposed as answer by alvarom-MSFT Member Wednesday, August 22, 2012 9:18 PM
  • Marked as answer by Janet Yeilding Monday, August 27, 2012 8:54 PM

All replies

Is there any other information displayed in the «Data Tools Operations» window (you can open it via the menu View -> Other Windows -> Data Tools Operations)

Also, is it a very large schema? How long does it take between launching the designer and getting the error message on the designer surface?

Is there any other information displayed in the «Data Tools Operations» window (you can open it via the menu View -> Other Windows -> Data Tools Operations)

Also, is it a very large schema? How long does it take between launching the designer and getting the error message on the designer surface?

Thank you for your message alvarom-MSFT.

The first time I clicked on my Database Icon in the SQL Server Object Explorer it took 54 seconds to import the database model (29 tables).

I clicked refresh and after 95 seconds the Data Tools Operations window reported «Unable to import database model».

I closed VS and tried to design a table (without opening my VS Solution) after connecting to the database (it took 85 secs this time to import the database model), and after 20 secs it showed the designer without errors. I tried with another table and it worked Ok. again.

I opened my solution and tried again. This time also worked Ok. ?!

I closed VS. Reopened it, opened my solution, connected to the database from the SQL Server Object Explorer and I got again the error message, after 95 seconds.

I tried to design a table and after 27 secs it showed the error message

The designer encountered an error while loading the table definition».

I closed VS. Reopened it. Opened my solution. Tried to connect to my database and, after 95 secs, I got the «Unable to import database model» error message.

Closed again VS. Reopened it. I Tried to connect to my database without first opening my solution and I got the same erroe message «Unable to import database model» after 95 secs.

I don´t think the schema is very large as databases go. and the problem seems random, although very frequent.

The PC I am using for this has 2 GB RAM. Could memory be the cause?

Источник

Designer load encountered an error

This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Answered by:

Question

I was working on a simple Winforms C# project. I created a few of TableAdapters using the designer and attached them to datagridviews on my form. After realizing that i did not want one of the tables I went to the XSD designer and deleted it. After that the project still excutes ok but the form designer is unable to display the form in design view I get the following error:

One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. Clicking on each error will take you to the line of code that caused it.

I am not looking for a response to this problem (creating prototype, kicking the tires ;-)) but hopefully Microsoft will address this issue with some sort of fix. The designer should probably utilize some referential integiry rules (cascade or restirct) before it allows one to remove items that will cause it not to function properly.

Answers

FredV —
Thanks for posting this issue on the forums. Can you log this suggestion with additional details on the Product Feedback(http://lab.msdn.microsoft.com/productfeedback/) site so we can track it internally?

All replies

FredV —
Thanks for posting this issue on the forums. Can you log this suggestion with additional details on the Product Feedback(http://lab.msdn.microsoft.com/productfeedback/) site so we can track it internally?

This has happened to me also, on more than one occasion.

Sometimes I am able to get around it by editing the designer code and removing the erroneous references.

Other times I wind up having to junk my form and start fresh. And the acceptability of doing that is inversely proportional to the amount of time you’ve spent customizing it.

So unlike the original poster, I really am looking for a solution to this problem.

I got the same problem when upgrading a functioning project from Visual Studio .NET 2003 to Visual Studio 2005.

The upgrade wizard went through without errors, and the application can be executed normally, but none of my forms can be displayed in designer view.

I even get no error line number, only a line number 0, and a lot of details like:

at System.Resources.Tools.StronglyTypedResourceBuilder.DefineResourceFetchingProperty(String propertyName, String resourceName, ResourceData data, CodeTypeDeclaration srClass, Boolean internalClass, Boolean useStatic)
at System.Resources.Tools.StronglyTypedResourceBuilder.InternalCreate(Dictionary`2 resourceList, String baseName, String generatedCodeNamespace, String resourcesNamespace, CodeDomProvider codeProvider, Boolean internalClass, String[]& unmatchable)
at System.Resources.Tools.StronglyTypedResourceBuilder.Create(IDictionary resourceList, String baseName, String generatedCodeNamespace, String resourcesNamespace, CodeDomProvider codeProvider, Boolean internalClass, String[]& unmatchable)
at System.Resources.Tools.StronglyTypedResourceBuilder.Create(IDictionary resourceList, String baseName, String generatedCodeNamespace, CodeDomProvider codeProvider, Boolean internalClass, String[]& unmatchable)
at Microsoft.VisualStudio.Design.Serialization.ResXGlobalObject.BuildType()
at Microsoft.VisualStudio.Design.Serialization.ResXGlobalObject.GetObjectType()
at Microsoft.VisualStudio.Shell.Design.GlobalType.get_ObjectType()
at Microsoft.VisualStudio.Design.Serialization.ResXGlobalObject.get_Children()
at Microsoft.VisualStudio.Design.Serialization.ResXGlobalObjectProvider.CreateGlobalObjectsForItem(ProjectItem item, GlobalObjectCollection oldObjects, GlobalObjectCollection newObjects, ITypeResolutionService typeResolver)
at Microsoft.VisualStudio.Design.Serialization.ResXGlobalObjectProvider.CreateGlobalObjects(Project project)
at Microsoft.VisualStudio.Design.Serialization.ResXGlobalObjectProvider.GetGlobalObjectsCore(Project project, Type baseType)
at Microsoft.VisualStudio.Shell.Design.GlobalObjectProvider.GetGlobalObjects(Project project, Type baseType)
at Microsoft.VisualStudio.Shell.Design.GlobalObjectService.GetGlobalObjects(Type baseType)
at Microsoft.VisualStudio.Shell.Design.GlobalObjectService.GetGlobalObjects()
at Microsoft.VisualStudio.Design.Serialization.CodeDom.AggregateTypeResolutionService.GetTypeFromGlobalObjects(String name, Boolean throwOnError, Boolean ignoreCase)
at Microsoft.VisualStudio.Design.Serialization.CodeDom.AggregateTypeResolutionService.GetType(String name, Boolean throwOnError, Boolean ignoreCase)
at Microsoft.VisualStudio.Design.Serialization.CodeDom.AggregateTypeResolutionService.GetType(String name, Boolean throwOnError)
at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.GetType(ITypeResolutionService trs, String name, Dictionary`2 names)
at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.FillStatementTable(IDesignerSerializationManager manager, IDictionary table, Dictionary`2 names, CodeStatementCollection statements, String className)
at System.ComponentModel.Design.Serialization.TypeCodeDomSerializer.Deserialize(IDesignerSerializationManager manager, CodeTypeDeclaration declaration)
at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager manager)
at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager)
at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.DeferredLoadHandler.Microsoft.VisualStudio.TextManager.Interop.IVsTextBufferDataEvents.OnLoadCompleted(Int32 fReload)

I also would really appreciate if Microsoft would fix that asap.

Источник

Понравилась статья? Поделить с друзьями:

Читайте также:

  • Design time error
  • Description unexpected error minecraft
  • Description the server encountered an internal error that prevented it from fulfilling this request
  • Description mod loading error has occurred
  • Description invalid query как исправить

  • 0 0 голоса
    Рейтинг статьи
    Подписаться
    Уведомить о
    guest

    0 комментариев
    Старые
    Новые Популярные
    Межтекстовые Отзывы
    Посмотреть все комментарии