[Building Sakai] Roster tool after sql upgrade to 2.8 (insert to PROFILE_PREFERENCES_T)

[Omer Piperdi]

After running 2.8 upgrade script on Oracle database, I am getting

"ORA-01400: cannot insert NULL into 
("SAKAI"."PROFILE_PREFERENCES_T"."TWITTER_ENABLED") error, when I click 
Roster tool.

Below is the log with hibernate sql debug on.. Any idea or suggestion?

Thanks
Omer


---------------
Hibernate: insert into PROFILE_PRIVACY_T (PROFILE_IMAGE, BASIC_INFO, 
CONTACT_INFO, BUSINESS_INFO, PERSONAL_INFO, BIRTH_YEAR, MY_FRIENDS, 
MY_STATUS, MY_PICTURES, MESSAGES, STAFF_INFO, STUDENT_INFO, 
SOCIAL_NETWORKING_INFO, MY_KUDOS, USER_UUID) values (?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PROFILE_PREFERENCES_T (EMAIL_REQUEST, 
EMAIL_CONFIRM, EMAIL_MESSAGE_NEW, EMAIL_MESSAGE_REPLY, 
USE_OFFICIAL_IMAGE, SHOW_KUDOS, SHOW_GALLERY_FEED, USER_UUID) values (?, 
?, ?, ?, ?, ?, ?, ?)
2011-07-19 16:47:55,099  WARN http-8443-Processor15 
org.hibernate.util.JDBCExceptionReporter - SQL Error: 1400, SQLState: 23000
2011-07-19 16:47:55,099 ERROR http-8443-Processor15 
org.hibernate.util.JDBCExceptionReporter - ORA-01400: cannot insert NULL 
into ("SAKAI"."PROFILE_PREFERENCES_T"."TWITTER_ENABLED")

2011-07-19 16:47:55,099  WARN http-8443-Processor15 
org.hibernate.util.JDBCExceptionReporter - SQL Error: 1400, SQLState: 23000
2011-07-19 16:47:55,099 ERROR http-8443-Processor15 
org.hibernate.util.JDBCExceptionReporter - ORA-01400: cannot insert NULL 
into ("SAKAI"."PROFILE_PREFERENCES_T"."TWITTER_ENABLED")

2011-07-19 16:47:55,101 ERROR http-8443-Processor15 
org.hibernate.event.def.AbstractFlushingEventListener - Could not 
synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute 
JDBC batch update
         at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
         at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
         at 
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254)
         at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
         at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
         at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
         at 
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
         at 
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:970)
         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1115)
         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
         at 
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
         at 
org.sakaiproject.profile2.dao.impl.ProfileDaoImpl$16.doInHibernate(ProfileDaoImpl.java:448)
         at 
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
         at 
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
         at 
org.sakaiproject.profile2.dao.impl.ProfileDaoImpl.getPrivacyRecord(ProfileDaoImpl.java:452)
         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)