Article - CS102865

End user can not see assigned learning contents when log in to Precision LMS

Modified: 06-Sep-2012   


Applies To

Precision LMS Local Install all  release

Description

  • End user can not see assigned learning contents when log in to Precision LMS
  • Error message reprots:

java.sql.BatchUpdateException: Duplicate entry '10-58' for key 'PRIMARY'
     at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665)
     at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
     at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:170)
     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
     at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
     at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)
     at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
     at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
     at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
     at $Proxy88.enroll(Unknown Source)
     at com.ptc.fusion.web.pages.components.links.LaunchLinkHelper.enrollUser(LaunchLinkHelper.java:77)
     at WICKET_com.ptc.fusion.web.pages.components.links.LaunchLinkHelper$$FastClassByCGLIB$$fe563736.invoke(<generated>)
     at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
     at org.apache.wicket.proxy.LazyInitProxyFactory$CGLibInterceptor.intercept(LazyInitProxyFactory.java:318)
     at WICKET_com.ptc.fusion.web.pages.components.links.LaunchLinkHelper$$EnhancerByCGLIB$$d83a708.enrollUser(<generated>)
     at com.ptc.fusion.web.pages.learningpath.LearningPathLanguageConfirmation$4.onClick(LearningPathLanguageConfirmation.java:79)
     at org.apache.wicket.ajax.markup.html.AjaxLink$1.onEvent(AjaxLink.java:65)
     at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
     at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
     at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
     at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
     at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
     at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
     at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
     at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
     at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
     at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:201)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
     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 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
     at java.lang.Thread.run(Unknown Source)
 
 
Complete stack:
 
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
     at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:636)
     at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:789)
     at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663)
     at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
     at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
     at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
     at $Proxy88.enroll(Unknown Source)
     at com.ptc.fusion.web.pages.components.links.LaunchLinkHelper.enrollUser(LaunchLinkHelper.java:77)
     at WICKET_com.ptc.fusion.web.pages.components.links.LaunchLinkHelper$$FastClassByCGLIB$$fe563736.invoke(<generated>)
     at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
     at org.apache.wicket.proxy.LazyInitProxyFactory$CGLibInterceptor.intercept(LazyInitProxyFactory.java:318)
     at WICKET_com.ptc.fusion.web.pages.components.links.LaunchLinkHelper$$EnhancerByCGLIB$$d83a708.enrollUser(<generated>)
     at com.ptc.fusion.web.pages.learningpath.LearningPathLanguageConfirmation$4.onClick(LearningPathLanguageConfirmation.java:79)
     at org.apache.wicket.ajax.markup.html.AjaxLink$1.onEvent(AjaxLink.java:65)
     at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
     at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
     at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
     at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
     at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
     at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
     at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
     at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
     at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
 
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:170)
     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
     at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
     at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)
     at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
     at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
     at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
     at $Proxy88.enroll(Unknown Source)
     at com.ptc.fusion.web.pages.components.links.LaunchLinkHelper.enrollUser(LaunchLinkHelper.java:77)
     at WICKET_com.ptc.fusion.web.pages.components.links.LaunchLinkHelper$$FastClassByCGLIB$$fe563736.invoke(<generated>)
     at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
     at org.apache.wicket.proxy.LazyInitProxyFactory$CGLibInterceptor.intercept(LazyInitProxyFactory.java:318)
     at WICKET_com.ptc.fusion.web.pages.components.links.LaunchLinkHelper$$EnhancerByCGLIB$$d83a708.enrollUser(<generated>)
     at com.ptc.fusion.web.pages.learningpath.LearningPathLanguageConfirmation$4.onClick(LearningPathLanguageConfirmation.java:79)
     at org.apache.wicket.ajax.markup.html.AjaxLink$1.onEvent(AjaxLink.java:65)
     at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163)
     at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297)
     at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104)
     at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
     at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239)
     at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316)
     at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418)
     at org.apache.wicket.RequestCycle.request(RequestCycle.java:532)
     at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)

 

This is a printer-friendly version of Article 102865 and may be out of date. For the latest version click CS102865