[Building Sakai] Unable to parse date text
Kevin Takacs
ktakacs at anisakai.com
Thu Aug 8 13:04:54 PDT 2013
Hi Jeremy,
This looks like it's related to SAM-1550, and there are sql statements
commented out in sakai_2_9_0_mysql_conversion.sql because they were only
needed if an instance had SAM-988, which we merged in for the rSmart 2.8.1
release.
-- SAM-1550
-- Apply the following two queries only if you have SAM-988 in your instance
-- Change the date format from:
-- Wed Sep 14 11:40:53 CDT 2011 (output of Date.toString() in SAM-988)
-- to:
-- 2012-08-23T10:59:34.180-05:00 (ISO8601 format in SAM-1550)
-- Please make the corresponding time zone changes to the queries:
/*
update SAM_SECTIONMETADATA_T set entry = date_format(str_to_date(entry, '%a
%b %d %T SAST %Y'),'%Y-%m-%dT%H:%i:%S.000+02:00') where
label='QUESTIONS_RANDOM_DRAW_DATE';
update SAM_PUBLISHEDSECTIONMETADATA_T set entry =
date_format(str_to_date(entry, '%a %b %d %T SAST
%Y'),'%Y-%m-%dT%H:%i:%S.000+02:00') where
label='QUESTIONS_RANDOM_DRAW_DATE';
*/
Here is a thread from the archives about it too:
http://collab.sakaiproject.org/pipermail/sakai-dev/2012-September/018860.html
On Thu, Aug 8, 2013 at 5:48 AM, Kusnetz, Jeremy <JKusnetz at apus.edu> wrote:
> Since upgrading to 2.9.x we are seeing a ton of the following in
> catalina.out.****
>
> ** **
>
> We are running mysql, did a column type change somewhere that didn’t get
> accounted for in the conversion scripts?****
>
> ** **
>
> 2013-08-08 08:45:59,884 ERROR ajp-bio-41009-exec-10933
> org.sakaiproject.tool.assessment.ui.bean.delivery.SectionContentsBean -
> Unable to parse date text: Thu Feb 14 09:57:43 EST 2013****
>
> java.lang.IllegalArgumentException: Invalid format: "Thu Feb 14 09:57:43
> EST 2013"****
>
> at
> org.joda.time.format.DateTimeFormatter.parseDateTime(DateTimeFormatter.java:866)
> ****
>
> at
> org.sakaiproject.tool.assessment.ui.bean.delivery.SectionContentsBean.setMetaData(SectionContentsBean.java:436)
> ****
>
> at
> org.sakaiproject.tool.assessment.ui.listener.delivery.DeliveryActionListener.getPartBean(DeliveryActionListener.java:893)
> ****
>
> at
> org.sakaiproject.tool.assessment.ui.listener.delivery.DeliveryActionListener.getPageContentsByQuestion(DeliveryActionListener.java:776)
> ****
>
> at
> org.sakaiproject.tool.assessment.ui.listener.delivery.DeliveryActionListener.getPageContents(DeliveryActionListener.java:588)
> ****
>
> at
> org.sakaiproject.tool.assessment.ui.listener.delivery.DeliveryActionListener.processAction(DeliveryActionListener.java:435)
> ****
>
> at
> org.sakaiproject.tool.assessment.ui.bean.delivery.DeliveryBean.save_work(DeliveryBean.java:1781)
> ****
>
> at sun.reflect.GeneratedMethodAccessor4249.invoke(Unknown Source)*
> ***
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> ****
>
> at java.lang.reflect.Method.invoke(Method.java:597)****
>
> at
> com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:146)****
>
> at
> com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:92)
> ****
>
> at javax.faces.component.UICommand.broadcast(UICommand.java:332)**
> **
>
> at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:287)****
>
> at
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:401)**
> **
>
> at
> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:95)
> ****
>
> at
> com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:245)****
>
> at
> com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:110)****
>
> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:213)*
> ***
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> ****
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> ****
>
> at com.corejsf.UploadFilter.doFilter(UploadFilter.java:139)****
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> ****
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> ****
>
> at
> org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:634)****
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> ****
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> ****
>
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
> ****
>
> at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
> ****
>
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
> ****
>
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
> ****
>
> at
> org.sakaiproject.jsf.util.SamigoJsfTool.dispatch(SamigoJsfTool.java:301)**
> **
>
> at org.sakaiproject.jsf.util.JsfTool.doPost(JsfTool.java:256)****
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)***
> *
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)***
> *
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> ****
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> ****
>
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
> ****
>
> at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
> ****
>
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
> ****
>
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
> ****
>
> at
> org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:511)
> ****
>
> at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1525)
> ****
>
> at
> org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:213)
> ****
>
> at
> org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:96)
> ****
>
> at
> org.sakaiproject.portal.charon.handlers.ToolHandler.doPost(ToolHandler.java:73)
> ****
>
> at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCharonPortal.java:1315)
> ****
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)***
> *
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)***
> *
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> ****
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> ****
>
> at
> org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:695)****
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> ****
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> ****
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
> ****
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> ****
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
> ****
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
> ****
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
> ****
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> ****
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
> ****
>
> at
> org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)****
>
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
> ****
>
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
> ****
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> ****
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> ****
>
> at java.lang.Thread.run(Thread.java:662)****
>
> This message is private and confidential. If you have received it in
> error, please notify the sender and remove it from your system.
>
> _______________________________________________
> 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"
>
--
Kevin Takacs
Software Engineer
*O **602-337-8408*
*M **480-544-1972*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130808/fccdad2f/attachment.html
More information about the sakai-dev
mailing list