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: Gagné Sébastien <>
  • To: "Chris Hyzer" <>
  • Cc: <>
  • Subject: [grouper-dev] RE: sortString0 lenght
  • Date: Tue, 23 Oct 2012 11:45:34 -0400

Full stack trace below, I copied everything, but maybe you would only be interested in the last part I marked (my global try..catch).

We are using Oracle database

According to the stack trace : group dExtension: H13_FRA2007, Questions d’histoire de la literature

 

I checked in my DB and found some truncated strings. I think you are right about accents character taking 2 characters in the DB. I found strings with accents, some of them were truncated they were 50-“number of accents there is” in length

 

Here are some examples, all of them were truncated :

50: H13_CHM1600, Chimie de l'environnement - introduct

49: A12_113710, Littératures de langues anglaise et f

48: H13_113810, Études anglaises et Littérature comp

   

I think I found the problem :

H13_FRA2007, Questions d’histoire de la litérature

Is exactly 50 characters according to String.length()

But the accents makes it 51 characters long in the DB.

 

So there might an error in truncateAscii when input is exactly 50 characters long

 

 

 

2012-10-23 01:38:07,508: [main] ERROR JDBCExceptionReporter.logExceptions(234) -  - ORA-12899: value too large for column "DV_GROUPER"."GROUPER_MEMBERS"."SORT_STRING0" (actual: 51, maximum: 50)

 

2012-10-23 01:38:07,509: [main] ERROR JDBCExceptionReporter.logExceptions(234) -  - ORA-12899: value too large for column "DV_GROUPER"."GROUPER_MEMBERS"."SORT_STRING0" (actual: 51, maximum: 50)

 

2012-10-23 01:38:07,509: [main] ERROR GrouperUtil.logErrorNextException(620) -  - Next exception

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

 

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1135)

        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12402)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)

        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)

        at edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:214)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO$1.callback(Hib3StemDAO.java:148)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.createChildGroup(Hib3StemDAO.java:110)

        at edu.internet2.middleware.grouper.Stem$5.callback(Stem.java:2073)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1991)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1964)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1939)

        at edu.internet2.middleware.grouper.GroupSave$1$1.callback(GroupSave.java:379)

        at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:801)

        at edu.internet2.middleware.grouper.GroupSave$1.callback(GroupSave.java:274)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)

        at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)

        at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)

        at edu.internet2.middleware.grouper.GroupSave.save(GroupSave.java:267)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.createOrUpdateGrouperGroup(AcadLoader.java:945)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.createOrUpdateGrouperGroup(AcadLoader.java:879)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.traiterDepartement(AcadLoader.java:412)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.traiterImportationComplete(AcadLoader.java:369)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.chargerInscriptions(AcadLoader.java:184)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.main(AcadLoader.java:76)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at bsh.Reflect.invokeMethod(Unknown Source)

        at bsh.Reflect.invokeStaticMethod(Unknown Source)

        at bsh.Name.invokeMethod(Unknown Source)

        at bsh.BSHMethodInvocation.eval(Unknown Source)

        at bsh.BSHPrimaryExpression.eval(Unknown Source)

        at bsh.BSHPrimaryExpression.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at edu.internet2.middleware.grouper.app.gsh.ShellHelper.eval(ShellHelper.java:63)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.run(GrouperShell.java:428)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.grouperShellHelper(GrouperShell.java:232)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:162)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)

2012-10-23 01:38:07,511: [main] ERROR GrouperUtil.logErrorNextException(620) -  - Next exception

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

 

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1135)

        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12402)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)

        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)

        at edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:214)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO$1.callback(Hib3StemDAO.java:148)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.createChildGroup(Hib3StemDAO.java:110)

        at edu.internet2.middleware.grouper.Stem$5.callback(Stem.java:2073)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1991)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1964)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1939)

        at edu.internet2.middleware.grouper.GroupSave$1$1.callback(GroupSave.java:379)

        at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:801)

        at edu.internet2.middleware.grouper.GroupSave$1.callback(GroupSave.java:274)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)

        at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)

        at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)

        at edu.internet2.middleware.grouper.GroupSave.save(GroupSave.java:267)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.createOrUpdateGrouperGroup(AcadLoader.java:945)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.createOrUpdateGrouperGroup(AcadLoader.java:879)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.traiterDepartement(AcadLoader.java:412)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.traiterImportationComplete(AcadLoader.java:369)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.chargerInscriptions(AcadLoader.java:184)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.main(AcadLoader.java:76)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at bsh.Reflect.invokeMethod(Unknown Source)

        at bsh.Reflect.invokeStaticMethod(Unknown Source)

        at bsh.Name.invokeMethod(Unknown Source)

        at bsh.BSHMethodInvocation.eval(Unknown Source)

        at bsh.BSHPrimaryExpression.eval(Unknown Source)

        at bsh.BSHPrimaryExpression.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at edu.internet2.middleware.grouper.app.gsh.ShellHelper.eval(ShellHelper.java:63)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.run(GrouperShell.java:428)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.grouperShellHelper(GrouperShell.java:232)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:162)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)

