dbTalk Databases Forums  

Integration Services PipelineBufferLeak

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Integration Services PipelineBufferLeak in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
steven.burris@gmail.com
 
Posts: n/a

Default Integration Services PipelineBufferLeak - 08-12-2005 , 06:50 AM






I'm running an SSIS package via the "start without debugging" option in
BI Studio. The package brings in about 300,000 rows and calculates
about 30 million rows that it inserts. It's basically creating a table
of running totals based on a set of financial transcations. The
package should take about 2 hours to run on my machine. I'm reciving
PipelineBufferLeak errors in the log (descriptions below). Any ideas on
how to resolve this? Or should I just bump up my MaxErrorCount?

component "Merge Join 1" (1689) leaked a buffer with ID 12922 of type
13 with 0 rows and a reference count of .

component "Sort" (5146) leaked a buffer with ID 12924 of type 11 with 0
rows and a reference count of 1.

component "Script Component 1" (5266) leaked a buffer with ID 12926 of
type 18 with 0 rows and a reference count of 1.

An unidentified component leaked a buffer with ID 13075 of type 11 with
9637 rows and a reference count of 1.


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default RE: Integration Services PipelineBufferLeak - 08-16-2005 , 02:52 AM






Steven you may want to post this up on the web forums @

http://forums.microsoft.com/msdn/def...orumGroupID=19

Allan


"steven.burris (AT) gmail (DOT) com" wrote:

Quote:
I'm running an SSIS package via the "start without debugging" option in
BI Studio. The package brings in about 300,000 rows and calculates
about 30 million rows that it inserts. It's basically creating a table
of running totals based on a set of financial transcations. The
package should take about 2 hours to run on my machine. I'm reciving
PipelineBufferLeak errors in the log (descriptions below). Any ideas on
how to resolve this? Or should I just bump up my MaxErrorCount?

component "Merge Join 1" (1689) leaked a buffer with ID 12922 of type
13 with 0 rows and a reference count of .

component "Sort" (5146) leaked a buffer with ID 12924 of type 11 with 0
rows and a reference count of 1.

component "Script Component 1" (5266) leaked a buffer with ID 12926 of
type 18 with 0 rows and a reference count of 1.

An unidentified component leaked a buffer with ID 13075 of type 11 with
9637 rows and a reference count of 1.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.