0 Replies Latest reply on Nov 20, 2014 8:39 PM by rajeshwaran_g

    Error while adding user to User Group using Jive API

    rajeshwaran_g

      Hi,

      When we tried adding permission group to set of users through a batch run in production environment using the Jive API GroupManager.update, we found that it failed for some users.

      The piece of code we used for adding the permissiongroup is as bellow

      Group permGroup = groupManager.getGroup(groupName);

      permGroup.addMember(jiveUser);

      1. groupManager.update(permGroup);

      We were trying to map for different users(different userid), but it was trying to map only with userid 5703 for all the failed attempts.The jiveUser sent to the update method is for correct user which we have confirmed through our logs.Please find below the stack trace. ERROR com.jivesoftware.base.database.dao.GroupDAOImpl - Error adding members

      • org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO jiveGroupUser (groupID, userID, administrator) VALUES (?, ?, ?)]; ERROR: duplicate key value violates unique constraint "jivegroupuser_pk"

        Detail: Key (groupid, userid, administrator)=(1065, 5703, 0) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "jivegroupuser_pk"

        Detail: Key (groupid, userid, administrator)=(1065, 5703, 0) already exists.

            at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)

            at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

            at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)

            at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:614)

            at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:883)

            at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

            at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.batchUpdate(SimpleJdbcTemplate.java:257)

            at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.batchUpdate(SimpleJdbcTemplate.java:253)

            at com.jivesoftware.base.database.dao.JiveJdbcOperationsTemplate.batchUpdate(JiveJdbcOperationsTemplate.java:66)

            at com.jivesoftware.base.database.dao.GroupDAOImpl.addMembers(GroupDAOImpl.java:181)

            at com.jivesoftware.base.database.DbGroupManager.updateMembers(DbGroupManager.java:376)

            at com.jivesoftware.base.database.DbGroupManager.update(DbGroupManager.java:259)

            at com.infosys.bizp.plugin.hrms.util.HRMSUserManagerUtil.setPermGroups(HRMSUserManagerUtil.java:246)

            at com.infosys.bizp.plugin.hrms.action.HRMSIntegrationHelper.updateProfileFields(HRMSIntegrationHelper.java:960)

            at com.infosys.bizp.plugin.hrms.action.HRMSIntegrationHelper.compareHRMSUserWithJiveUser(HRMSIntegrationHelper.java:1051)

            at com.infosys.bizp.plugin.hrms.action.HRMSIntegrationHelper.readUser(HRMSIntegrationHelper.java:532)

            at com.infosys.bizp.plugin.hrms.action.HRMSIntegrationHelper.readFile(HRMSIntegrationHelper.java:424)

            at com.infosys.bizp.plugin.hrms.action.HRMSIntegrationHelper.readAllFiles(HRMSIntegrationHelper.java:308)

            at com.infosys.bizp.plugin.hrms.action.HRMSIntegrationHelper.startJob(HRMSIntegrationHelper.java:1494)

            at com.infosys.bizp.plugin.hrms.action.HRMSIntegrationAction.execute(HRMSIntegrationAction.java:83)

            at sun.reflect.GeneratedMethodAccessor4132.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:597)

            at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:376)

            at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:239)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:213)

            at com.jivesoftware.community.action.DisableCacheInterceptor.intercept(DisableCacheInterceptor.java:36)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.jivesoftware.community.web.struts.JiveWorkflowInterceptor.doIntercept(JiveWorkflowInterceptor.java:121)

            at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:150)

            at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:129)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.jivesoftware.community.web.struts.JiveConversionErrorInterceptor.intercept(JiveConversionErrorInterceptor.java:34)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:189)

            at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:105)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:83)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:268)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:74)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:127)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:206)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:115)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.jivesoftware.community.web.struts.JivePrepareInterceptor.doIntercept(JivePrepareInterceptor.java:57)

            at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:170)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:123)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.jivesoftware.community.web.struts.ModuleCheckInterceptor.intercept(ModuleCheckInterceptor.java:47)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at com.jivesoftware.community.action.AdminSecurityInterceptor.intercept(AdminSecurityInterceptor.java:99)

            at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

            at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:50)

            at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:504)

            at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:422)

            at com.jivesoftware.community.web.struts.JiveFilterDispatcher.doFilter(JiveFilterDispatcher.java:108)

            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.web.filter.SetResponseCharacterEncodingFilter.doFilter(SetResponseCharacterEncodingFilter.java:63)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.web.filter.RequireXHRFilter.doFilterInternal(RequireXHRFilter.java:40)

            at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)

            at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)

            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:99)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.web.filter.ActivityRequestFilter.doFilter(ActivityRequestFilter.java:100)

            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at org.directwebremoting.servlet.DwrWebContextFilter.doFilter(DwrWebContextFilter.java:91)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.base.plugin.PluginFilter.doFilter(PluginFilter.java:73)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.robots.RobotDetectorFilter.doFilterInternal(RobotDetectorFilter.java:62)

            at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83)

            at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.aaa.UserResponseHeaderFilter.doFilter(UserResponseHeaderFilter.java:45)

            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)

            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:163)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)

            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:163)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:163)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)

            at com.jivesoftware.community.aaa.sso.kerberos.JiveSpnegoAuthenticationProcessingFilter.doFilterHttp(JiveSpnegoAuthenticationProcessingFilter.java:77)

            at com.jivesoftware.community.aaa.sso.kerberos.JiveSpnegoAuthenticationProcessingFilter.doFilter(JiveSpnegoAuthenticationProcessingFilter.java:43)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)

            at org.springframework.security.saml.SAMLLogoutProcessingFilter.processLogout(SAMLLogoutProcessingFilter.java:171)

            at org.springframework.security.saml.SAMLLogoutProcessingFilter.doFilter(SAMLLogoutProcessingFilter.java:94)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at com.jivesoftware.community.aaa.sso.saml.filter.JiveSAMLLogoutFilter.doFilter(JiveSAMLLogoutFilter.java:56)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at com.jivesoftware.community.aaa.sso.saml.filter.JiveSAMLEntryPoint.doFilter(JiveSAMLEntryPoint.java:111)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:163)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)

            at com.jivesoftware.mobile.redirector.RedirectFilter.doFilter(RedirectFilter.java:155)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at com.jivesoftware.community.aaa.stateless.filter.NodeFailoverTestModeFilter.doFilter(NodeFailoverTestModeFilter.java:36)

            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)

            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)

            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.base.profiling.http.RequestProfilingFilter.doFilter(RequestProfilingFilter.java:47)

            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.web.filter.P3PCompactPolicyFilter.doFilter(P3PCompactPolicyFilter.java:48)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.web.filter.RemoveJsessionIdFilter.doFilter(RemoveJsessionIdFilter.java:40)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.web.filter.ApplicationStateFilter.doFilter(ApplicationStateFilter.java:157)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.web.filter.XFrameOptionsFilter.doFilter(XFrameOptionsFilter.java:50)

            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.web.filter.ResourceRoutingFilter.doFilter(ResourceRoutingFilter.java:44)

            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.base.profiling.http.ServerLatencyFilter.doFilter(ServerLatencyFilter.java:62)

            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.web.filter.SetRequestCharacterEncodingFilter.doFilter(SetRequestCharacterEncodingFilter.java:76)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at com.jivesoftware.community.web.filter.DispatchContextResetFilter.doFilter(DispatchContextResetFilter.java:39)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)

            at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:647)

            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

            at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)

            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

            at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)

            at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:600)

            at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1703)

            at java.lang.Thread.run(Thread.java:662)

      Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "jivegroupuser_pk"

        Detail: Key (groupid, userid, administrator)=(1065, 5703, 0) already exists.

            at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)

            at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)

            at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1089)

            at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

            at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)

            at sun.reflect.GeneratedMethodAccessor880.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:597)

            at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)

            at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)

            at org.postgresql.PGStatement$$EnhancerByProxool$$6d8aba29.executeBatch(<generated>)

            at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:898)

            at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1)

            at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)

            ... 211 more

       

       

      Has anyone faced a similar error ?