[Building Sakai] We just came out of an 2.5.x to 2.7.1 upgrade and some of our users are getting errors while accessing resources ..

[Kenwrick Chan]

Okay, scratch that request .. answered by own question ... with a quick

update CM_ACADEMIC_SESSION_T set IS_CURRENT=0;

.. back to the holidays...

-Kenwrick

On Tue, Dec 28, 2010 at 4:19 PM, Kenwrick Chan <kchan at hawaii.edu> wrote:

> is this as a result of
>
> -- SAK-12883, SAK-12582 - Allow control over which academic sessions are
> -- considered current; support more than one current academic session
> alter table CM_ACADEMIC_SESSION_T add column IS_CURRENT bit default 0 not null;
>
> -- WARNING: This simply emulates the old runtime behavior. It is strongly
> -- recommended that you decide which terms should be treated as current
> -- and edit this script accordingly!
> update CM_ACADEMIC_SESSION_T set IS_CURRENT=1 where CURDATE() >= START_DATE and CURDATE() <= END_DATE;
>
>
> -kenwrick
>
>
> org.sakaiproject.portal.api.PortalHandlerException: org.springframework.orm.hibernate3.HibernateSystemException: Null value was assigned to a property of primitive type setter of org.sakaiproject.coursemanagement.impl.AcademicSessionCmImpl.current; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.sakaiproject.coursemanagement.impl.AcademicSessionCmImpl.current
>     at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:768)
> caused by: org.springframework.orm.hibernate3.HibernateSystemException: Null value was assigned to a property of primitive type setter of org.sakaiproject.coursemanagement.impl.AcademicSessionCmImpl.current; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.sakaiproject.coursemanagement.impl.AcademicSessionCmImpl.current
>     at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
> caused by: org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.sakaiproject.coursemanagement.impl.AcademicSessionCmImpl.current
>     at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:329)
> caused by: java.lang.IllegalArgumentException
>     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:597)
>     at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:42)
>     at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:329)
>     at org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:232)
>     at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3557)
>     at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133)
>     at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
>     at org.hibernate.loader.Loader.doQuery(Loader.java:729)
>     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>     at org.hibernate.loader.Loader.doList(Loader.java:2217)
>     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108)
>     at org.hibernate.loader.Loader.list(Loader.java:2103)
>     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>     at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:340)
>     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1122)
>     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>     at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:997)
>     at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
>     at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
>     at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:988)
>     at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:980)
>     at org.sakaiproject.coursemanagement.impl.CourseManagementServiceHibernateImpl.getAcademicSessions(CourseManagementServiceHibernateImpl.java:138)
>     at org.sakaiproject.coursemanagement.impl.CourseManagementServiceFederatedImpl.getAcademicSessions(CourseManagementServiceFederatedImpl.java:221)
>     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:597)
>     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
>     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
>     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
>     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
>     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
>     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>     at $Proxy1.getAcademicSessions(null:-1)
>     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:597)
>     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
>     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
>     at $Proxy1.getAcademicSessions(null:-1)
>     at org.sakaiproject.content.providers.cm.CourseManagementSiteContentAdvisor.getDefaultRetractTime(CourseManagementSiteContentAdvisor.java:49)
>     at org.sakaiproject.content.tool.ResourcesAction.initStateAttributes(ResourcesAction.java:7811)
>     at org.sakaiproject.content.tool.ResourcesAction.initState(ResourcesAction.java:7563)
>     at org.sakaiproject.cheftool.VelocityPortletPaneledAction.initState(VelocityPortletPaneledAction.java:274)
>     at org.sakaiproject.cheftool.ToolServlet.prepState(ToolServlet.java:498)
>     at org.sakaiproject.cheftool.ToolServlet.doGet(ToolServlet.java:227)
>     at org.sakaiproject.cheftool.VelocityPortletPaneledAction.doGet(VelocityPortletPaneledAction.java:1025)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
>     at org.sakaiproject.vm.ComponentServlet.service(ComponentServlet.java:56)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:585)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
>     at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
>     at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:359)
>     at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101228/651e3a5d/attachment.html