1 Reply Latest reply: Oct 22, 2013 4:37 AM by Juan Gerardo Cabeza Luque RSS

    OUTPUT BUFFER error

    Paul Madden

      So this is an interesting one I've never seen before. It's not a huge DataFlow (I've made lots bigger). And it ran fine through the 'Join PLS' a couple hours ago.  I did do some tweaking on the DataFlow since then, but I can't imagine anything I did that would have resulted in that big of a difference (855MB over 1MB).

       

      I am going to make a copy of the DataFlow and start back-pedalling. But that's going to take a while. So if anyone is familiar with this, any input would be appreciated in the meantime.

       

      Thanks!

       

       

      - MESSAGES-TRACE_EX-I: log: The property 'Preserve formulas' value is set to 'false' in the Schema (.)

      Dest PLS Lookup - IN_TABLE_OP-0007-I: Input processing complete: rows in=29, rows accepted = 29, rows skipped=0, rows rejected=0 (DF03_Parking_Permits.Parking Permits)

      Dest h_Location Lookup - IN_TABLE_OP-0007-I: Input processing complete: rows in=1,410, rows accepted = 1,410, rows skipped=0, rows rejected=0 (DF03_Parking_Permits.Parking Permits)

      Prep PLS Lookup - TRANSFORM_OP-0018-I: Record counts: input=29 filtered=0 skipped=0 rejected=0 sieved=0 output=29 (DF03_Parking_Permits.Parking Permits)

      Prep h_Location Lookup - TRANSFORM_OP-0018-I: Record counts: input=1,410 filtered=0 skipped=0 rejected=0 sieved=0 output=1,410 (DF03_Parking_Permits.Parking Permits)

      Dest MV Lookup - IN_TABLE_OP-0007-I: Input processing complete: rows in=18,667, rows accepted = 18,667, rows skipped=0, rows rejected=0 (DF03_Parking_Permits.Parking Permits)

      Prep MV Lookup - TRANSFORM_OP-0018-I: Record counts: input=18,667 filtered=0 skipped=0 rejected=0 sieved=0 output=18,667 (DF03_Parking_Permits.Parking Permits)

      Prep PP - TRANSFORM_OP-0018-I: Record counts: input=17,117 filtered=0 skipped=0 rejected=0 sieved=0 output=17,117 (DF03_Parking_Permits.Parking Permits)

      Dest Report - IN_TABLE_OP-0007-I: Input processing complete: rows in=28,075, rows accepted = 28,075, rows skipped=0, rows rejected=0 (DF03_Parking_Permits.Parking Permits)

      Filter Report - FILTER_OP-0018-I: Record counts: input=28,075 skipped=0 rejected=0 (DF03_Parking_Permits.Parking Permits)

      Join PLS - JOINER_OP-0021-F: A thread failed with an unexpected exception. (DF03_Parking_Permits.Parking Permits)

      Join PLS - OUTPUT_BUFFER-0005-A: An output record is too large. The hard limit on output buffer size of 1,048,576 bytes has been exceeded by a request for 855,736,384 bytes. (DF03_Parking_Permits.Parking Permits)

      Join PLS - OPERATOR-0016-F: toolId 36.0, name 'Join PLS' - Exception 'JoinerOpException' occurred in the 'process' function for thread 0. (DF03_Parking_Permits.Parking Permits)

      Join PLS - JOINER_OP-0008-A: Joiner input 0: thread failed with status 4,294,967,295. (DF03_Parking_Permits.Parking Permits)

      Join PLS - OPERATOR-0005-F: toolId 36.0, name 'Join PLS' - the 'process' function failed for thread 0. (DF03_Parking_Permits.Parking Permits)

      Insert ParkingPermit - GEN_ODBC_OP-0014-I: Records counts: in=0 written=0 skipped=0 rejected=0 (DF03_Parking_Permits.Parking Permits)

      Insert Vehicle - GEN_ODBC_OP-0014-I: Records counts: in=0 written=0 skipped=0 rejected=0 (DF03_Parking_Permits.Parking Permits)

      Insert RSM - GEN_ODBC_OP-0014-I: Records counts: in=0 written=0 skipped=0 rejected=0 (DF03_Parking_Permits.Parking Permits)

      Insert ReportAddress - GEN_ODBC_OP-0014-I: Records counts: in=0 written=0 skipped=0 rejected=0 (DF03_Parking_Permits.Parking Permits)

        <status>failed</status>

      </step>

      <statistic>4.675</statistic>

      </task>

      dataflow controller - ETASK-0038-F: Processing has completed abnormally. (DF03_Parking_Permits.controll