January 31, 2011 at 4:20 am
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:
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 31, 2011 at 5:31 am
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...
March 8, 2011 at 6:26 am
Did you find out what was causing it to crash?
I was using VS2008 (9.0.30729.4462 QFE) fine up until Friday when I uninstalled SQL Server 2008 and replaced with 2008 R2.
The version of VS doesn't seem to have changed but when I try and preview reports, VS just disappears from my screen (crashes but with no error).
Also, the reports I deploy won't run either (get a message on the report server that says: -
An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the dataset dsData. (rsErrorReadingNextDataRow)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Any thoughts? I'm tearing my hair out!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply