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

alermanno

Hello!
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);
  ALTER RESOURCE POOL general PLANNEDCONCURRENCY 5;

• 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.
  Alessandra