SecurID® Knowledge Base
Find answers to your questions and identify resolutions for known issues with knowledge base articles written by SecurID experts.
Article Number
000029902
Applies To
RSA Product Set: SecurID
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.1.0 AM 8.1 SP1
Platform: Linux
Platform (Other): null
O/S Version: Suse Linux
Product Name: null
Product Description: null
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.1.0 AM 8.1 SP1
Platform: Linux
Platform (Other): null
O/S Version: Suse Linux
Product Name: null
Product Description: null
Issue
AM8.1 Server contact List AutoRebalance Error, AutomaticRebalance error, Auto Re-balance Error
AM 8.1 Automatic Rebalance of Server contact list fails with Error: There was a problem processing your request.Unexpected error during command com.rsa.authmgr.admin.servermgt.SynchronizeAgentProtocolServerListsCommand execution
AM 8.1 Automatic Rebalance of Server contact list fails with Error: There was a problem processing your request.Unexpected error during command com.rsa.authmgr.admin.servermgt.SynchronizeAgentProtocolServerListsCommand execution
Cause
This is cause by invalid data in the exiting contact list, something wrong with the name or IP address of one of the replicas
Resolution
From the top Security Console menu select Access/Authentication Agents/Authentication Manager Contact List/Manage Existing
Image description
Then from the Drop down Edit. Look at the list of Replicas in the Contact list on the right, if any are spelled wrong, has a missing or incorrect IP address or if the one that was deleted is on the right, move it to the left/Available side or delete it.
make sure that the "NAME" matches the "SERVER NODE" Selected.
- Once the name is corrected, save and then run Automatic Rebalance.
This behavior can also be seen if there is an invalid contact list. To resolve this issue, delete the secondary contact list (One of the replica) and run Automatic Rebalance again to generate a new one.
Image description Then from the Drop down Edit. Look at the list of Replicas in the Contact list on the right, if any are spelled wrong, has a missing or incorrect IP address or if the one that was deleted is on the right, move it to the left/Available side or delete it.
make sure that the "NAME" matches the "SERVER NODE" Selected.
- Once the name is corrected, save and then run Automatic Rebalance.
This behavior can also be seen if there is an invalid contact list. To resolve this issue, delete the secondary contact list (One of the replica) and run Automatic Rebalance again to generate a new one.
Workaround
Flush Cache in the Operations Console or patching may fix this.
Edit each of the Automatic Contact Lists for each of the Primary and Replicas, move all servers out so that only the Server itself is left in the contact list for itself, and Save. Also delete any Non-Automatic Contact lists.
Then try the automatic rebalance after you have edited all Automatic Contact lists
Edit each of the Automatic Contact Lists for each of the Primary and Replicas, move all servers out so that only the Server itself is left in the contact list for itself, and Save. Also delete any Non-Automatic Contact lists.
Then try the automatic rebalance after you have edited all Automatic Contact lists
Notes
Primus KB a50952
When doing an Automatic Rebalance to update the Authentication Manager Contact list, A system Error is generated with the following exception in the System Log:
com.rsa.common.SystemException: com.rsa.common.DuplicateDataException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update, at com.rsa.authmgr.internal.admin.servermgt.impl.m.a(m.java:243), at com.rsa.authmgr.internal.admin.servermgt.impl.m.a(m.java:191), at com.rsa.authmgr.internal.admin.servermgt.impl.m.a(m.java:149), at com.rsa.authmgr.internal.admin.servermgt.impl.m.doSynch(m.java:113), at com.rsa.authmgr.admin.servermgt.SynchronizeAgentProtocolServerListsCommand.performExecute(SynchronizeAgentProtocolServerListsCommand.java:105), at com.rsa.command.LocalTarget.executeCommand(LocalTarget.java:75), at com.rsa.ims.command.LocalTransactionalCommandTarget.access$101(LocalTransactionalCommandTarget.java:45), at com.rsa.ims.command.LocalTransactionalCommandTarget$1.doInTransaction(LocalTransactionalCommandTarget.java:193), at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127), at com.rsa.ims.command.LocalTransactionalCommandTarget.executeCommand(LocalTransactionalCommandTarget.java:186), at com.rsa.command.CommandServerEngine$CommandExecutor.run(CommandServerEngine.java:543), at com.rsa.command.CommandServerEngine$CommandExecutor.run(CommandServerEngine.java:520), at com.rsa.ims.security.spi.SimpleSecurityContextImpl.doAs(SimpleSecurityContextImpl.java:91), at com.rsa.security.SecurityContext.doAs(SecurityContext.java:400), at com.rsa.command.CommandServerEngine.execute(CommandServerEngine.java:307), at com.rsa.command.CommandServerEngine.executeCommand(CommandServerEngine.java:250), at com.rsa.command.CommandServerEngine.executeCommand(CommandServerEngine.java:161), at com.rsa.command.CommandServerBean.executeCommand(CommandServerBean.java:174), at com.rsa.command.CommandServerBean.executeFrameworkManagedTx(CommandServerBean.java:136), at com.rsa.command.CommandServer_qt4u4w_EOImpl.executeFrameworkManagedTx(CommandServer_qt4u4w_EOImpl.java:62), at com.rsa.command.EJBRemoteTargetBase$CommandExecutor.run(EJBRemoteTargetBase.java:219), at com.rsa.command.EJBRemoteTargetBase$CommandExecutor.run(EJBRemoteTargetBase.java:168), at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363), at weblogic.security.service.SecurityManager.runAs(Unknown Source), at weblogic.security.Security.runAs(Security.java:61), at com.rsa.command.WebLogicSecurityContextWrapper.runAs(WebLogicSecurityContextWrapper.java:52), at com.rsa.command.EJBRemoteTargetBase.executeCommand(EJBRemoteTargetBase.java:144), at com.rsa.command.TargetableCommand.execute(TargetableCommand.java:237), at com.rsa.authmgr.admin.servermgt.SynchronizeAgentProtocolServerListsCommand.execute(SynchronizeAgentProtocolServerListsCommand.java:90), at com.rsa.ims.management.console.util.CommandUtil.executeCommand(CommandUtil.java:161), at com.rsa.authmgr.web.console.action.handler.ContactListHandler.rebalanceContactLists(ContactListHandler.java:412), at com.rsa.authmgr.web.console.action.ContactListAction.nvRebalance(ContactListAction.java:558), at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method), at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25), at java.lang.reflect.Method.invoke(Method.java:585), at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:266), at com.rsa.ui.common.struts.action.RSABaseDispatchAction.execute(RSABaseDispatchAction.java:180), at org.apache.struts.action.RequestProcessor.processActionPerform(Requ.estProcessor.java:413), at com.rsa.ui.common.util.RSAWebRequestProcessor.process(RSAWebRequestProcessor.java:182), at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1858), at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:459), at javax.servlet.http.HttpServlet.service(HttpServlet.java:727), at javax.servlet.http.HttpServlet.service(HttpServlet.java:820), at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226), at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124), at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283), at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.ims.management.console.security.filter.RSAConsoleSignOnFilter$1.run(RSAConsoleSignOnFilter.java:145), at com.rsa.ims.security.spi.SimpleSecurityContextImpl.doAs(SimpleSecurityContextImpl.java:91), at com.rsa.security.SecurityContext.doAs(SecurityContext.java:400), at com.rsa.ims.management.console.security.filter.RSAConsoleSignOnFilter.doFilter(RSAConsoleSignOnFilter.java:141), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.ui.common.filter.UrlValidationFilter.doFilter(UrlValidationFilter.java:133), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.ims.sso.filter.SSOFilter.doFilter(SSOFilter.java:373), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.ui.common.filter.I18NFilter.doFilter(I18NFilter.java:96), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.authmgr.web.console.mmc.MMCNtlmHttpFilter.doFilter(MMCNtlmHttpFilter.java:321), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.ui.common.security.csrf.CSRFFilter.doFilterInternal(CSRFFilter.java:174), at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3368), at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321), at weblogic.security.service.SecurityManager.runAs(Unknown Source), at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2117), at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2023), at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1359), at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200), at weblogic.work.ExecuteThread.run(ExecuteThread.java:172),Caused by: com.rsa.common.DuplicateDataException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update, at com.rsa.authmgr.internal.admin.common.dal.sql.DataObjectAccessSql.add(DataObjectAccessSql.java:202), at com.rsa.authmgr.internal.admin.servermgt.impl.c.add(c.java:112), at com.rsa.authmgr.internal.admin.servermgt.impl.m.a(m.java:239), ... 74 more
When doing an Automatic Rebalance to update the Authentication Manager Contact list, A system Error is generated with the following exception in the System Log:
com.rsa.common.SystemException: com.rsa.common.DuplicateDataException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update, at com.rsa.authmgr.internal.admin.servermgt.impl.m.a(m.java:243), at com.rsa.authmgr.internal.admin.servermgt.impl.m.a(m.java:191), at com.rsa.authmgr.internal.admin.servermgt.impl.m.a(m.java:149), at com.rsa.authmgr.internal.admin.servermgt.impl.m.doSynch(m.java:113), at com.rsa.authmgr.admin.servermgt.SynchronizeAgentProtocolServerListsCommand.performExecute(SynchronizeAgentProtocolServerListsCommand.java:105), at com.rsa.command.LocalTarget.executeCommand(LocalTarget.java:75), at com.rsa.ims.command.LocalTransactionalCommandTarget.access$101(LocalTransactionalCommandTarget.java:45), at com.rsa.ims.command.LocalTransactionalCommandTarget$1.doInTransaction(LocalTransactionalCommandTarget.java:193), at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127), at com.rsa.ims.command.LocalTransactionalCommandTarget.executeCommand(LocalTransactionalCommandTarget.java:186), at com.rsa.command.CommandServerEngine$CommandExecutor.run(CommandServerEngine.java:543), at com.rsa.command.CommandServerEngine$CommandExecutor.run(CommandServerEngine.java:520), at com.rsa.ims.security.spi.SimpleSecurityContextImpl.doAs(SimpleSecurityContextImpl.java:91), at com.rsa.security.SecurityContext.doAs(SecurityContext.java:400), at com.rsa.command.CommandServerEngine.execute(CommandServerEngine.java:307), at com.rsa.command.CommandServerEngine.executeCommand(CommandServerEngine.java:250), at com.rsa.command.CommandServerEngine.executeCommand(CommandServerEngine.java:161), at com.rsa.command.CommandServerBean.executeCommand(CommandServerBean.java:174), at com.rsa.command.CommandServerBean.executeFrameworkManagedTx(CommandServerBean.java:136), at com.rsa.command.CommandServer_qt4u4w_EOImpl.executeFrameworkManagedTx(CommandServer_qt4u4w_EOImpl.java:62), at com.rsa.command.EJBRemoteTargetBase$CommandExecutor.run(EJBRemoteTargetBase.java:219), at com.rsa.command.EJBRemoteTargetBase$CommandExecutor.run(EJBRemoteTargetBase.java:168), at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363), at weblogic.security.service.SecurityManager.runAs(Unknown Source), at weblogic.security.Security.runAs(Security.java:61), at com.rsa.command.WebLogicSecurityContextWrapper.runAs(WebLogicSecurityContextWrapper.java:52), at com.rsa.command.EJBRemoteTargetBase.executeCommand(EJBRemoteTargetBase.java:144), at com.rsa.command.TargetableCommand.execute(TargetableCommand.java:237), at com.rsa.authmgr.admin.servermgt.SynchronizeAgentProtocolServerListsCommand.execute(SynchronizeAgentProtocolServerListsCommand.java:90), at com.rsa.ims.management.console.util.CommandUtil.executeCommand(CommandUtil.java:161), at com.rsa.authmgr.web.console.action.handler.ContactListHandler.rebalanceContactLists(ContactListHandler.java:412), at com.rsa.authmgr.web.console.action.ContactListAction.nvRebalance(ContactListAction.java:558), at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method), at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39), at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25), at java.lang.reflect.Method.invoke(Method.java:585), at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:266), at com.rsa.ui.common.struts.action.RSABaseDispatchAction.execute(RSABaseDispatchAction.java:180), at org.apache.struts.action.RequestProcessor.processActionPerform(Requ.estProcessor.java:413), at com.rsa.ui.common.util.RSAWebRequestProcessor.process(RSAWebRequestProcessor.java:182), at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1858), at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:459), at javax.servlet.http.HttpServlet.service(HttpServlet.java:727), at javax.servlet.http.HttpServlet.service(HttpServlet.java:820), at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226), at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124), at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283), at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.ims.management.console.security.filter.RSAConsoleSignOnFilter$1.run(RSAConsoleSignOnFilter.java:145), at com.rsa.ims.security.spi.SimpleSecurityContextImpl.doAs(SimpleSecurityContextImpl.java:91), at com.rsa.security.SecurityContext.doAs(SecurityContext.java:400), at com.rsa.ims.management.console.security.filter.RSAConsoleSignOnFilter.doFilter(RSAConsoleSignOnFilter.java:141), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.ui.common.filter.UrlValidationFilter.doFilter(UrlValidationFilter.java:133), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.ims.sso.filter.SSOFilter.doFilter(SSOFilter.java:373), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.ui.common.filter.I18NFilter.doFilter(I18NFilter.java:96), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.authmgr.web.console.mmc.MMCNtlmHttpFilter.doFilter(MMCNtlmHttpFilter.java:321), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at com.rsa.ui.common.security.csrf.CSRFFilter.doFilterInternal(CSRFFilter.java:174), at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75), at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42), at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3368), at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321), at weblogic.security.service.SecurityManager.runAs(Unknown Source), at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2117), at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2023), at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1359), at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200), at weblogic.work.ExecuteThread.run(ExecuteThread.java:172),Caused by: com.rsa.common.DuplicateDataException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update, at com.rsa.authmgr.internal.admin.common.dal.sql.DataObjectAccessSql.add(DataObjectAccessSql.java:202), at com.rsa.authmgr.internal.admin.servermgt.impl.c.add(c.java:112), at com.rsa.authmgr.internal.admin.servermgt.impl.m.a(m.java:239), ... 74 more
In this article
