[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
[11:23:45 CDT(-0500)] <EricDalquist> so lets look at: https://github.com/Jasig/uPortal/compare/uportal-4.0.7...uportal-4.0.9.1
[11:24:44 CDT(-0500)] <jwennmacher> vcrowley: did they have this error on 4.0.7 or is the situation it is just appearing now they are trying to migrate to 4.0.9.1?
[11:26:22 CDT(-0500)] <EricDalquist> so I'm not seeing anything obvious in that diff that would have changed column types
[11:26:26 CDT(-0500)] <EricDalquist> perhaps this was already there
[11:26:34 CDT(-0500)] <EricDalquist> one option for a "just reboot" style fix
[11:26:54 CDT(-0500)] <EricDalquist> would be to just drop and recreate the up_raw_events table
[11:26:57 CDT(-0500)] <EricDalquist> and see if that fixes it
[11:27:09 CDT(-0500)] <EricDalquist> or try doing an initportal on a new sqlserver db with 4.0.9.1
[11:27:13 CDT(-0500)] <EricDalquist> and see if they get the error tere
[11:27:32 CDT(-0500)] <EricDalquist> trying to see if this is a bug with 4.0.9.1 on sqlserver or with upgrading from an existing database schema
[11:29:39 CDT(-0500)] <jwennmacher> makes sense.
[11:33:54 CDT(-0500)] <vcrowley> i do not believe this was seen with 4.0.7
[12:18:29 CDT(-0500)] <jwennmacher> EricDalquist: On the sqlserver error, this was on a clean dev environment post initportal. They tried SQLServer2005Dialect, SQLServer2008Dialect, jTds driver (1.3.x), and Microsoft JDBC v4 driver. Same issue as I understand it.
[12:19:13 CDT(-0500)] <jwennmacher> You think there is there a reason to have them try 4.0.11 just to see?
[12:59:41 CDT(-0500)] <EricDalquist> yeah
[12:59:59 CDT(-0500)] <EricDalquist> I would be interested to see if 4.0.11 fixes it
[13:00:02 CDT(-0500)] <EricDalquist> otherwise it will be a bug
[13:00:08 CDT(-0500)] <EricDalquist> and we'll have to figure out how to fix it