Error 11859 : Cannot have more than 200 buffers in a dataset

Posted by mdanwarh on 23-Jun-2017 12:08

Hi,

I am reading a huge xml using SAX parser. I have loaded all the nodes into one temp-table(ttElements ).

After loading all the nodes into a single ttElements table, I loaded them to their corresponding table. (It has more than 200 tables). 

After processing these temp-tables when I create a dataset and add these buffers to the dataset, I am getting the following error.

Cannot have more than 200 buffers in a dataset. (11859) 

Is there any way to increase the number of buffers for dataset ?

Posted by Garry Hall on 23-Jun-2017 12:17

The 200 limit is hardcoded. From looking at the code, it looks a somewhat arbitrary limit, and there is even a comment suggesting future work to allow dynamically increasing it. You could log an enhancement for this, but I don't have a short-term workaround for you.

All Replies

Posted by Garry Hall on 23-Jun-2017 12:17

The 200 limit is hardcoded. From looking at the code, it looks a somewhat arbitrary limit, and there is even a comment suggesting future work to allow dynamically increasing it. You could log an enhancement for this, but I don't have a short-term workaround for you.

Posted by mdanwarh on 24-Jun-2017 08:54

Do you know how to log an enhancement? If yes, Could you please let me know the steps?  

Posted by Roger Blanchard on 24-Jun-2017 09:07
This thread is closed