000012206 - Replication breaks after deleting Authentication Agent entry that has associated Radius Client

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000012206
Applies ToRSA_REP.AM_AGENT_RADIUS_CLIENTS
IssueAlert log errors:
13-03-22 07:19:14 - IMS Trace - Unhandled apply error 22922 occurred in RSA_REP.AM_AGENT
13-03-22 07:19:14 - IMS Trace - Unhandled apply error 22922 occurred in RSA_REP.AM_AGENT_RADIUS_CLIENTS
13-03-22 07:19:14 - IMS Trace - Unhandled apply error 22922 occurred in RSA_REP.AM_HOST
13-03-22 07:19:14 - IMS Trace - Unhandled apply error 22922 occurred in RSA_REP.AM_RADIUS_CLIENTS
13-03-22 07:19:14 - IMS Trace - Unhandled apply error 1460 occurred in RSA_REP.AM_AGENT
13-03-22 07:19:14 - IMS Trace - Unhandled apply error 1460 occurred in RSA_REP.AM_AGENT_RADIUS_CLIENTS

log_primary_info.html shows
the error occurred with remote OOB invocation.
rsautil manage-database -a exec-sql -f diagnostics/IMS_RepLogRpt.sql -A log_replica.html -U com.rsa.replication.admin report:
ORA-12560: TNS:protocol adapter error     The database connection to remote site [<primary>] is disc onnected                or
ORA-12560: TNS:protocol adapter error     The database connection to remote site [<primary>] is disconnected
ORA-12537: TNS:connection closed     The database connection to remote site [<primary>] is disconnected
ORA-01403: no data found on RSA_REP.AM_AGENT     Delete the apply error for RSA_STREAMS_APPLY_1

 
ResolutionDownload from Jira AM-26802, rename to unset-apply-parameter.txt, zip and email to customer, then unzip, rename and Place   unset-apply-parameter.sql   file into RSA_HOME/utils on Primary and all replicas.
 

Run the file as follows: on Primary and Replica instances


rsautil manage-database -a exec-sql -f unset-apply-parameter.sql -U com.rsa.replication.admin
Patch 26 for AM 7.1 SP4 prevents this from happening again, Jira Bug AM-26802.  May need to clean-up and re-attach replica.  Clean-up deletes the queues, so there would not be a need to run the unset-apply-parameter.sql
Legacy Article IDa61176

Attachments

    Outcomes