[Building Sakai] Null value was assigned to a property of primitive type setter of org.sakaiproject.coursemanagement.impl.AcademicSessionCmImpl.current

[will trillich]

Any idea why the 'resources' tool would start bombing out in class
worksites? (2.6.x)

Here's the in-browser error message:

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:337)
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:585)
   at
org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:42)
   at
org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337)
   at
org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200)
   at
org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3566)
   at
org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:129)
   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:2220)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
   at org.hibernate.loader.Loader.list(Loader.java:2099)
   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
   at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
   at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
   at
org.springframework.orm.hibernate3.HibernateTemplate$32.doInHibernate(HibernateTemplate.java:916)
   at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
   at
org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:907)
   at
org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:899)
   at
org.sakaiproject.coursemanagement.impl.CourseManagementServiceHibernateImpl.getAcademicSessions(CourseManagementServiceHibernateImpl.java:138)
   at
org.sakaiproject.coursemanagement.impl.CourseManagementServiceFederatedImpl.getAcademicSessions(CourseManagementServiceFederatedImpl.java:221)
   at sun.reflect.GeneratedMethodAccessor1356.invoke(null:-1)
<snip/>

select title,start_date,end_date,is_current from CM_ACADEMIC_SESSION_T;
+------------+------------+------------+------------+
| title      | start_date | end_date   | is_current |
+------------+------------+------------+------------+
| Spring2007 | 2007-01-01 | 2007-05-30 | NULL       |
| Summer2007 | 2007-06-01 | 2007-08-31 | NULL       |
| Fall2007   | 2007-09-01 | 2007-12-31 | NULL       |
| Spring2008 | 2008-01-01 | 2008-05-30 | NULL       |
| Summer2008 | 2008-02-08 | 2008-08-31 | NULL       |
| Fall2008   | 2008-02-08 | 2008-12-31 | NULL       |
| Spring2009 | 2008-02-08 | 2010-06-30 |           |
| Summer2009 | 2008-02-08 | 2010-06-30 |           |
| Fall2009   | 2008-02-08 | 2010-06-30 |           |
| Spring2010 | 2009-01-01 | 2010-06-30 | NULL       |
| Summer2010 | 2009-01-01 | 2010-06-30 | NULL       |
| Fall2010   | 2009-01-01 | 2010-06-30 | NULL       |
+------------+------------+------------+------------+

Hypothesis: the is_current field (a 'bit') may be the problem...? Setting
the non-null fields to "b'1'" produces the skewed columns as shown above;
settnig them to "b'0'" at least has the columns lining up...

-- 
will trillich
"If you do not change direction, you may end up where you are heading." --
Lao Tzu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090408/7c1d94ee/attachment.html