oo schecduler issue
This post is to search for a solution to my OO 10.20 which stops executing some schedules for some time (eg: 30 min, no schedule is executed ) and than it comes back to a normal behaviour after this period.
When this behaviour appears for the last time, i took a look to the monitoring page, and there are many values in red (see attachment).
Thanks in advance.
Can you connect to the OO DB, execute the following query, and share the results
select T.TRIGGER_NAME, T.TRIGGER_STATE, ST.REPEAT_INTERVAL from OO_TRIGGERS T, OO_SIMPLE_TRIGGERS ST where T.JOB_NAME <> 'jobDetail' and T.TRIGGER_NAME = ST.TRIGGER_NAME
If you could also share
# of Centrals, RAS in the environment
DB Size on disk, proc, mem
DB Provider (SQL Server 2012?)
List of indexes and their fragmentation level
Size of tables (number of records in each table)
Here are some information:
auditDataPurgerTrigger WAITING 432000000
deploymentKeepAliveJobTrigger WAITING 300000
l10nDataCleanTrigger WAITING 86400000
oldDeploymentProcessesCleanTrigger WAITING 86400000
onRolling:OO_EXECUTION_EVENTS_Trigger WAITING 43200000
onRolling:OO_EXECUTION_STATES_Trigger WAITING 270000
queueCleanerTrigger WAITING 60000
queueRecoveryTrigger WAITING 120000
recoveryVersionTrigger WAITING 30000
splitJoinTrigger ACQUIRED 1000
We have 1 Central and 2 RAS
DB Size 435 GB SQL SERVER 2012
We execute a purge every 5 days.
No, i did not make any change to the engine jar file.
Also, i have notice that deployments of little contents take a lot lot of time:
2019-05-20 14:12:08,973 [taskExecutor-2] (DeploymentServiceImpl.java:266) INFO - Started async deployment of Deployment Unit
2019-05-20 14:18:45,701 [taskExecutor-2] (DeployedEntityDependenciesMappingServiceImpl.java:77) INFO - Start updating flow dependencies
2019-05-20 14:18:58,225 [taskExecutor-2] (DeployedEntityDependenciesMappingServiceImpl.java:144) INFO - Finish updating flow dependencies
2019-05-20 14:22:49,347 [taskExecutor-2] (DeploymentServiceImpl.java:553) INFO - Delete CP files from Temp Directory
2019-05-20 14:51:46,536 [taskExecutor-2] (DeploymentServiceImpl.java:276) INFO - Ended async deployment of Deployment Unit