Too many ROS Container

JunaidKhanJunaidKhan Registered User

Hi,

can somebody help in the below error we are getting in, actullay we have done mergeout moveout multiple time but currently there are huge number of transaction we need to be catered and insert in to the table, is any best practices to optimized ROS for table projection,.

java.lang.RuntimeException: process: throws SQLException[Vertica]VJDBC ERROR: Too many ROS containers exist for the following projections:
FAS.TMP_OC_ACTIVE_ALARMS_COUNTERS_b1 (limit = 45664, ROS files = 45656, DV files = 0, new files = 13)
at com.hp.ossa.batch.batchlet.OssaBatchlet.onStepError(OssaBatchlet.java:460)
at com.hp.ossa.batch.batchlet.jdbc.SqlBatchlet.processStep(SqlBatchlet.java:117)
at com.hp.ossa.batch.batchlet.jdbc.SqlCDCBatchlet.processStep(SqlCDCBatchlet.java:247)
at com.hp.ossa.batch.batchlet.OssaBatchlet.process(OssaBatchlet.java:150)
at org.jberet.runtime.runner.BatchletRunner.run(BatchletRunner.java:72)
at org.jberet.runtime.runner.StepExecutionRunner.runBatchletOrChunk(StepExecutionRunner.java:229)
at org.jberet.runtime.runner.StepExecutionRunner.run(StepExecutionRunner.java:147)
at org.jberet.runtime.runner.CompositeExecutionRunner.runStep(CompositeExecutionRunner.java:164)
at org.jberet.runtime.runner.CompositeExecutionRunner.runFromHeadOrRestartPoint(CompositeExecutionRunner.java:88)
at org.jberet.runtime.runner.JobExecutionRunner.run(JobExecutionRunner.java:60)
at org.wildfly.extension.batch.jberet.impl.BatchEnvironmentService$WildFlyBatchEnvironment$1.run(BatchEnvironmentService.java:243)
at org.wildfly.extension.requestcontroller.RequestController$QueuedTask$1.run(RequestController.java:497)
at org.jberet.spi.JobExecutor$3.run(JobExecutor.java:161)
at org.jberet.spi.JobExecutor$1.run(JobExecutor.java:99)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)

also i have found the below link to troubleshoot ROS, how can i increase the ROS limit for specific projections.

Br,

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file