SolvedPrivate

Microsoft Visual Studio is busy

Posted on 2013-06-12
13
32 Views
Last Modified: 2016-02-11
I am working in Visual Studio 2008 on a SSIS package. It is really frustrating that I get "Microsoft Visual Studio is Busy" message quite often. It almost happens every time I try to click on other part of the program. So, I cannot edit the porgram


Here is the detail message

Microsoft Visual Studio is busy

Microsoft Visual Studio is waiting for an internal operation to complete. If you regularly encounter this delay during normal usage, please report this problem to Microsoft.


Anyone knows how to fix this issue?
0
Comment
Question by:wasabi3689
  • 6
  • 4
  • 3
13 Comments
 

Author Comment

by:wasabi3689
Comment Utility
here is the error image I attach
VSError.JPG
0
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 286 total points
Comment Utility
Have you got the latest SPs for both SQL Server and VS installed?  If not, that's certainly something to look into:

Microsoft Visual Studio 2008 Service Pack 1 (iso)
Microsoft SQL Server 2008 Service Pack 2
Microsoft® SQL Server® 2008 R2 Service Pack 2 (in case you've got 2008 R2)
0
 
LVL 2

Assisted Solution

by:vivekkumarSharma
vivekkumarSharma earned 214 total points
Comment Utility
I think you sould get your solution from thread link given below:

http://social.msdn.microsoft.com/Forums/en-US/vbide/thread/498447cf-4a67-4e91-b724-579d5b669426
0
 

Author Comment

by:wasabi3689
Comment Utility
how do I know which Microsoft Visual Studio 2008 Service Pack 1 (iso) installed?
0
 
LVL 2

Assisted Solution

by:vivekkumarSharma
vivekkumarSharma earned 214 total points
Comment Utility
If you are talking about SQL server you can find it from following

select @@VERSION
0
 

Author Comment

by:wasabi3689
Comment Utility
Attached image is VS SP, let me know if this is the latest one ?
VSSPimage.JPG
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 286 total points
Comment Utility
VS SP is okay, but you probably need to install the latest SP of SQL Server.  Post the output of the select @@VERSION command if in doubt which one to install.
0
 

Author Comment

by:wasabi3689
Comment Utility
Here it's

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)   Sep 21 2011 22:45:45   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)


I discovered that I can click and edit Data Flow...etc after I open the package and wait a long time. It seems the package is taking a long time loading memory into the studio.
0
 
LVL 2

Assisted Solution

by:vivekkumarSharma
vivekkumarSharma earned 214 total points
Comment Utility
Try to repair/ re-install your SQL Server.

If problem still persist then Issue may be hardware (RAM / cache) specific.
0
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 286 total points
Comment Utility
"I discovered that I can click and edit Data Flow...etc after I open the package and wait a long time. It seems the package is taking a long time loading memory into the studio."

There can be several causes for such behavior.  Some things to consider:

How big is the package? (number of tasks, data flows, connection managers, ...)  The more you've got, the longer it takes to validate it on opening.

Are all data sources operational and accessible?  If not, you'll experience longer delays because SSIS will attempt to connect and waits until timeout.

Maybe the Work Offline functionality is worth trying out in your case.  I believe you need to have a package open to actually get the menu item, but then you can select SSIS > Work Offline.

More good info: Troubleshooting Tools for Package Development
0
 

Author Comment

by:wasabi3689
Comment Utility
I don't see Work Offline functionality . I am using VS 2008. Can you tell me the navigation path for that?

You mentioned "you can select SSIS > Work Offline." I don't find it in VS 2008.
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 286 total points
Comment Utility
You need to have an SSIS project open for the menu item to appear.  Then you should see a main menu item called SSIS and Work Offline is one of the options in that menu item.

If it doesn't appear, try opening a package that belongs to your project.
0
 

Author Comment

by:wasabi3689
Comment Utility
I think the problem is before I choose work offline, the application is already frozen. I mean, after I open the SSIS project, the "...busy" message appeared and I can not even go to another tab.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now