portal errors

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

portal errors

Jonathan Hart

Seeing some weird portal errors come in… Any ideas how to resolve?!?!

Those values do not exist in that table… Hmmm… Not sure what is going on here.

 

Caused by: org.hibernate.exception.ConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104536, testuser).

       at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at com.sun.proxy.$Proxy198.executeBatch(Unknown Source) ~[na:na]

       at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:161) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:151) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1234) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.action.internal.CollectionRecreateAction.execute(CollectionRecreateAction.java:58) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:279) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1214) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:403) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:75) ~[hibernate-entitymanager-4.1.6.Final.jar:4.1.6.Final]

       at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:513) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       ... 30 common frames omitted

Caused by: java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104536, testuser).

       at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:947) ~[jtds-1.2.4.jar:1.2.4]

       at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) ~[tomcat-jdbc-7.0.29.jar:na]

       at com.sun.proxy.$Proxy197.executeBatch(Unknown Source) ~[na:na]

       at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       ... 49 common frames omitted

INFO  [uPortal-TaskExecutor-1459-purgeEventSessions] o.j.p.e.a.PortalEventProcessingManagerImpl 2016-04-07 15:26:19,851 - Purged 0 event sessions created before 2014-05-26T08:21:49.000-04:00 in 11ms - 0.0000 sessions/second

INFO  [uPortal-TaskExecutor-1459-purgeRawEvents] o.j.p.e.a.PortalEventProcessingManagerImpl 2016-04-07 15:26:54,201 - Purged 0 events created at NaN events/second between 2014-05-27T07:21:48.900-04:00 and 2014-05-27T07:21:48.900-04:00 in 348ms - 0.0000 e/s a NaNx speedup

ERROR [uPortal-TaskExecutor-1459-aggregateRawEvents] o.j.p.e.a.PortalEventProcessingManagerImpl 2016-04-07 15:26:58,130 - aggregateRawEvents failed

org.springframework.dao.DataIntegrityViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104543, testuser).; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104543, testuser).

       at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:106) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:148) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.jasig.portal.events.aggr.PortalRawEventsAggregatorImpl.doAggregateRawEvents(PortalRawEventsAggregatorImpl.java:201) ~[PortalRawEventsAggregatorImpl.class:na]

       at sun.reflect.GeneratedMethodAccessor292.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at com.sun.proxy.$Proxy189.doAggregateRawEvents(Unknown Source) ~[na:na]

       at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl$3.apply(PortalEventProcessingManagerImpl.java:169) ~[PortalEventProcessingManagerImpl$3.class:na]

       at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl$3.apply(PortalEventProcessingManagerImpl.java:166) ~[PortalEventProcessingManagerImpl$3.class:na]

       at org.jasig.portal.concurrency.locking.ClusterLockServiceImpl.doInTryLock(ClusterLockServiceImpl.java:200) ~[ClusterLockServiceImpl.class:na]

       at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl.aggregateRawEvents(PortalEventProcessingManagerImpl.java:164) ~[PortalEventProcessingManagerImpl.class:na]

       at sun.reflect.GeneratedMethodAccessor291.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:64) [spring-context-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.jasig.portal.utils.threading.ThreadNamingRunnable.run(ThreadNamingRunnable.java:41) [ThreadNamingRunnable.class:na]

       at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_67]

       at java.util.concurrent.FutureTask.run(FutureTask.java:262) [na:1.7.0_67]

       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_67]

       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_67]

       at java.lang.Thread.run(Thread.java:745) [na:1.7.0_67]

Caused by: org.hibernate.exception.ConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104543, testuser).

 

Thanks,

 

 

--
You received this message because you are subscribed to the Google Groups "Student Success Plan User Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/ssp-user/.
Reply | Threaded
Open this post in threaded view
|

Re: portal errors

