Escalation Workflows randomly fail to trigger in RSA Identity Governance & Lifecycle

[#1]

Article Number

000039116

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: All
 

Issue

Escalation workflows randomly fail to trigger in RSA Identity Governance & Lifecycle.

The following error is logged to the WorkPoint.log file:
 

2020-04-27 15:11:21,730 [pool-16-thread-1] INFO com.workpoint.server.ServerProperties - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis.jdbc/avdb, value=-22136
2020-04-27 15:11:21,730 [pool-16-thread-1] WARN com.workpoint.server.ConnectContext - The time difference between the database server for DSN= jdbc/avdb and this machine has changed by 44270ms since last computed. This may be a sign of clock drift on one of the machines, which can lead to unexpected results in Workpoint.

Please refer to RSA Knowledge Base Article 00003027 -- Artifacts to gather in RSA Identity Governance & Lifecycle  to find the location of the WorkPoint.log file for your specific deployment.The WorkPoint.log may also be downloaded from the RSA Identity Governance & Lifecycle user interface (Admin > System > Server Nodes tab > under Logs.)
 

Cause

The RSA Identity Governance & Lifecycle application server and remote Oracle database server times are greater than one minute apart.
 

Resolution

See RSA Knowledge Base Article 000039121 -- Access Requests and Workflows rely on the Application Server and Database Server times to be in synch in RSA Identity Governance & Lifecycle for a resolution to this issue.