AFX Server is in a questionable state after an unexpected database failure in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2020-07-23
Article Number
000044911
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: All
 
Issue
After the Oracle database has had an unexpected failure which was subsequently fixed, the AFX Server process remains running and was never shut down. In RSA Identity Governance & Lifecycle the AFX Server State (AFX > Servers) may show as either Running or Not running

The following error is logged repeatedly to the $AFX_HOME/esb/logs/esb.AFX-INIT.log file:
 
2020-07-24 11:14:21.568 [WARN] com.aveksa.afx.server.component.ResponseTransformerComponent:159 
- Unable to process logging response from ACM (http status 500)

 
Cause
When the database unexpectedly fails, AFX does not shutdown automatically but goes into an inconsistent state.
 
Resolution
Restart AFX, RSA Identity Governance & Lifecycle and the Oracle database. Even if the AFX Server shows as Running, all three applications should be restarted. 

Login as user oracle and execute the following commands:
 
afx stop
acm stop
acm stopdb
acm startdb
acm start
afx start