[Vertica][VJDBC](5065) ERROR: Too many ROS containers exist for the following projections

I am doing some tests on a datamart whose data is loaded through Pentaho.
Loading is done through inserts with commit every 10.000 rows.
Loading always crashes with this error:
Caused by: java.sql.SQLTransientException: [Vertica]VJDBC ERROR: Too many ROS containers exist for the following projections:
2020/10/07 17:19:30 - dm_esenzioni.SOGGETTO_super (limit = 18432, ROS files = 18432, DV files = 0, new files = 9)
To remedy this error I applied some tips found on the vertica forum,but the problem is still there :

  • i increased the server memory
    -I modified the vertica parameters like this :
    SELECT SET_CONFIG_PARAMETER('MergeOutInterval', 30);
    SELECT SET_CONFIG_PARAMETER('ContainersPerProjectionLimit', 10240);

  • I have recalculated the statistics of all the tables in the datamart
    Vertica is on a single node.
    I use Pentaho5, are there compatibility issues with vertica 10?
    How can I solve the problem?
    if you can, give me some solution.
    Thank you so much for your help.

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.