Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Haz
Starting Member
38 Posts |
 Posted - 2008-11-20 : 01:20:04
|
Hi there, I got this error during Preview: Exception of type System.OutOfMemoryException was throw is this error related to the size of database ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-20 : 03:22:56
|
| seems like error in your custom code. can you check you custom code be trying to debug it from visual studio ide? |
 |
|
|
Haz
Starting Member
38 Posts |
Posted - 2008-11-20 : 19:37:10
|
| HiI do debugging but it seem take time so long and make my comp. slow down. I just pull out 9 field in 1 table only and i have around 1,700,000 records.n 1 more thing, need i to config at reporting services config. mananger?Thank you... |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-11-20 : 19:52:02
|
| Sounds like you're running out of memory on the client.(Get v2008)Can you change the query so it returns less data - I'm sure the report doesn't display 700,000 rows (even more so 1,700,000) so do any aggregation in the query rather than the report.I would call an SP to retur the data.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Haz
Starting Member
38 Posts |
Posted - 2008-11-20 : 21:50:08
|
| hi,I try to use 2 parameter but I still get the same error, can i know the limit row,report could display?Thank you...Haz |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-11-21 : 03:19:27
|
| Only by trial an error.Use task manager to see the memory used by the process and you should see it growing untill it runs out and fails.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Haz
Starting Member
38 Posts |
Posted - 2008-11-26 : 21:46:44
|
I have a question..for server pc, what the min size of the RAM they should have?I use 4 parameter to display result only 2 records but still i get the same error.. Anyone can help me... |
|
|
|
|
|
|
Error during Preview