Business Inteligence Studio Not Responding, Search for a Solution or Restart

Question

Post reply

Business Inteligence Studio Not Responding, Search for a Solution or Restart

Welsh Corgi

SSC Guru

Points: 116520
More actions
April 27, 2012 at 5:05 am

#254919

All of a sudden BIDS has gone flaky on a Windows Server 2008 Machine.
At first I thought that it was the size of my SSIS Package but I ruled that out by using another machine.
I was adding task and BIDS Locked up and I had to restart.
BIDS gave me nothing but trouble from that point going forward.
I goggled for a solution but no luck.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

Have you rebooted your machine?

Maybe try a repair using the SQL Server set-up?

Or do a clean re-install?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Koen Verbeeck (4/27/2012)
Have you rebooted your machine?
Maybe try a repair using the SQL Server set-up?
Or do a clean re-install?

I rebooted the machine and I still have the same issue.

I will try a repair but I have to wait for someone to insert the installation media in the machine since it is remote and in a different time zone.

I thought that I posted the error that I got.

I tried the following command to log events:

Devenv.exe /log "C:\SSIS\MyLog.txt"

The application is hanging.

Description:

A problem caused this program to stop interacting with Windows.

Problem signature:

Problem Event Name:AppHangB1

Application Name:devenv.exe

Application Version:9.0.30729.1

Application Timestamp:488f2b50

Hang Signature:5606

Hang Type:268552

OS Version:6.1.7601.2.1.0.256.48

Locale ID:1033

Additional Hang Signature 1:560629a4b20f1e0dd9f242a0389c8a3e

Additional Hang Signature 2:c6e4

Additional Hang Signature 3:c6e482adfc8334d957d706ab72d66725

Additional Hang Signature 4:60f0

Additional Hang Signature 5:60f0636cb7e99feca8246fd22f7b9e27

Additional Hang Signature 6:4509

Additional Hang Signature 7:45095895e897120a44cea2cd1a152987

Read our privacy statement online:

http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:

C:\Windows\system32\en-US\erofflps.txt

Thanks for your help.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

Any add-ins running in Visual Studio?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Koen Verbeeck (4/27/2012)
Any add-ins running in Visual Studio?

I'm not running any. I had checked that for I heard where it has been known to cause issues.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

I have multiple instances of SQL Server.

I'm working on the Default Instance and someone else is working ton the Dev Named Instance.

What is the proper way to repair a SQL Server Installation. I have never done it with 2008 R2 and I'm concerned about it impacting someone else.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

I was able to split the packages up on another server.

Then I created a new solution and I only had an issue with hanging on a few occasion.

It appears that the problem may in part have been related to the solution or project being corrupt.

Whatever the case I'm back in business for now.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/