Uploaded image for project: 'Runtime'
  1. Runtime
  2. RUNTIME-4195

Deletion of an unknown user after all personal data processed failed

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Critical Critical
    • 4.9.0
    • None
    • None
    • None
    • 4.9.0 RC3

      I launch processus to delete personal data.
      At the end of the processus, there is no more data, so the user should be removed from user status table.
      It failed on a derby database (demo environnement)

      org.apache.ibatis.exceptions.PersistenceException: 
      ### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Column 'POPULATION' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'POPULATION' is not a column in the target table.
      ### The error may exist in /org/ametys/core/user/status/user-status.xml
      ### The error may involve UserStatus.deleteUserStatusInfo
      ### The error occurred while executing an update
      ### SQL: DELETE FROM Users_Status             WHERE login = ? AND population = ?
      ### Cause: java.sql.SQLSyntaxErrorException: Column 'POPULATION' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'POPULATION' is not a column in the target table.
      	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
      	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)
      	at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:212)
      	at org.ametys.core.user.status.UserStatusManager.remove(UserStatusManager.java:301)
      	at org.ametys.core.user.status.RemovePersonalDataSchedulable.execute(RemovePersonalDataSchedulable.java:60)
      	at org.ametys.core.schedule.AmetysJob.execute(AmetysJob.java:157)
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      Caused by: java.sql.SQLSyntaxErrorException: Column 'POPULATION' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'POPULATION' is not a column in the target table.
      	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      	at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
      	at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
      	at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
      	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
      	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
      	at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:713)
      	at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:713)
      	at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:88)
      	at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:90)
      	at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:60)
      	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:90)
      	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
      	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
      	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
      	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
      	... 6 more
      

            ggouin Guillaume Gouin
            laurence Laurence Aumeunier
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: