Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

Posts: 9
Joined: Fri Feb 14, 2020 5:53 am


Postby av686165 » Wed May 06, 2020 7:44 pm

Hi ,

I am getting below error while running my graph,
Component [UniversalDataReader:UNIVERSAL_DATA_READER1] finished with status ERROR. (Out0: 0 recs)
Error when parsing record #1 field deal_foreign_ccy
Realocation of CloverBuffer failed. Requested capacity is 33554434 and maximum capacity is 33554432.

Kindly help.

Posts: 147
Joined: Wed May 03, 2017 12:10 pm

Re: BufferOverflowException

Postby bartonv » Thu May 07, 2020 7:58 am

this error message is quite common and is typically caused by one of the following two conditions:

1. An error in the input file
For instance, a record delimiter or field delimiter is missing in the input file or there is one more delimiter than it should be. This can corrupt the parsing of the next fields and records and can result in loading a huge chunk of data into a single field/record, thus causing the buffer overflow error.
2. A valid record or field larger than 32 MB
In this case, it is the actual size of the data being loaded either into a single field or into a single record that exceeds one of the two limits: Record.RECORD_LIMIT_SIZE and Record.FIELD_LIMIT_SIZE.​ Worth noting is that this problem does not have anything to do with the size of the input file of the UniversalDataReader. In other words, it is not the number of records (rows, if you will) that makes the difference here so breaking the files up into smaller ones would not be a remedy to the root cause.

Overall, increasing the limits is, in fact, an adequate solution. Since the limit has been overflown only by a relatively low amount, it should be sufficient to double both limits. In other words, add the following lines into your engine properties and restart CloverDX. More information can be found in our documentation.

Code: Select all

Record.RECORD_LIMIT_SIZE = ‭67108864‬
Record.FIELD_LIMIT_SIZE = 67108864‬

Best regards,
Vladimir Barton
CloverCARE Support

Visit us online at http://www.cloverdx.com