Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored...


Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored procedure execution

Author
Message
dsachu
dsachu
SSC Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 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.
Schadenfreude-Mei
Schadenfreude-Mei
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1135 Visits: 1336
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
dsachu
dsachu
SSC Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 Visits: 340
Thanx for your reply..

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

Regards,
Sachin.
dsachu
dsachu
SSC Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 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.
Schadenfreude-Mei
Schadenfreude-Mei
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1135 Visits: 1336
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
Schadenfreude-Mei
Schadenfreude-Mei
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1135 Visits: 1336
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
Jonathon Williams
Jonathon Williams
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 76
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
Jonathon Williams
Jonathon Williams
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 76
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)
Schadenfreude-Mei
Schadenfreude-Mei
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1135 Visits: 1336
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
Schadenfreude-Mei
Schadenfreude-Mei
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1135 Visits: 1336
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search