Visual Studio Crashing on One Report when Previewing
I've got a report I'm trying to work with and every time I try to preview it Visual Studio crashes.
I created the SQL in Management Studio - it's nothing complicated, it doesn't have any parameters or anything. It takes 9 seconds to run.
My colleague has a theory that it's my PC because it's a bit old 4GB RAM, AMD Athlon 64 x2 Dual Core 4200 2.2GHz but I'm not convinced. Sure it sometimes churns away on a long countif but it does do the job (eventually!). I looked at task manager when running
the report, the memory seems to be at around 2.2-2.5 and the CPU gets up to high 80s but only for a brief spike, most of the time its between 40-60%
This is the error I receive:
Problem signature:
Problem Event Name: CLR20r3
Problem Signature 01: devenv.exe
Problem Signature 02: 9.0.30729.1
Problem Signature 03: 488f2b50
Problem Signature 04: System.Drawing
Problem Signature 05: 2.0.0.0
Problem Signature 06: 49cc5f38
Problem Signature 07: 24b
Problem Signature 08: 121
Problem Signature 09: System.ComponentModel.Win32
OS Version: 6.0.6002.2.2.0.256.6
Locale ID: 2057
Additional information about the problem:
LCID: 1033
Read our privacy statement:
http://go.microsoft.com/fwlink/?linkid=50163&clcid=0x0409
I've tried the same report in a different project, and in a new project. I've also tried deleting the .suo file in the project directory. All to no avail. Yeah, I have tired a reboot too!
The report does work fine on my colleagues PC, which incidentally is a newer PC with Win7, i5 processor and 4GB RAM.
Any ideas people?
Thanks in advance :)
January 31st, 2011 6:31am
Happening on another report now. The same error as above, the report has quite a few columns so I guess is fairly hefty from a data perspective - 49 columns, 8,000 rows, 11 seconds to run...
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 7:34am
Hi Rob,
Due to hardware resource limitation, at report design time, you can use small data for test in the BIDS. To do it, add TOP N, for example, TOP 20, sql command in the select clause. You can remove the command if the report is ready to be deployed to
report server.
thanks,
Jerry
February 3rd, 2011 4:21am