The provider ran out of memory

Discussion created by philco on Mar 21, 2011
Latest reply on Apr 21, 2011 by spilon



We're extracting values from PI to an external system using queries through PI as a linked server. It's working fine but about every two months there's an error. The only solution we have found so far is to restart the SQL service. We're running a SQL Server 2005 SP2 and we're using the PI OLEDB provider on that machine.

Here's the error log. The main issue seems to be a memory leak...


[PROGRESS   - 08:00:25] pid 2620 Build Node 7 'PILOAD_Inventory_B_01'; reported the following:


DM-DBM-0400 UDA driver reported the following on connection STAGE:


UDA-SQL-0115 Inappropriate SQL request.


UDA-SQL-0564 [Microsoft SQL Native Client]Cannot open the table ""piarchive"."picomp"" from OLE DB provider "PIOLEDB" for linked server "PI_eastern_TZ". Unknown provider error. (SQLSTATE=42000, SQLERRORCODE=7306)


UDA-SQL-0564 [Microsoft SQL Native Client]The OLE DB provider "PIOLEDB" for linked server "PI_eastern_TZ" reported an error. The provider ran out of memory. (SQLSTATE=42000, SQLERRORCODE=7399)



DM-DLV-0101 Delivery 'vw_picomp-VALUE': failed on statement "INSERT INTO "dbo"."vw_picomp" ("tag", "time", "value") VALUES ('206-345-SIL-3009-1.WI.MAN', '2011-03-17 09:00:00', 10)".


DM-BLD-0005 The delivery 'vw_picomp-VALUE' failed.


(for details, see Build_PILOAD_Inventory_B_01_0282.log)


[INTERNAL   - 08:00:26] Build Node 7 'PILOAD_Inventory_B_01'; Executing -> Failed



Any ideas or known bugs? I'm not sure if the error is related to SQL server or PI OLEDB.