Skip to Content.
Sympa Menu

grouper-dev - [grouper-dev] RE: sortString0 lenght

Subject: Grouper Developers Forum

List archive

[grouper-dev] RE: sortString0 lenght

Chronological Thread 
  • From: Chris Hyzer <>
  • To: Gagné Sébastien <>
  • Cc: "" <>
  • Subject: [grouper-dev] RE: sortString0 lenght
  • Date: Tue, 23 Oct 2012 15:13:30 +0000
  • Accept-language: en-US

Is there a full stacktrace here?  Also, what DB are you using?  And what was the exact displayExtension?


It is truncated, but I think the accented characters are taking more space in the DB than this method thinks there are:


GrouperUtil.truncateAscii(String, int length)


We can adjust it





From: [mailto:] On Behalf Of Gagné Sébastien
Sent: Tuesday, October 23, 2012 9:12 AM
Subject: [grouper-dev] sortString0 lenght



In my import test I ran in an exception :


2012-10-23 01:38:07,548: [main] ERROR AcadLoader.main(79) -  - Erreur dans le chargement des inscriptions!!

edu.internet2.middleware.grouper.exception.GroupAddException: cannot create child group: , stem name: acad:0325:Cours, group extension: H13_FRA2007, group dExtension: H13_FRA2007, Questions d’histoire de la littérature, uuid: null, typeOfGroup: null

Problem create child group:

Stem[displayName=acad:0325, Littératures de langue française:Cours,name=acad:0325:Cours,uuid=bae5cd5bac0d4081be81e1daa44664fd,creator=c870c98ed3f945eab1fd38f820f51ba0,modifier=c870c98ed3f945eab1fd38f820f51ba0],

child: Group[name=acad:0325:Cours:H13_FRA2007,uuid=159a149c15b8492db906084b4a416502], memberDto: '159a149c15b8492db906084b4a416502'/'group'/'g:gsa', Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false,

Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "DV_GROUPER"."GROUPER_MEMBERS"."SORT_STRING0" (actual: 51, maximum: 50)



Checking my configs, the default sortString0 for g:gsa is “displayExtension”, but in the GROUPS table display extension has a max length of 255 which is larger than the sortstring0’s length of 50. To fix it I simply changed sortString0 from “displayExtension” to “extension” since it’s more appropriate in our case, but maybe there could be a default value that prevents this error from happening, maybe increase the size of SortStrings or add some jexl to limit the size to 50



Sébastien Gagné,     | Analyste en informatique

514-343-6111 x33844  | Université de Montréal,

                     | Pavillon Roger-Gaudry, local X-100-11


Archive powered by MHonArc 2.6.16.

Top of Page