2012-10-23 01:38:07,547: [main] ERROR GrouperUtil.logErrorNextException(620) -  - Next exception

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

 

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1135)

        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12402)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)

        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)

        at edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:214)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO$1.callback(Hib3StemDAO.java:148)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.createChildGroup(Hib3StemDAO.java:110)

        at edu.internet2.middleware.grouper.Stem$5.callback(Stem.java:2073)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1991)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1964)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1939)

        at edu.internet2.middleware.grouper.GroupSave$1$1.callback(GroupSave.java:379)

        at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:801)

        at edu.internet2.middleware.grouper.GroupSave$1.callback(GroupSave.java:274)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)

        at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)

        at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)

        at edu.internet2.middleware.grouper.GroupSave.save(GroupSave.java:267)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.createOrUpdateGrouperGroup(AcadLoader.java:945)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.createOrUpdateGrouperGroup(AcadLoader.java:879)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.traiterDepartement(AcadLoader.java:412)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.traiterImportationComplete(AcadLoader.java:369)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.chargerInscriptions(AcadLoader.java:184)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.main(AcadLoader.java:76)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at bsh.Reflect.invokeMethod(Unknown Source)

        at bsh.Reflect.invokeStaticMethod(Unknown Source)

        at bsh.Name.invokeMethod(Unknown Source)

        at bsh.BSHMethodInvocation.eval(Unknown Source)

        at bsh.BSHPrimaryExpression.eval(Unknown Source)

        at bsh.BSHPrimaryExpression.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at edu.internet2.middleware.grouper.app.gsh.ShellHelper.eval(ShellHelper.java:63)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.run(GrouperShell.java:428)

       at edu.internet2.middleware.grouper.app.gsh.GrouperShell.grouperShellHelper(GrouperShell.java:232)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:162)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)

 

THIS NEXT STACK IS WHAT I COUGHT IN MY GLOBAL TRY..CATCH

 

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: nullProblem 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, grouperTransactionType: READ_WRITE_NEW,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

        at edu.internet2.middleware.grouper.Stem$5.callback(Stem.java:2109)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1991)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1964)

        at edu.internet2.middleware.grouper.Stem.internal_addChildGroup(Stem.java:1939)

        at edu.internet2.middleware.grouper.GroupSave$1$1.callback(GroupSave.java:379)

        at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:801)

        at edu.internet2.middleware.grouper.GroupSave$1.callback(GroupSave.java:274)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)

        at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)

        at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)

        at edu.internet2.middleware.grouper.GroupSave.save(GroupSave.java:267)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.createOrUpdateGrouperGroup(AcadLoader.java:945)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.createOrUpdateGrouperGroup(AcadLoader.java:879)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.traiterDepartement(AcadLoader.java:412)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.traiterImportationComplete(AcadLoader.java:369)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.chargerInscriptions(AcadLoader.java:184)

        at ca.umontreal.dgtic.grouper.acadLoader.AcadLoader.main(AcadLoader.java:76)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at bsh.Reflect.invokeMethod(Unknown Source)

        at bsh.Reflect.invokeStaticMethod(Unknown Source)

        at bsh.Name.invokeMethod(Unknown Source)

        at bsh.BSHMethodInvocation.eval(Unknown Source)

        at bsh.BSHPrimaryExpression.eval(Unknown Source)

        at bsh.BSHPrimaryExpression.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at edu.internet2.middleware.grouper.app.gsh.ShellHelper.eval(ShellHelper.java:63)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.run(GrouperShell.java:428)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.grouperShellHelper(GrouperShell.java:232)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:162)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)

Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: 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, grouperTransactionType: READ_WRITE_NEW

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.createChildGroup(Hib3StemDAO.java:158)

        at edu.internet2.middleware.grouper.Stem$5.callback(Stem.java:2073)

        ... 37 more

Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:495)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:581)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.createChildGroup(Hib3StemDAO.java:110)

        ... 38 more

Caused by: org.hibernate.QueryTimeoutException: Could not execute JDBC batch update,

Exception in save: edu.internet2.middleware.grouper.Member, edu.internet2.middleware.grouper.hibernate.ByObject@1a9a9bd

        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)

        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)

        at edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:214)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO$1.callback(Hib3StemDAO.java:148)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)

        ... 39 more

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

 

        at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:498)

        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12480)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

        ... 47 more

 

De : Chris Hyzer [mailto:]
Envoyé : 23 octobre 2012 11:14
À : Gagné Sébastien
Cc :
Objet : RE: sortString0 lenght

 

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

 

Thanks,

Chris

 

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

 

Hi,

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