uPortal IRC Logs-2013-06-28

Owned by Apereo Infrastructure
Last updated: Jun 28, 2013
2 min read

[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