The provider ran out of memory.
878418Jul 27 2011 — edited May 31 2013I'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