[Building Sakai] roster tool error
Sanghyun Jeon
euksa99 at gmail.com
Mon Apr 15 15:39:27 PDT 2013
Thank you, Matthew,
I need to three more update statements
UPDATE PROFILE_PREFERENCES_T set USE_OFFICIAL_IMAGE = false where
USE_OFFICIAL_IMAGE is null;
UPDATE PROFILE_PREFERENCES_T set SHOW_KUDOS = true where SHOW_KUDOS is null;
UPDATE PROFILE_PREFERENCES_T set SHOW_GALLERY_FEED = true where
SHOW_GALLERY_FEED is null;
and now it works.
Thank you for your proper guide.
S
On Mon, Apr 15, 2013 at 3:07 PM, Matthew Jones <matthew at longsight.com>wrote:
> Well, based on the error:
>
> Null value was assigned to a property of primitive type setter of org.sakaiproject.profile2.model.ProfilePreferences.messageNewEmailEnabled
>
> There are null values in the database table Profile Preferences column.
>
> These were actually added back in the 2.8.0 conversion. I'm not sure where
> *that* conversion is, or suddenly MySQL got pickier about the bit column.
>
> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_8_0_mysql_conversion.sql
>
> -- PRFL-152, PRFL-186 add the new email message preference columns, default to 0
> alter table PROFILE_PREFERENCES_T add EMAIL_MESSAGE_NEW bit not null default false;
> alter table PROFILE_PREFERENCES_T add EMAIL_MESSAGE_REPLY bit not null default false;
>
> Try to run an update to set them to false?
>
> UPDATE PROFILE_PREFERENCES_T set EMAIL_MESSAGE_NEW = false WHERE
> EMAIL_MESSAGE_NEW is null;
> UPDATE PROFILE_PREFERENCES_T set EMAIL_MESSAGE_REPLY = false WHERE
> EMAIL_MESSAGE_REPLY IS null;
>
>
> On Mon, Apr 15, 2013 at 5:56 PM, Sanghyun Jeon <euksa99 at gmail.com> wrote:
>
>> I already did it.
>>
>> from 2.7.0--> 2.7.1 to 2.8.2 -> 2.8.3 conversion script
>>
>> I do it again now and 0 rows affected
>>
>> Any other advice, please...
>>
>> S
>>
>>
>> On Mon, Apr 15, 2013 at 2:45 PM, Matthew Jones <matthew at longsight.com>wrote:
>>
>>> Probably is this conversion then.
>>>
>>>
>>> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_8_1-2_8_2_mysql_conversion.sql
>>>
>>> The problem with upgrading off the .x branch is that hibernate can can
>>> do schema alterations (ALTERS), but can't run data changes (UPDATES). So
>>> you still need to keep up-to-date with the latest conversion scripts. We
>>> currently don't have a great solution for that across all tools, though
>>> some tools (Lessons specifically) work a little better at this than others.
>>>
>>>
>>> On Mon, Apr 15, 2013 at 5:40 PM, Sanghyun Jeon <euksa99 at gmail.com>wrote:
>>>
>>>> Sam,
>>>>
>>>> I did not modify master/pom.xml.
>>>> I also have the same profile2 file when I checked out sakai2.8x._all
>>>> However, I am having the following error when I click the roster tool
>>>> (not roster 2)
>>>>
>>>> org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>> at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
>>>> caused by: org.sakaiproject.tool.api.ToolException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>> at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1429)
>>>> caused by: javax.servlet.ServletException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>>>> caused by: javax.faces.FacesException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>> at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
>>>> caused by: org.apache.jasper.JasperException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
>>>> caused by: javax.faces.FacesException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>> at org.apache.myfaces.shared_impl.renderkit.html.HtmlTextRendererBase.renderOutput(HtmlTextRendererBase.java:69)
>>>> caused by: javax.faces.el.EvaluationException: Cannot get value for expression '#{filter.init}'
>>>> at javax.faces.component.UIOutput.getValue(UIOutput.java:80)
>>>> caused by: javax.faces.el.EvaluationException: Exception getting value of property init of base of type : org.sakaiproject.tool.roster.FilteredParticipantListingBean
>>>> at org.apache.myfaces.el.ELParserHelper$MyPropertySuffix.evaluate(ELParserHelper.java:535)
>>>> caused by: javax.faces.el.EvaluationException: Bean: org.sakaiproject.tool.roster.FilteredParticipantListingBean, property: init
>>>> at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:85)
>>>> caused by: java.lang.reflect.InvocationTargetException
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>> caused by: org.springframework.orm.hibernate3.HibernateSystemException: Null value was assigned to a property of primitive type setter of org.sakaiproject.profile2.model.ProfilePreferences.messageNewEmailEnabled; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.sakaiproject.profile2.model.ProfilePreferences.messageNewEmailEnabled
>>>> 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.profile2.model.ProfilePreferences.messageNewEmailEnabled
>>>> at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:329)
>>>> caused by: java.lang.IllegalArgumentException
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>
>>>>
>>>> I was advised to apply SAK-23452(Roster throws errors in 2.9 after MySQL upgrade), but my db even does not have USE_GRAVATAR...
>>>>
>>>>
>>>> Now I am puzzled.
>>>>
>>>> Do I need roster2 instead fo roster in order to make profile2 worked?
>>>>
>>>>
>>>> S
>>>>
>>>>
>>>>
>>>> On Mon, Apr 15, 2013 at 2:28 PM, Sam Ottenhoff <ottenhoff at longsight.com
>>>> > wrote:
>>>>
>>>>> The master pom file contains all relevant indie versions:
>>>>>
>>>>>
>>>>> https://source.sakaiproject.org/svn//master/branches/sakai-2.8.x/pom.xml
>>>>>
>>>>>
>>>>> On Mon, Apr 15, 2013 at 5:25 PM, Sanghyun Jeon <euksa99 at gmail.com>wrote:
>>>>>
>>>>>> what is the proper profile 2 version for sakai 2.8x.?
>>>>>>
>>>>>> S
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Mon, Apr 15, 2013 at 12:09 PM, Matthew Jones <
>>>>>> matthew at longsight.com> wrote:
>>>>>>
>>>>>>> Look at the conversions in SAK-23452 at the bottom of
>>>>>>>
>>>>>>> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_9_1-2_9_2_mysql_conversion.sql
>>>>>>>
>>>>>>> Might fix this problem.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Mon, Apr 15, 2013 at 3:02 PM, Sanghyun Jeon <euksa99 at gmail.com>wrote:
>>>>>>>
>>>>>>>> We are planning to upgrade sakai 2.8.x_all with profile2 (1.4.12)
>>>>>>>> from Sakai 2.7.0 this summer and we are having an error when we click the
>>>>>>>> roster tool (not all sites, but some sites..)
>>>>>>>>
>>>>>>>> org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>>>>>> at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
>>>>>>>> caused by: org.sakaiproject.tool.api.ToolException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>>>>>> at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1429)
>>>>>>>> caused by: javax.servlet.ServletException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>>>>>>>> caused by: javax.faces.FacesException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>>>>>> at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
>>>>>>>> caused by: org.apache.jasper.JasperException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>>>>>> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
>>>>>>>> caused by: javax.faces.FacesException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /roster/main.jsp][Class: org.sakaiproject.jsf.component.ViewComponent,Id: _idJsp0][Class: javax.faces.component.html.HtmlForm,Id: roster_form][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp14]}
>>>>>>>> at org.apache.myfaces.shared_impl.renderkit.html.HtmlTextRendererBase.renderOutput(HtmlTextRendererBase.java:69)
>>>>>>>> caused by: javax.faces.el.EvaluationException: Cannot get value for expression '#{filter.init}'
>>>>>>>> at javax.faces.component.UIOutput.getValue(UIOutput.java:80)
>>>>>>>> caused by: javax.faces.el.EvaluationException: Exception getting value of property init of base of type : org.sakaiproject.tool.roster.FilteredParticipantListingBean
>>>>>>>> at org.apache.myfaces.el.ELParserHelper$MyPropertySuffix.evaluate(ELParserHelper.java:535)
>>>>>>>> caused by: javax.faces.el.EvaluationException: Bean: org.sakaiproject.tool.roster.FilteredParticipantListingBean, property: init
>>>>>>>> at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:85)
>>>>>>>> caused by: java.lang.reflect.InvocationTargetException
>>>>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>>>>>> caused by: org.springframework.orm.hibernate3.HibernateSystemException: Null value was assigned to a property of primitive type setter of org.sakaiproject.profile2.model.ProfilePreferences.messageNewEmailEnabled; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.sakaiproject.profile2.model.ProfilePreferences.messageNewEmailEnabled
>>>>>>>> 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.profile2.model.ProfilePreferences.messageNewEmailEnabled
>>>>>>>> at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:329)
>>>>>>>> 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:597)
>>>>>>>>
>>>>>>>>
>>>>>>>> I saw the solution from
>>>>>>>>
>>>>>>>> https://jira.sakaiproject.org/browse/PRFL-725
>>>>>>>>
>>>>>>>> but the affected version shows Profile2 1.5.0 and we are using 1.4.12.
>>>>>>>>
>>>>>>>> When I try to modify ProfileLogicImpl.java based on this JIRA, I notice I need to modify more than 5 java files in order to avoid build errors. I am wondering what the correct profile2 version for sakai 2.8.x is?
>>>>>>>>
>>>>>>>>
>>>>>>>> Do I need to upgrade profile2 from 1.4.12 to 1.5.0?
>>>>>>>>
>>>>>>>> If so, I also see some other DB conversion script for Profile2 1.5 version.
>>>>>>>>
>>>>>>>> Please advise me.
>>>>>>>>
>>>>>>>> Thank you in advance.
>>>>>>>>
>>>>>>>>
>>>>>>>> S
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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/20130415/44dafbe0/attachment.html
More information about the sakai-dev
mailing list