000036914 - RSA Identity Governance & Lifecycle aveksaServer.log repeatedly shows "updateServerAgentUptimeDate: Setting new uptime for server agent 1"

Document created by RSA Customer Support Employee on Nov 16, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036914
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.1, 7.0.2, 7.1.0 HF01.
IssueThe aveksaServer.log file repeatedly shows the following message.

10/24/2018 12:15:44.145 INFO (default task-24) [com.aveksa.afx.server.service.AFXServerAgentServiceProvider] updateServerAgentUptimeDate: Setting new uptime for server agent 1, creating a new record with 2018-10-24 11:15:39.0 - '
prior uptime date: Wed Oct 24 11:13:28 BRST 2018, prior last polled date: Wed Oct 24 11:15:25 BRST 2018, last polled date: 2018-10-24 11:15:39.0, current date: 2018-10-24 11:15:39.0, polling interval 5000
CauseThis message is a symptom of multiple sessions locking table T_AV_AFX_SERVER_AGENT.

RSA Identity Governance & Lifecycle is attempting to update the uptime, but it cannot because the table is locked, but then tries again after four to five minutes.

The cause has been identified as defect ACM-85871 - AFX goes into "not running" and connectors go into "stopped" state due to locks on t_av_afx_server_agent table
ResolutionUpgrade to RSA Identity Governance & Lifecycle version 7.1.0 P03, where defect ACM-85871 has been fixed.
WorkaroundThe locks on table T_AV_AFX_SERVER_AGENT can be released by restarting the AVDB database.

Make sure that there are no other users  using the application.

  1. Login as the oracle user.
  2. Issue the following commands.  

afx stop
acm stop
acm stopdb
acm startdb
acm start
afx start
NotesThis issue is also related to article 000036465 - RSA Identity Governance & Lifecycle Access Fulfillment Express (AFX) server is not running in the UI but afx status says AFX is running