Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-5113

java.sql.SQLException: Column 'REALM_ID' cannot be null

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: trunk
    • Fix Version/s: 2.2.0
    • Labels:
      None

      Description

      Permissions helper throws exception:

      org.sakaiproject.tool.api.ToolException
      at org.sakaiproject.authz.tool.PermissionsHelperAction.toolModeDispatch(PermissionsHelperAction.java:80)
      caused by: java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      caused by: java.lang.RuntimeException: SqlService.dbWrite failure
      at org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:871)
      caused by: java.sql.SQLException: Column 'REALM_ID' cannot be null
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
      at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
      at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
      at org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1022)
      at org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:871)
      at org.sakaiproject.util.BaseDbFlatStorage.insertResource(BaseDbFlatStorage.java:639)
      at org.sakaiproject.util.BaseDbFlatStorage.putResource(BaseDbFlatStorage.java:607)
      at org.sakaiproject.util.BaseDbFlatStorage.putResource(BaseDbFlatStorage.java:590)
      at org.sakaiproject.authz.impl.DbAuthzGroupService$DbStorage.put(DbAuthzGroupService.java:750)
      at org.sakaiproject.authz.impl.BaseAuthzGroupService.addAuthzGroup(BaseAuthzGroupService.java:585)
      at org.sakaiproject.authz.cover.AuthzGroupService.addAuthzGroup(AuthzGroupService.java:129)
      at org.sakaiproject.authz.tool.PermissionsAction.buildHelperContext(PermissionsAction.java:130)
      at org.sakaiproject.authz.tool.PermissionsHelperAction.buildMainPanelContext(PermissionsHelperAction.java:95)
      ...

      Can be duplicated by adding Forms tool to a site and clicking 'Permissions' link.

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                jmpease Jim Pease (Inactive)
                Reporter:
                jmpease Jim Pease (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration