The Replica Server has been successfully deployed and attached to the primary instance. However, when navigating to the contact list, the new Replica server does not have a checkmark next to it.
Image descriptionWhen doing an automatic rebalance of the contact list, an error message is received. Therefore, the sdconf.rec file is not updated and fails to add the new replica entry
Image descriptionIn /opt/rsa/am/server/logs/imsTrace.log reports the following:2021-03-29 10:26:55,541, [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'], (DataObjectAccessSql.java:212), trace.com.rsa.authmgr.internal.admin.common.dal.sql.DataObjectAccessSql,
ERROR, parsa1.ascap.com,,,,failed to add domain object AM_AGENT_PROTOCOL_SERVER_LISTorg.springframework.dao.DataIntegrityViolationException:
Could not execute JDBC batch update; SQL [insert into AM_AGENT_PROTOCOL_SERVER_LIST (LAST_UPDATED_BY, NOTES, LAST_UPDATED_ON, TIME_STAMP, INSTANCE_ID, ROW_VERSION, NAME, ID) values (?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:375)
at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:882)
at com.rsa.authmgr.internal.admin.common.dal.sql.DataObjectAccessSql.add(DataObjectAccessSql.java:209)
at com.rsa.authmgr.internal.admin.servermgt.impl.ServerListAdministrationImpl.add(ServerListAdministrationImpl.java:24)
at com.rsa.authmgr.internal.admin.servermgt.impl.ServerListSynchronizerImpl.a(ServerListSynchronizerImpl.java:243)
at com.rsa.authmgr.internal.admin.servermgt.impl.ServerListSynchronizerImpl.a(ServerListSynchronizerImpl.java:198)
at com.rsa.authmgr.internal.admin.servermgt.impl.ServerListSynchronizerImpl.synchronizeAutomaticLists(ServerListSynchronizerImpl.java:166)
at com.rsa.authmgr.internal.admin.servermgt.impl.ServerListSynchronizerImpl.doSynch(ServerListSynchronizerImpl.java:274)
at com.rsa.authmgr.internal.admin.servermgt.impl.ServerListSynchronizationRefresher.refresh(ServerListSynchronizationRefresher.java:10)
at com.rsa.ims.common.AbstractPeriodicRefresher$1.run(AbstractPeriodicRefresher.java:98)
at com.rsa.ims.security.spi.SimpleSecurityContextImpl.doAs(SimpleSecurityContextImpl.java:80)
at com.rsa.security.SecurityContext.doAs(SecurityContext.java:412)
at com.rsa.security.SecurityContext.doAsSystem(SecurityContext.java:454)
at com.rsa.ims.common.AbstractPeriodicRefresher.onTimer(AbstractPeriodicRefresher.java:96)
at com.rsa.ims.common.timer.CommonJTimerServiceImpl$CommonJTimerInfo.doInTransaction(CommonJTimerServiceImpl.java:342)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
at com.rsa.ims.common.timer.CommonJTimerServiceImpl$CommonJTimerInfo.timerExpired(CommonJTimerServiceImpl.java:319)
at weblogic.timers.internal.commonj.ListenerWrap.timerExpired(ListenerWrap.java:37)
at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:304)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:553)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateTemplate$28.doInHibernate(HibernateTemplate.java:884)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:407)
... 22 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into AM_AGENT_PROTOCOL_SERVER_LIST (LAST_UPDATED_BY, NOTES, LAST_UPDATED_ON, TIME_STAMP, INSTANCE_ID, ROW_VERSION, NAME, ID) values ('<system>', 'Automatic server list for instance: PAXRSA1.ascap.com', '2021-03-29 14:26:55.537000 -04:00:00', '2021-03-29 10:26:55.537000 -04:00:00', '06d1a1b76006a10a449ff1d31453a714', '0', 'PAXRSA1.ascap.com', 'cf5705346403050a7879167b950ad18d') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:216)
at com.rsa.ims.instrumentation.monitor.InstrumentedStatementProxy.executeBatch(InstrumentedStatementProxy.java:141)
at com.rsa.ims.common.database.SavePointStatementProxy.executeBatch(SavePointStatementProxy.java:158)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
... 29 more
In /opt/rsa/am/rsapgdata/pg_log/postgress_mm_dd.log2021-03-29 10:26:55.531 GMT [unknown] rsa_user 60619b60.4a5a 6/13375696 32386429 DETAIL:
Key (name)=(PAXRSA1.ascap.com) already exists.2021-03-29 10:26:55.531 GMT [unknown] rsa_user 60619b60.4a5a 6/13375696 32386429 STATEMENT:
insert into AM_AGENT_PROTOCOL_SERVER_LIST (LAST_UPDATED_BY, NOTES, LAST_UPDATED_ON, TIME_STAMP, INSTANCE_ID, ROW_VERSION, NAME, ID) values ($1, $2, $3, $4, $5, $6, $7, $8)2021-03-29 10:29:55.532 GMT [unknown] rsa_user 6061a987.4dcb 2/13215320 32386487 ERROR:
duplicate key value violates unique constraint "uk_am_aps_list_name"
The automatic rebalance fails due to duplicate keys in the RSA Authentication Manager database.