Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-1982

member search and sort strings should trim before change

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 2.4.0.patch, 2.4.1
    • API
    • None

    Description

      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

      Attachments

        Activity

          People

            shilen.patel@at.internet2.edu Shilen Patel (duke.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist