Skip to Content.
Sympa Menu

grouper-users - [grouper-users] Grouper Error after MySQL charset/collation change

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Grouper Error after MySQL charset/collation change


Chronological Thread 
  • From: "Waldbieser, Carl" <>
  • To: Gouper Users List <>
  • Subject: [grouper-users] Grouper Error after MySQL charset/collation change
  • Date: Mon, 7 Dec 2015 12:01:16 -0500 (EST)


In a testing instance of Grouper v2.2.2, we tried updating the database
collation to utf8_bin.
I have an outline of the steps our DBA used, if that is relevant.

When the database was restored and I re-enabled the test instance, most
things worked fine, but one group issued a Java stack trace when I tried to
view it:

Error: Problem in HibernateSession: HibernateSession (3d92ab11): new,
readonly, READONLY_NEW, notActiveTransaction, session (17c96394), Exception
in list: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query:
'select distinct m from Member m, MembershipEntry ms, Group g, Field f where
ms.ownerGroupId = g.uuid and ms.memberUuid = m.uuid and ms.enabledDb = 'T'
and ms.fieldId = f.uuid and f.typeString = 'list' and ms.ownerGroupId in
(:SR6GXF6M0) ', cacheable: false, cacheRegion:
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx
type: null, options: QueryOptions: queryPaging: pageSize: 50,
pageNumberOnIndexed: 1, querySort: m.sortString0 asc, , tx type: nullBind
var[0]: 'Param (class java.lang.String):
'SR6GXF6M0'->'5461be27a8d844239ebd59990a360d31', , Problem calling method
updateLoaderGroup on
edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2Group

Any idea what that might mean? The group is configured as a Grouper Loader
group.

Thanks,
Carl Waldbieser
ITS Systems Programmer
Lafayette College



Archive powered by MHonArc 2.6.16.

Top of Page