Contributor.. CharlesVernet Contributor..
Contributor..
266 views

Problem with our central at the expiration time of the flows.

Hello,

We have a problem with our central at the expiration time of the flows. Currently, configurate on 120 minutes, normally this time allow to cancel flows when the value expires. But that is not the case. In fact, at the end of this periode the flows seem to have been canceled because they are no longer visually present on the flows execution page on the central.On the other hand, these flows continue to exist in the database. When this happens, we restart the hpoo services on the RAS where the flows are still available. If after this step the flows are still running in the database we do a "truncate table".

TRUNCATE TABLE OO_FINISHED_BRANCHES;
DELETE FROM OO_SUSPENDED_EXECUTIONS;
TRUNCATE TABLE OO_EXECUTION_QUEUES;
TRUNCATE TABLE OO_EXECUTION_QUEUES_1;
TRUNCATE TABLE OO_EXECUTION_STATES;
TRUNCATE TABLE OO_EXECUTION_STATES_1;
TRUNCATE TABLE OO_EXECUTION_STATES_2;
DELETE FROM OO_EXECUTION_SUMMARY WHERE STATUS NOT IN ('COMPLETED','CANCELED','SYSTEM_FAILURE');
UPDATE OO_TRIGGERS SET TRIGGER_STATE='WAITING' WHERE TRIGGER_NAME='splitJoinTrigger';

This problem becomes recurrent, do you have a solution, please ?

(HPOO version 10.70)


Regards,
Charles

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.