BI Development Studio: Crashes when viewing a Cube in the Browser

Hello, I created an Analysis Services project, defined the views and the cube itself. After I deployed the cube, I wanted to compare the results with the browser.

Everytime I try to open the browser, BIDS starts loading, but after a while it crashes.

Is this a known error?

Thanks in advance!

Are you running Office 2007 on the same machine as BIDS? Is it a beta version of Office 2007?

You have not told us about the sp for SQL Server 2005 or if you run a version of Office 2003 or later on the same machine.

Try downloading SP2 CTP3 (December 2006) from www.microsoft.com/sql and see if it helps.

Regards

Thomas Ivarsson

|||

Yes, I do run Office2003 on my machine, btw it is an Acer5102-notebook. I installed the SP2 CTP3, but the error still occurs.

Any other suggestions, it is really urgent?

Thanks in advance!

|||

I hope by the word "crash" you do not mean that you get a hour glass.

1. Do you run any Firewall? I have seen some issues with Integrity where one would not be able to browse the cube.

2. Did you try browsing the cube from any other application instead of VS? like Excel

3. Also are you trying to go to the Browse tab after the cube is completely deployed. I have some instances where if you try to shift tabs while the cube is being deployed the VS crashes (shuts down completely and launches again)

See, if it is related to any of the aboce behaviors?

|||

I have never had any problem with BIDS and Office2003 since SQL Server 2005 RTM.

Try to install this add in for Excel 2003 and connect to the cube: http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

Have you runned windows update and especially office update lately?

Regards

Thomas Ivarsson

BI Development Studio: Crashes when viewing a Cube in the Browser

Hello, I created an Analysis Services project, defined the views and the cube itself. After I deployed the cube, I wanted to compare the results with the browser.

Everytime I try to open the browser, BIDS starts loading, but after a while it crashes.

Is this a known error?

Thanks in advance!

Are you running Office 2007 on the same machine as BIDS? Is it a beta version of Office 2007?

You have not told us about the sp for SQL Server 2005 or if you run a version of Office 2003 or later on the same machine.

Try downloading SP2 CTP3 (December 2006) from www.microsoft.com/sql and see if it helps.

Regards

Thomas Ivarsson

|||

Yes, I do run Office2003 on my machine, btw it is an Acer5102-notebook. I installed the SP2 CTP3, but the error still occurs.

Any other suggestions, it is really urgent?

Thanks in advance!

|||

I hope by the word "crash" you do not mean that you get a hour glass.

1. Do you run any Firewall? I have seen some issues with Integrity where one would not be able to browse the cube.

2. Did you try browsing the cube from any other application instead of VS? like Excel

3. Also are you trying to go to the Browse tab after the cube is completely deployed. I have some instances where if you try to shift tabs while the cube is being deployed the VS crashes (shuts down completely and launches again)

See, if it is related to any of the aboce behaviors?

|||

I have never had any problem with BIDS and Office2003 since SQL Server 2005 RTM.

Try to install this add in for Excel 2003 and connect to the cube: http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

Have you runned windows update and especially office update lately?

Regards

Thomas Ivarsson

Beware installing SQL Server 2005 BOL (May 2007)

Beware installing this update, it can seriously damage your health. I clicked 'install' on my Vista 64 machine and let it trundle off to itself while I was doing some Visual Studio work. It runs for a while and then ... RESTARTs my PC. Without asking and withoug allowing me to save my work. Fresh, new work, gone. Thanks a bunch guys, installing some new docs really merits a restart.

This event is in the system log:

The process msiexec.exe has initiated the restart of computer BLUE on behalf of user NT AUTHORITY\SYSTEM for the following reason: No title for this reason could be found

Reason Code: 0x80030002

Shutdown Type: restart

Comment: The Windows Installer initiated a system restart to complete or continue the configuration of 'Microsoft SQL Server 2005 Books Online (English) (May 2007)'.

Thanks very much for bringing this issue to our attention. It is sometimes necessary to reboot after a Books Online update - because Books Online, Visual Studio, and SQL Server Management Studio share components - but the expected behavior is a prompt for reboot rather than an automatic reboot. We are actively investigating the issue, and will re-release the update after we identify a solution, so that other customers will not have a similar experience.

|||

Bryan

Thank you far replying to my post -- I am a bit calmer now I have had about four reboots (on various machines) in the last week because of SQL Server patches and I was a bit fractious.

Beware installing SQL Server 2005 BOL (May 2007)

Beware installing this update, it can seriously damage your health. I clicked 'install' on my Vista 64 machine and let it trundle off to itself while I was doing some Visual Studio work. It runs for a while and then ... RESTARTs my PC. Without asking and withoug allowing me to save my work. Fresh, new work, gone. Thanks a bunch guys, installing some new docs really merits a restart.

This event is in the system log:

The process msiexec.exe has initiated the restart of computer BLUE on behalf of user NT AUTHORITY\SYSTEM for the following reason: No title for this reason could be found

Reason Code: 0x80030002

Shutdown Type: restart

Comment: The Windows Installer initiated a system restart to complete or continue the configuration of 'Microsoft SQL Server 2005 Books Online (English) (May 2007)'.

Thanks very much for bringing this issue to our attention. It is sometimes necessary to reboot after a Books Online update - because Books Online, Visual Studio, and SQL Server Management Studio share components - but the expected behavior is a prompt for reboot rather than an automatic reboot. We are actively investigating the issue, and will re-release the update after we identify a solution, so that other customers will not have a similar experience.

|||

Bryan

Thank you far replying to my post -- I am a bit calmer now I have had about four reboots (on various machines) in the last week because of SQL Server patches and I was a bit fractious.