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

[Steve Swinsburg]

Hi Omer,

Did you have Profile2 installed before the 2.8 upgrade? It looks like you missed a conversion script:

/* remove twitter from preferences (PRFL-94) */
alter table PROFILE_PREFERENCES_T drop column TWITTER_ENABLED;
alter table PROFILE_PREFERENCES_T drop column TWITTER_USERNAME;
alter table PROFILE_PREFERENCES_T drop column TWITTER_PASSWORD;

/* add external integration table (PRFL-94) */
create table PROFILE_EXTERNAL_INTEGRATION_T (
	USER_UUID varchar2(99) not null,
	TWITTER_TOKEN varchar2(255),
	TWITTER_SECRET varchar2(255),
	primary key (USER_UUID)
);

cheers,
Steve

On 20/07/2011, at 7:58 AM, Omer Piperdi wrote:

> 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)
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110720/5765e3b6/attachment.html