Uploaded image for project: 'CMS'
  1. CMS
  2. CMS-11737

[demo data] On FO, error with inheritance table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 4.7.3, 4.8.0
    • None
    • None
    • None
    • 4.8.0 M3

      seen on demo.ametys.org/_admin every second when connected to admin and displaying rights

      Message : An error occured with controller 'workspace' for object /admin. Thus, this controller will be ignored.
      Emplacement : org.ametys.core.right.RightManager._getAccessResults(RightManager.java:453)
      
      Pile d'appels :
      
      org.apache.ibatis.exceptions.PersistenceException:
      ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table/View 'RIGHTS_INHERITANCE' does not exist.
      ### The error may exist in /org/ametys/plugins/core/impl/right/profile-assignment.xml
      ### The error may involve ProfilesAssignment.getInheritances
      ### The error occurred while executing a query
      ### SQL: SELECT Disallow, Context FROM Rights_Inheritance
      ### Cause: java.sql.SQLSyntaxErrorException: Table/View 'RIGHTS_INHERITANCE' does not exist.
      at org.apache.ibatis.exceptions.ExceptionFactory#wrapException:30
      at org.apache.ibatis.session.defaults.DefaultSqlSession#selectList:153
      at org.apache.ibatis.session.defaults.DefaultSqlSession#selectList:145
      at org.apache.ibatis.session.defaults.DefaultSqlSession#selectList:140
      at org.ametys.plugins.core.impl.right.JdbcProfileAssignmentStorage#_getInheritances:158
      at org.ametys.plugins.core.impl.right.JdbcProfileAssignmentStorage#isInheritanceDisallowed:945
      at org.ametys.core.right.ProfileAssignmentStorageExtensionPoint#lambda$isInheritanceDisallowed$51:862
      at java.base/java.util.Optional#map:260
      at org.ametys.core.right.ProfileAssignmentStorageExtensionPoint#isInheritanceDisallowed:862
      at org.ametys.plugins.core.impl.right.AbstractHierarchicalAccessController#isInheritanceDisallowed:46
      at org.ametys.plugins.core.impl.right.AbstractHierarchicalAccessController#_getPermission:101
      at org.ametys.plugins.core.impl.right.AbstractProfileStorageBasedAccessController#getPermission:149
      at org.ametys.core.right.RightManager#_getAccessResults:443
      at org.ametys.core.right.RightManager#_hasRightOrRead:347
      at org.ametys.core.right.RightManager#_hasRight:323
      at org.ametys.core.right.RightManager#hasRight:289
      at org.ametys.plugins.core.right.HasRightAction#act:95
      at org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode#invoke:120
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47
      at org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode#invoke:139
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47
      at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
      at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
      at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93
      at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236
      at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178
      at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254
      at org.apache.cocoon.components.treeprocessor.sitemap.MountNode#invoke:118
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47
      at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
      at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
      at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93
      at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236
      at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178
      at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254
      at org.apache.cocoon.Cocoon#process:699
      at org.ametys.runtime.servlet.RuntimeServlet#service:717
      at javax.servlet.http.HttpServlet#service:741
      at org.apache.catalina.core.ApplicationFilterChain#internalDoFilter:231
      at org.apache.catalina.core.ApplicationFilterChain#doFilter:166
      at org.apache.tomcat.websocket.server.WsFilter#doFilter:53
      at org.apache.catalina.core.ApplicationFilterChain#internalDoFilter:193
      at org.apache.catalina.core.ApplicationFilterChain#doFilter:166
      at org.apache.catalina.core.StandardWrapperValve#invoke:202
      at org.apache.catalina.core.StandardContextValve#invoke:96
      at org.apache.catalina.authenticator.AuthenticatorBase#invoke:541
      at org.apache.catalina.core.StandardHostValve#invoke:139
      at org.apache.catalina.valves.ErrorReportValve#invoke:92
      at org.apache.catalina.valves.AbstractAccessLogValve#invoke:688
      at org.apache.catalina.core.StandardEngineValve#invoke:74
      at org.apache.catalina.connector.CoyoteAdapter#service:343
      at org.apache.coyote.http11.Http11Processor#service:375
      at org.apache.coyote.AbstractProcessorLight#process:65
      at org.apache.coyote.AbstractProtocol$ConnectionHandler#process:868
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor#doRun:1594
      at org.apache.tomcat.util.net.SocketProcessorBase#run:49
      at java.base/java.util.concurrent.ThreadPoolExecutor#runWorker:1136
      at java.base/java.util.concurrent.ThreadPoolExecutor$Worker#run:635
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable#run:61
      at java.base/java.lang.Thread#run:833
      
      Caused by: java.sql.SQLSyntaxErrorException: Table/View 'RIGHTS_INHERITANCE' does not exist.
      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:696
      at org.apache.commons.dbcp2.DelegatingConnection#prepareStatement:696
      at org.apache.ibatis.executor.statement.PreparedStatementHandler#instantiateStatement:86
      at org.apache.ibatis.executor.statement.BaseStatementHandler#prepare:88
      at org.apache.ibatis.executor.statement.RoutingStatementHandler#prepare:59
      at org.apache.ibatis.executor.SimpleExecutor#prepareStatement:87
      at org.apache.ibatis.executor.SimpleExecutor#doQuery:62
      at org.apache.ibatis.executor.BaseExecutor#queryFromDatabase:325
      at org.apache.ibatis.executor.BaseExecutor#query:156
      at org.apache.ibatis.executor.CachingExecutor#query:109
      at org.apache.ibatis.executor.CachingExecutor#query:89
      at org.apache.ibatis.session.defaults.DefaultSqlSession#selectList:151
      ... 62 more
      
      Caused by: ERROR 42X05: Table/View 'RIGHTS_INHERITANCE' does not exist.

            laurence Laurence Aumeunier
            raphael Raphaƫl Franchet
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: