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

[Omer Piperdi]

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!