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.
excellent! I’ve had that issue for a couple weeks, been doing other things so hadn’t tried to fix it yet. Thanks!
Pingback: Log Buffer #237, A Carnival of the Vanities for DBAs | The Pythian Blog
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
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!
It is in point of fact a great and useful piece of info. I’m glad that you shared this useful information with us. Please stay us up to date like this. Thanks for sharing.