Highlighted
Honored Contributor.
Honored Contributor.
466 views

oo schecduler issue

Hi everyone,

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.

0 Likes
17 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Toward the bottom of the page expand and share a screen shot of the "System Information",  "Jobs" and "Statistics Job - 1 day" sections

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Here are the requested screenshots.

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

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
0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

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)

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Here are some information:

Query result:

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.

Reagrds

 

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Did you make any changes to the engine jar file? 

Expand monitoring/ threads - see any excessive blocking

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

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

 

 

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

When you have an opportunity can you provide the table row counts (all tables) and the index fragmentation report. 

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Please find in attachment  the table row counts  (sheete 1 of Excel document) and the index fragmentation report (sheet 2) of our OO DB.

Thanks 

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Thanks - can you also grab a screenshot of the oo/monitoring page Data Caches section

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Please find in attachment the screenshot of the oo/monitoring page Data Caches section.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.