Paul Spaude
I know you said the username/schoolId isn't in the database, but it does look like a duplicate username or student_id issue and I'd eliminate that first. To do that, I'd try to find which table the constraint "EC52B8A214F1071C" is on. Once that table is found, query for "6104536" or "testuser" using ilike/like and a % before and after. If you can't find the exact table, I'd look in "up_user" and "up_person_dir" tables first as the primary culprit for this sort of thing. Once you find "6104536" or "testuser" then the error is valid. Depending on the database, whitespace, carriage return chars and case sensitivity may or may not be included in matching which can cause this problem.

If it is a duplicate and not a whitespace or case sensitivity issue, the error may come from https://issues.jasig.org/browse/SSP-2930 (username changed in ldap), but more likely a person was half-entered into SSP-Platform before the transaction was abandoned for some reason. This should be exceptionally rare as I've not seen this outside of QA testing. To fix this issue, hopefully all you need to do is find the existing record in one of those up_* tables and update the username/school_id where appropriate to match ldap values. That's assuming you aren't trying to associate two person records with the same username or school_id, which shouldn't be done.

If the ldap values match the record in the up_* table or the record truly doesn't exist, then I'd try deleting the record if it exists (not fun due to the relational status) and if that didn't work then increment the uP_person_* sequences manually as that's likely the underlying issue. 

-Paul Spaude


From: "Jonathan Hart" <[hidden email]>
To: [hidden email]
Sent: Thursday, April 7, 2016 12:45:34 PM
Subject: [ssp-user] portal errors

Seeing some weird portal errors come in… Any ideas how to resolve?!?!

Those values do not exist in that table… Hmmm… Not sure what is going on here.

 

Caused by: org.hibernate.exception.ConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104536, testuser).

       at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at com.sun.proxy.$Proxy198.executeBatch(Unknown Source) ~[na:na]

       at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:161) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:151) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1234) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.action.internal.CollectionRecreateAction.execute(CollectionRecreateAction.java:58) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:279) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1214) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:403) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:75) ~[hibernate-entitymanager-4.1.6.Final.jar:4.1.6.Final]

       at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:513) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       ... 30 common frames omitted

Caused by: java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104536, testuser).

       at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:947) ~[jtds-1.2.4.jar:1.2.4]

       at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) ~[tomcat-jdbc-7.0.29.jar:na]

       at com.sun.proxy.$Proxy197.executeBatch(Unknown Source) ~[na:na]

       at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       ... 49 common frames omitted

INFO  [uPortal-TaskExecutor-1459-purgeEventSessions] o.j.p.e.a.PortalEventProcessingManagerImpl 2016-04-07 15:26:19,851 - Purged 0 event sessions created before 2014-05-26T08:21:49.000-04:00 in 11ms - 0.0000 sessions/second

INFO  [uPortal-TaskExecutor-1459-purgeRawEvents] o.j.p.e.a.PortalEventProcessingManagerImpl 2016-04-07 15:26:54,201 - Purged 0 events created at NaN events/second between 2014-05-27T07:21:48.900-04:00 and 2014-05-27T07:21:48.900-04:00 in 348ms - 0.0000 e/s a NaNx speedup

ERROR [uPortal-TaskExecutor-1459-aggregateRawEvents] o.j.p.e.a.PortalEventProcessingManagerImpl 2016-04-07 15:26:58,130 - aggregateRawEvents failed

