member search and sort strings should trim before change

2019-01-05 10:14:01,197: [pool-1-thread-4] ERROR Member$2.call(4564) - Error updating member attributes:

java.lang.RuntimeException: Problem with query in bysqlstatic: update grouper_members set sort_string0 = ?, sort_string1 = ?, sort_string2 = ?, sort_string3 = ?, sort_string4 = ?, search_string0 = ?, search_string1 = ?, search_string2 = ?, search_string3 = ?, search_string4 = ?, name = ?, description = ?, subject_identifier0 = ? where id = ?,

Problem in HibernateSession: HibernateSession (1916b42): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (13ae2e5)

                at edu.internet2.middleware.grouper.hibernate.BySql.executeSql(BySql.java:125)

                at edu.internet2.middleware.grouper.Member$2$1.callback(Member.java:4533)

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

                at edu.internet2.middleware.grouper.Member$2.call(Member.java:4518)

                at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

                at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.SQLException: ORA-12899: value too large for column "AUTHZADM"."GROUPER_MEMBERS"."SORT_STRING0" (actual: 136, maximum: 50)

 

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

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

                at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999)

                at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:539)

                at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:235)

                at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543)

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

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

                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1764)

                at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4401)

                at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4568)

                at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:5579)

                at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:384)

                at edu.internet2.middleware.grouper.hibernate.BySql.executeSql(BySql.java:120)

                ... 7 more