locked
getting 'STREAM' reported an error. The provider ran out of memory.". RRS feed

  • Question

  • Hi,

    When I am running an SSIS job reading data from SQL Server provider I am getting this message:

         Name: OnError
         Source Name: trddwn
         Source GUID: {C37654DB-88D7-4204-B6EE-255773A5D096}
         Execution GUID: {AED76F8B-13C2-467C-9DED-1F75B8272FE1}
         Message: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "OLE DB provid\
    er 'STREAM' reported an error. The provider ran out of memory.".
    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "OLE DB error \
    trace [OLE/DB Provider 'STREAM' ::GetColumnsInfo returned 0x8007000e:  The provider ran out of memory.].".

    Rebooting the SQL Server machine cleared up the error for 11 hours and then it returned..

    thanks


    oldmandba

    Wednesday, October 23, 2013 7:07 PM

All replies

  • Seems to be issue releated to memory and increase the mem_to_reserve value.

    Check below link if help:

    http://stackoverflow.com/questions/7393027/ssis-out-of-memory-error-again


    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Thursday, October 24, 2013 9:09 AM
  • Hello,

    Is your system 32bit or 64 bit?

    What is max server memory for SQL server ?

    How much total RAM is present on box

    Can you paste output for below query: This query will not work if SQL is  sql server 2005

    select physical_memory_in_use_kb/(1024) as sql_physmem_inuse_mb, 
    locked_page_allocations_kb/(1024) as awe_memory_mb, 
    total_virtual_address_space_kb/(1024) as max_vas_mb,
    virtual_address_space_committed_kb/(1024) as sql_committed_mb,
    memory_utilization_percentage as working_set_percentage, 
    virtual_address_space_available_kb/(1024) as vas_available_mb,
    process_physical_memory_low as is_there_external_pressure, 
    process_virtual_memory_low as is_there_vas_pressure 
    from sys.dm_os_process_memory 
    go 

    Please reply to all my questions

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Olaf HelperMVP Tuesday, November 5, 2013 7:32 PM
    Thursday, October 24, 2013 9:30 AM
  • sql_physmem_inuse_mb awe_memory_mb max_vas_mb sql_committed_mb working_set_percentage vas_available_mb is_there_external_pressure is_there_vas_pressure
    13895 13636 8388607 14337 100 8365134 0 0

    oldmandba

    Thursday, October 24, 2013 6:48 PM
  • sql_physmem_inuse_mb awe_memory_mb max_vas_mb sql_committed_mb working_set_percentage vas_available_mb is_there_external_pressure is_there_vas_pressure
    13895 13636 8388607 14337 100 8365134 0 0

    oldmandba

    I seriously dont like when somebody does not replies completely to my question and then expects to help him.

    Did you not read my post completely ?.Please reply to all my questions from first post

    From query output its sure your SQL server is 64 bit.

    But what is total amount of RAM present on your system.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Friday, October 25, 2013 5:02 AM