Home » sql server »sqlserverpedia-syndication »SSC »SSRS » Currently Reading:

I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED

September 8, 2011 sql server, sqlserverpedia-syndication, SSC, SSRS 4 Comments

Edit: See end of blog for solution.

I have MS Visual Studio 2008 (BIDS) x86 with SP1.  Recently it’s started shutting down without warning whenever I hit “preview” on a SSRS report. Google hasn’t helped, and I didn’t get much love on #sqlhelp (the Twitter hashtag for SQL help), so I thought I’d ask my adoring public: WTH??

This problem DOES NOT appear to be limited to a particular solution, nor to a particular report. However, I have narrowed it down to only reports that use parameters.

If and when I find a resolution, I’ll post it here for posterity and for all time.

Error from App log:

Event Type: Error
Event Source: .NET Runtime
Event Category: None
Event ID: 1023
Date:  9/8/2011
Time:  10:25:43 AM
User:  N/A
Computer: KKW10006
Description:
.NET Runtime version 2.0.50727.3623 – Fatal Execution Engine Error (7A05ADE0) (80131506)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

A grateful MidnightDBA thanks you,
Jen

Solution: Well, that was fast. I posted this before trying my very-last-ditch effort, which was to uninstall Redgate’s SQL Prompt 5. Sure enough, this was the problem. Here’s a Redgate forum conversation that describes the same behavior. I’ll reinstall and apply the fix mentioned, and update here to let you know if that works.

Resolution: Okay, so the problem itself isn’t fixed. BUT, you can disable the SQL Prompt add-in for BIDS in the Tools menu, and this I have done. So, you know, problem solved.

Currently there are "4 comments" on this Article:

  1. jonmcrawford says:

    excellent! I’ve had that issue for a couple weeks, been doing other things so hadn’t tried to fix it yet. Thanks!

  2. [...] Visual Studio 2008 (BIDS) x86 with SP1 recently started shutting down without warning whenever Jen McCown hit “preview” on a SSRS report. Read on for the [...]

  3. Paul Richmond says:

    I’ve got this problem as well but dissabling, (turning off), SQL Prompt does not appear to resolve it at all. After right clicking the ‘Toolbox’ area and selecting choose items BIDS aborts writing an event 1023 into the event log. Any further information on this?

    Much thanks in advance,

    Paul

  4. James says:

    Superb find, had same problem. Unticked Prompt 5 from the addin then “turned off” Prompt, re started and all is well…

    Cheers, saved me a lot of time!

Comment on this Article:







MidnightSQL Consulting

Need help? Got an emergency? Write us at Support@MidnightDBA.com!

We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.

For more information about MidnightSQL consulting, email us or check out www.MidnightSQL.com. Happy days!

Blog Posts by Category

DBAs@Midnight

How to Eat Pop-tarts
Watch DBAs@Midnight live on Fridays,m 11pm Central time

The best database career advice you’ve never heard!

DBARoadmap.com

The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!

Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)

Become a DBA. Become a BETTER DBA. Use the Roadmap.

Visit www.DBARoadmap.com for info, forums, and more!

Add to Cart View Cart

Cunningham’s Law

"The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."
Relevant: http://xkcd.com/386/