org.springframework.dao.DataIntegrityViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104543, testuser).; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104543, testuser).

       at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:106) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:148) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.jasig.portal.events.aggr.PortalRawEventsAggregatorImpl.doAggregateRawEvents(PortalRawEventsAggregatorImpl.java:201) ~[PortalRawEventsAggregatorImpl.class:na]

       at sun.reflect.GeneratedMethodAccessor292.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at com.sun.proxy.$Proxy189.doAggregateRawEvents(Unknown Source) ~[na:na]

       at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl$3.apply(PortalEventProcessingManagerImpl.java:169) ~[PortalEventProcessingManagerImpl$3.class:na]

       at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl$3.apply(PortalEventProcessingManagerImpl.java:166) ~[PortalEventProcessingManagerImpl$3.class:na]

       at org.jasig.portal.concurrency.locking.ClusterLockServiceImpl.doInTryLock(ClusterLockServiceImpl.java:200) ~[ClusterLockServiceImpl.class:na]

       at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl.aggregateRawEvents(PortalEventProcessingManagerImpl.java:164) ~[PortalEventProcessingManagerImpl.class:na]

       at sun.reflect.GeneratedMethodAccessor291.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:64) [spring-context-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.jasig.portal.utils.threading.ThreadNamingRunnable.run(ThreadNamingRunnable.java:41) [ThreadNamingRunnable.class:na]

       at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_67]

       at java.util.concurrent.FutureTask.run(FutureTask.java:262) [na:1.7.0_67]

       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_67]

       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_67]

       at java.lang.Thread.run(Thread.java:745) [na:1.7.0_67]

Caused by: org.hibernate.exception.ConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104543, testuser).

 

Thanks,

 

 

--
You received this message because you are subscribed to the Google Groups "Student Success Plan User Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/ssp-user/.

--
You received this message because you are subscribed to the Google Groups "Student Success Plan User Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/ssp-user/.
Reply | Threaded
Open this post in threaded view
|

RE: portal errors

Jonathan Hart

I ended up finding the issue.  It appears that the table: UP_UNIQUE_STR_SEGMENT__UIDS was stuck on a user who no longer works for the institution and after removing the user from the above table, the errors immediately stopped and inserts/updates are successful.

 

Interesting little data booger. :p

 

Thanks,

 

 

From: Paul Spaude [mailto:[hidden email]]
Sent: Thursday, April 07, 2016 5:44 PM
To: Jonathan Hart <[hidden email]>
Cc: [hidden email]
Subject: Re: [ssp-user] portal errors

 

I know you said the username/schoolId isn't in the database, but it does look like a duplicate username or student_id issue and I'd eliminate that first. To do that, I'd try to find which table the constraint "EC52B8A214F1071C" is on. Once that table is found, query for "6104536" or "testuser" using ilike/like and a % before and after. If you can't find the exact table, I'd look in "up_user" and "up_person_dir" tables first as the primary culprit for this sort of thing. Once you find "6104536" or "testuser" then the error is valid. Depending on the database, whitespace, carriage return chars and case sensitivity may or may not be included in matching which can cause this problem.

If it is a duplicate and not a whitespace or case sensitivity issue, the error may come from https://issues.jasig.org/browse/SSP-2930 (username changed in ldap), but more likely a person was half-entered into SSP-Platform before the transaction was abandoned for some reason. This should be exceptionally rare as I've not seen this outside of QA testing. To fix this issue, hopefully all you need to do is find the existing record in one of those up_* tables and update the username/school_id where appropriate to match ldap values. That's assuming you aren't trying to associate two person records with the same username or school_id, which shouldn't be done.

If the ldap values match the record in the up_* table or the record truly doesn't exist, then I'd try deleting the record if it exists (not fun due to the relational status) and if that didn't work then increment the uP_person_* sequences manually as that's likely the underlying issue. 

-Paul Spaude


From: "Jonathan Hart" <[hidden email]>
To: [hidden email]
Sent: Thursday, April 7, 2016 12:45:34 PM
Subject: [ssp-user] portal errors

Seeing some weird portal errors come in… Any ideas how to resolve?!?!

Those values do not exist in that table… Hmmm… Not sure what is going on here.

 

Caused by: org.hibernate.exception.ConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104536, testuser).

       at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at com.sun.proxy.$Proxy198.executeBatch(Unknown Source) ~[na:na]

       at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:161) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:151) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1234) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.action.internal.CollectionRecreateAction.execute(CollectionRecreateAction.java:58) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:279) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1214) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:403) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:75) ~[hibernate-entitymanager-4.1.6.Final.jar:4.1.6.Final]

       at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:513) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       ... 30 common frames omitted

