.exception of type 'system.outOfMemory'

Question

1.00/5 (1 vote)

See more:

I am running a program in which when I click Save button it through exception as :-

'System.OutOfMemoryException' was thrown

code where it crashes is :-

VB

Dim cmdDeleteData As New SqlCommand("delete from temp_grimage_offline", webCon)
        cmdDeleteData.ExecuteNonQuery()

        Dim bulk_BeeEnn As New SqlBulkCopy(webCon)
        bulk_BeeEnn.BulkCopyTimeout = 0
        bulk_BeeEnn.DestinationTableName = "temp_grimage_offline"

        bulk_BeeEnn.WriteToServer(ds.Tables(0))

        checkingForDataDuplicacy()
        Dim cmd_insert As New SqlCommand("insert into emp.dbo.grimage(grno,grimage,stn,scanneddate,tbb,topay,paid,[to],actualwt,chargedwt,nags,ftl,imageid,dgr,empid,grdate,nags_loose, " +
                                         "freight,hamali,l_c,st_ser,surcharge,vsc,stationary_ch,dd_chrgs,st_entry,total,upload_date) select grno,grimage,stn, " +
                                         "scanneddate,tbb,topay,paid,[to],actualwt,chargedwt,nags,ftl,imageid,dgr,empid, " +
                                         "grdate,nags_loose,freight,hamali,l_c,st_ser,surcharge,vsc,stationary_ch,dd_chrgs,st_entry,total,getdate() " +
                                         "from emp.dbo.temp_grimage_offline", webCon)
        cmd_insert.CommandTimeout = 0

        cmd_insert.ExecuteNonQuery()


        Dim cmd_update As New SqlCommand("update emp.dbo.grimage set flag = '1' where flag = '0' or flag is null", localCon)
        cmd_update.ExecuteNonQuery()
        cmd_update.CommandTimeout = 0

Posted 1-Sep-13 23:46pm

ashwani.pandita

Updated 2-Sep-13 17:56pm

v2

Add a Solution

Comments

Mehdi Gholam 2-Sep-13 5:49am

Check what you are doing in the "Save" button...

Thanks7872 2-Sep-13 6:26am

:-)

ashwani.pandita 2-Sep-13 5:51am

initially I am saving all the data in a data set from local server and then I am transferring data from data set to the main table on the server

Yesudasan Moses 2-Sep-13 5:53am

why u r doing like this,,, ? may be the result of never ending loop ,,,,
are you using any third party controls or extensions in it ???

ashwani.pandita 2-Sep-13 6:15am

Sir, I ran the EXE over a system and it works properly but when I m running the EXE in another system there it throw the exception

Yesudasan Moses 2-Sep-13 6:20am

Thats because u are missing some supporting files or resources there..
BTW, are you using Dotnet for developing your application ??

ashwani.pandita 2-Sep-13 6:31am

Yes sir, I am using dot net platform

Pheonyx 2-Sep-13 6:07am

How are you doing this? Can you use the "improve question" facility to provide a code snippet of what your program is attempting to do?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2013-09-02T09:28:00

Solution 1

Without seeing your code where it crashes and the number of records where the problem occurs, it's pretty much impossible to tell you what you're doing wrong.

But, from the sounds of what you have explained, you are literally running the machine out of RAM if you're trying to load a huge table into memory all at once with a DataSet/DataTable object.

Posted 2-Sep-13 9:28am

Dave Kreskowiak

Comments

ashwani.pandita 2-Sep-13 23:55pm

Sir, The machine where I am running the EXE is having 2 GB DDR3 ram and is brand new machine. Actually sir I am running this EXE on 2 different machines having same configuration. In one machine it runs smoothly but in another it through exception which I mentioned above.

the code where I am getting issue is :-

Dim cmdDeleteData As New SqlCommand("delete from temp_grimage_offline", webCon)
cmdDeleteData.ExecuteNonQuery()

Dim bulk_BeeEnn As New SqlBulkCopy(webCon)
bulk_BeeEnn.BulkCopyTimeout = 0
bulk_BeeEnn.DestinationTableName = "temp_grimage_offline"

bulk_BeeEnn.WriteToServer(ds.Tables(0))

checkingForDataDuplicacy()
Dim cmd_insert As New SqlCommand("insert into emp.dbo.grimage(grno,grimage,stn,scanneddate,tbb,topay,paid,[to],actualwt,chargedwt,nags,ftl,imageid,dgr,empid,grdate,nags_loose, " +
"freight,hamali,l_c,st_ser,surcharge,vsc,stationary_ch,dd_chrgs,st_entry,total,upload_date) select grno,grimage,stn, " +
"scanneddate,tbb,topay,paid,[to],actualwt,chargedwt,nags,ftl,imageid,dgr,empid, " +
"grdate,nags_loose,freight,hamali,l_c,st_ser,surcharge,vsc,stationary_ch,dd_chrgs,st_entry,total,getdate() " +
"from emp.dbo.temp_grimage_offline", webCon)
cmd_insert.CommandTimeout = 0

cmd_insert.ExecuteNonQuery()

Dim cmd_update As New SqlCommand("update emp.dbo.grimage set flag = '1' where flag = '0' or flag is null", localCon)
cmd_update.ExecuteNonQuery()
cmd_update.CommandTimeout = 0