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

[Steve Swinsburg]

Hi Omer,

It is part of the 2.7.0-2.7.1 upgrade:

https://source.sakaiproject.org/svn/reference/branches/sakai-2.8.x/docs/conversion/sakai_2_7_0-2_7_1_mysql_conversion.sql
https://source.sakaiproject.org/svn/reference/branches/sakai-2.8.x/docs/conversion/sakai_2_7_0-2_7_1_oracle_conversion.sql

You must ensure you run all successive upgrade scripts when moving between versions.

cheers,
Steve

On 21/07/2011, at 1:27 AM, Omer Piperdi wrote:

> Thanks Steve.. it works.. I wonder this should be part of 2.8 conversion script, as I am upgrading from 2.7 and we had Profile2 with it.
> 
> Thanks
> Omer
> 
> On 7/19/2011 7:21 PM, Steve Swinsburg wrote:
>> 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
>>> <mailto: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"
>> 
>> !DSPAM:2294,4e261f8c144541152711596!