Caused by: java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104536, testuser).

       at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:947) ~[jtds-1.2.4.jar:1.2.4]

       at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) ~[tomcat-jdbc-7.0.29.jar:na]

       at com.sun.proxy.$Proxy197.executeBatch(Unknown Source) ~[na:na]

       at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) ~[hibernate-core-4.1.6.Final.jar:4.1.6.Final]

       ... 49 common frames omitted

INFO  [uPortal-TaskExecutor-1459-purgeEventSessions] o.j.p.e.a.PortalEventProcessingManagerImpl 2016-04-07 15:26:19,851 - Purged 0 event sessions created before 2014-05-26T08:21:49.000-04:00 in 11ms - 0.0000 sessions/second

INFO  [uPortal-TaskExecutor-1459-purgeRawEvents] o.j.p.e.a.PortalEventProcessingManagerImpl 2016-04-07 15:26:54,201 - Purged 0 events created at NaN events/second between 2014-05-27T07:21:48.900-04:00 and 2014-05-27T07:21:48.900-04:00 in 348ms - 0.0000 e/s a NaNx speedup

ERROR [uPortal-TaskExecutor-1459-aggregateRawEvents] o.j.p.e.a.PortalEventProcessingManagerImpl 2016-04-07 15:26:58,130 - aggregateRawEvents failed

org.springframework.dao.DataIntegrityViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104543, testuser).; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104543, testuser).

       at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:106) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517) ~[spring-orm-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:148) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.jasig.portal.events.aggr.PortalRawEventsAggregatorImpl.doAggregateRawEvents(PortalRawEventsAggregatorImpl.java:201) ~[PortalRawEventsAggregatorImpl.class:na]

       at sun.reflect.GeneratedMethodAccessor292.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) ~[spring-tx-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) ~[spring-aop-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at com.sun.proxy.$Proxy189.doAggregateRawEvents(Unknown Source) ~[na:na]

       at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl$3.apply(PortalEventProcessingManagerImpl.java:169) ~[PortalEventProcessingManagerImpl$3.class:na]

       at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl$3.apply(PortalEventProcessingManagerImpl.java:166) ~[PortalEventProcessingManagerImpl$3.class:na]

       at org.jasig.portal.concurrency.locking.ClusterLockServiceImpl.doInTryLock(ClusterLockServiceImpl.java:200) ~[ClusterLockServiceImpl.class:na]

       at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl.aggregateRawEvents(PortalEventProcessingManagerImpl.java:164) ~[PortalEventProcessingManagerImpl.class:na]

       at sun.reflect.GeneratedMethodAccessor291.invoke(Unknown Source) ~[na:na]

       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]

       at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]

       at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:64) [spring-context-3.2.8.RELEASE.jar:3.2.8.RELEASE]

       at org.jasig.portal.utils.threading.ThreadNamingRunnable.run(ThreadNamingRunnable.java:41) [ThreadNamingRunnable.class:na]

       at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_67]

       at java.util.concurrent.FutureTask.run(FutureTask.java:262) [na:1.7.0_67]

       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_67]

       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_67]

       at java.lang.Thread.run(Thread.java:745) [na:1.7.0_67]

Caused by: org.hibernate.exception.ConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__UP_UNIQU__EC52B8A214F1071C'. Cannot insert duplicate key in object 'dbo.UP_UNIQUE_STR_SEGMENT__UIDS'. The duplicate key value is (6104543, testuser).

 

Thanks,

 

 

--
You received this message because you are subscribed to the Google Groups "Student Success Plan User Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/ssp-user/.

 

--
You received this message because you are subscribed to the Google Groups "Student Success Plan User Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/ssp-user/.