Not enough storage is available to complete this operation.

Last post 05-09-2008 5:17 AM by dharnendra. 7 replies.

Sort Posts:

  • Not enough storage is available to complete this operation.

    05-09-2008, 2:26 AM

    Not enough storage is available to complete this operation. (Exception from HRESULT: 0x8007000E (E_OUTOFMEMORY))

    how i can overcome this error

  • Re: Not enough storage is available to complete this operation.

    05-09-2008, 2:50 AM
    • Loading...
    • Svante
    • Joined on 02-12-2007, 12:15 PM
    • Stockholm, Sweden
    • Posts 1,548
    • Moderator

    lakshmikanth_k:
    how i can overcome this error

    Do something differently?

    Honestly, you can start by letting us know under which circumstances you get this error, what you're trying to do and when this happens.

     

     

    Svante
    AxCrypt - Free Open Source File Encryption & Online Password Manager - http://www.axantum.com
    [Disclaimer: Code snippets usually uncompiled, beware typos.]
    ______
    Don't forget to click "Mark as Answer" on the post(s) that helped you.
  • Re: Not enough storage is available to complete this operation.

    05-09-2008, 2:54 AM

    I am doing excel file uploading.

    program will read data from excel and insert into databse. once the reading reaches to 400+ row it interupts this message is displaying..

    am taking all excel data into dataset and validating and insert into database

  • Re: Not enough storage is available to complete this operation.

    05-09-2008, 2:59 AM
    • Loading...
    • Svante
    • Joined on 02-12-2007, 12:15 PM
    • Stockholm, Sweden
    • Posts 1,548
    • Moderator

    lakshmikanth_k:
    excel file uploading

    How large is the file?

    Svante
    AxCrypt - Free Open Source File Encryption & Online Password Manager - http://www.axantum.com
    [Disclaimer: Code snippets usually uncompiled, beware typos.]
    ______
    Don't forget to click "Mark as Answer" on the post(s) that helped you.
  • Re: Not enough storage is available to complete this operation.

    05-09-2008, 3:30 AM

    it was a 600Kb file and 30 columns and 600 rows

  • Re: Not enough storage is available to complete this operation.

    05-09-2008, 3:33 AM
    • Loading...
    • Svante
    • Joined on 02-12-2007, 12:15 PM
    • Stockholm, Sweden
    • Posts 1,548
    • Moderator

    lakshmikanth_k:
    it was a 600Kb file and 30 columns and 600 rows

    That should be ok. Could you perhaps include a bit of the code where you iterate through the file, specifically the part where it blows up?

    Svante
    AxCrypt - Free Open Source File Encryption & Online Password Manager - http://www.axantum.com
    [Disclaimer: Code snippets usually uncompiled, beware typos.]
    ______
    Don't forget to click "Mark as Answer" on the post(s) that helped you.
  • Re: Not enough storage is available to complete this operation.

    05-09-2008, 3:45 AM
    • Loading...
    • satalaj
    • Joined on 11-28-2007, 5:41 AM
    • Pune
    • Posts 502

    I google your error I found

    http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/w2000Msgs/3715.mspx?mfr=true

    Can you post the snippet of code

    Satalaj

  • Re: Not enough storage is available to complete this operation.

    05-09-2008, 5:17 AM
    According to this error, you may be running out of
    virtual memory though I
    don't know how this option is set on your server. You can use Performance
    Monitor to determine what resources are being used. For more information on
    how to set Max Server Memory option affecting MSSearch, you can refer to
    Microsoft SQL Server Books Online with the keyword 'Server Memory Options'
    as the search topic.

    If you have installed and are running the Full-Text Search support, then
    you must set the max server memory option manually to leave enough memory
    for the MSSearch service to run. Ideally, you want to allocate as much
    memory as possible to SQL Server without causing the system to swap pages
    to disk. As you increase the amount of SQL Server memory, ensure that there
    is sufficient disk space to grow the operating system's virtual memory
    support file (Pagefile.sys) to accommodate additional memory. For
    information about the virtual memory support file, see your Windows NT
    documentation. The amount of memory specified must be sufficient for the
    SQL Server static memory needs (kernel overhead, open objects, locks, and
    so on), as well as for the data cache (also called buffer cache). Use
    statistics from Windows NT Performance Monitor to help you adjust the
    memory value if necessary. Change this value only when you add or remove
    memory, or when you change how you use your system.

    Please download the Component Checker under
    http://www.microsoft.com/data
    to check MDAC version. You can apply the latest MDAC version on your server
    and try again.
    Shah Dharnendra G
    Analyst Programmer,
    GTL-Ahmedabad
Page 1 of 1 (8 items)