Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored procedure execution Expand / Collapse
Author
Message
Posted Monday, May 09, 2011 12:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 10, 2013 10:49 PM
Points: 92, Visits: 340
Hi

I am running a stored procedure that have lacs of select command but query is showing this error.
"An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown."

Regards,
Sachin.


Post #1105226
Posted Tuesday, May 10, 2011 3:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 10:03 AM
Points: 1,106, Visits: 1,334
Can you provide some more information. Google has lots of hits for this but it would be helpful to know the full error, what sql version you using, whether it is for a web based app and what the sp is doing.

Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1105963
Posted Tuesday, May 10, 2011 8:48 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 10, 2013 10:49 PM
Points: 92, Visits: 340
Thanx for your reply..

Actually i am using sql server 2008....and using such thing for sp

Regards,
Sachin.
Post #1106185
Posted Tuesday, May 10, 2011 8:52 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 10, 2013 10:49 PM
Points: 92, Visits: 340
sp is using for generating report.....i am simply run my sp in query analyser
during the sp execution such type error comming.

My sp is more complicated and it's taking lot of time...on that period such error is occurring.

Regards,
Sachin.
Post #1106194
Posted Tuesday, May 10, 2011 8:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 10:03 AM
Points: 1,106, Visits: 1,334
kumar.sachu08 (5/10/2011)
Thanx for your reply..

Actually i am using sql server 2008....and using such thing for sp

Regards,
Sachin.


Yes but please provide the FULL error messagae (all the output shown when s p fails).

And give us an idea of what the sp is used for.


Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1106195
Posted Tuesday, May 10, 2011 8:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 10:03 AM
Points: 1,106, Visits: 1,334
kumar.sachu08 (5/10/2011)
sp is using for generating report.....i am simply run my sp in query analyser
during the sp execution such type error comming.

My sp is more complicated and it's taking lot of time...on that period such error is occurring.

Regards,
Sachin.


Please paste the whole error.


Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1106196
Posted Wednesday, April 18, 2012 10:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 9:31 AM
Points: 6, Visits: 70
That is the entire error message. I'm getting it as well:

Query:
Select Non Empty [Measures].[Admissions Actual] on columns,
[Patient].[Patient ID].Members on Rows
From [Gentiva DW]
Where ([Business Unit].[Cost Center].&[0075],[Date].[Calendar].[Year].&[2012])

Entire Messages:
Executing the query ...
Exception of type 'System.OutOfMemoryException' was thrown.

Execution complete


Post #1285779
Posted Wednesday, April 18, 2012 10:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 9:31 AM
Points: 6, Visits: 70
Server has 16 GB of RAM of which 6.64 is used...
It's a 64-bit Windows Server 2008 R2 Enterprise with Intel Xeon CPU X6550 @ 2.00 GHZ (4 Processors)
Post #1285786
Posted Wednesday, April 18, 2012 10:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 10:03 AM
Points: 1,106, Visits: 1,334
how many rows are expected?
how you performed an execution plan?
where are you running this?
can you supply the actaul query?


Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1285792
Posted Wednesday, April 18, 2012 10:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 10:03 AM
Points: 1,106, Visits: 1,334
Jonathon Williams (4/18/2012)
Server has 16 GB of RAM of which 6.64 is used...
It's a 64-bit Windows Server 2008 R2 Enterprise with Intel Xeon CPU X6550 @ 2.00 GHZ (4 Processors)


Are you running the query on the server (ie via rdp) or on a desktop?


Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1285794
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse