[11:02:39 CDT(-0500)] <jwennmacher> EricDalquist: Someone trying to migrate to uPortal 4.0.9.1 reported getting the following error in their logs:
[11:02:39 CDT(-0500)] <jwennmacher> ERROR [uP-TaskExec-1-aggregateRawEvents] aggr.PortalEventProcessingManagerImpl.[] 2013-06-27 19:53:10,567 - aggregateRawEvents failed
[11:02:40 CDT(-0500)] <jwennmacher> javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: The data types time and datetime are incompatible in the greater than or equal to operator.
[11:02:40 CDT(-0500)] <jwennmacher> at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1377)
[11:02:40 CDT(-0500)] <jwennmacher> Have you seen something like this before? I saw a jira UP-3358 but that was resolved long ago.
[11:03:02 CDT(-0500)] <EricDalquist> uh hrm
[11:03:17 CDT(-0500)] <EricDalquist> yeah I remember seeing that but I never thought there was a release with that bug
[11:03:22 CDT(-0500)] <EricDalquist> why are they not going to .11?
[11:04:07 CDT(-0500)] <jwennmacher> Not sure. I haven't had a chance to talk with them yet
[11:04:24 CDT(-0500)] <jwennmacher> think it would make a difference with sqlserver?
[11:05:13 CDT(-0500)] <EricDalquist> maybe?
[11:05:22 CDT(-0500)] <EricDalquist> I'd need to see the full stack trace to give you a better answer
[11:12:58 CDT(-0500)] <jwennmacher> https://gist.github.com/jameswennmacher/5885908
[11:14:12 CDT(-0500)] <EricDalquist> uhg
[11:14:13 CDT(-0500)] <EricDalquist> yeah
[11:14:18 CDT(-0500)] <EricDalquist> that is a sqlserver specific bug
[11:14:23 CDT(-0500)] <EricDalquist> what version are they coming from?
[11:15:20 CDT(-0500)] <jwennmacher> I'll ask after the community call
[11:20:39 CDT(-0500)] <vcrowley> they are migrating from 4.0.7 to 4.0.9.1
[11:21:01 CDT(-0500)] <EricDalquist> hrm