1 Reply Latest reply: May 31, 2013 3:57 AM by 1012009 RSS

    The provider ran out of memory.

    878418
      I've got the following error message when running a job even if there is plenty of memory on the server (Windows Server 2008 R2, 64-bit, 32GB RAM, SQL Server 2005, 32-bit):

      +Executed as user: NT AUTHORITY\SYSTEM. The OLE DB provider "OraOLEDB.Oracle" for linked server "SFA" reported an error. The provider ran out of memory. [SQLSTATE 42000] (Error 7399) Cannot execute the query "select * from INCHIDERE_LUNA" against OLE DB provider "OraOLEDB.Oracle" for linked server "SFA". [SQLSTATE 42000] (Error 7320). The step failed.+

      The problem appears every 3-4 days and we restart the SQL server as a workaround.

      Edited by: ionut on Aug 5, 2011 1:33 AM

      Edited by: ionut on Aug 5, 2011 1:33 AM