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

Error Table/View 'USERS_FORMCONNECTIONFAILED' does not exist.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 4.6.0
    • 4.6.0
    • None
    • None
    • 4.6 M9

      Visible on Ametys ODF demo data, but it is general to all projects without captcha control.

      3 similar errors on loading with different places: 

      • FormCredentialProvider._deleteAllPastLoginFailedBDD
      • FormCredentialProvider.requestNbConnectBDD
      • FormCredentialProvider._deleteLoginFailedBDD
         
        Date : 08/12 14:54:05.843
        ThreadThread[http-nio-8080-exec-8,5,main]
        Niveau : ERROR
        Catégorie : org.ametys.plugins.core.impl.authentication.FormCredentialProvider
        URI de la requête : /odf/index.html
        Message : 
        
        Error during the connection to the database
        
        Emplacement : org.ametys.plugins.core.impl.authentication.FormCredentialProvider._deleteAllPastLoginFailedBDD(FormCredentialProvider.java:617)
        
        Pile d'appels :
        
        java.sql.SQLSyntaxErrorException: Table/View 'USERS_FORMCONNECTIONFAILED' 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.ametys.plugins.core.impl.authentication.FormCredentialProvider#_deleteAllPastLoginFailedBDD:609
        at org.ametys.plugins.core.impl.authentication.FormCredentialProvider#requestNbConnectBDD:636
        at org.ametys.plugins.core.impl.authentication.FormCredentialProvider#_getUserIdentityFromRequest:423
        at org.ametys.plugins.core.impl.authentication.FormCredentialProvider#blockingGetUserIdentity:360
        at org.ametys.core.authentication.CredentialProvider#getUserIdentity:130
        at org.ametys.core.authentication.AuthenticateAction#_doProcess:648
        at org.ametys.core.authentication.AuthenticateAction#_process:616
        at org.ametys.core.authentication.AuthenticateAction#act:253
        at org.ametys.web.WebAuthenticateAction#act:113
        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.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:582
        at javax.servlet.http.HttpServlet#service:733
        at org.apache.catalina.core.ApplicationFilterChain#internalDoFilter:227
        at org.apache.catalina.core.ApplicationFilterChain#doFilter:162
        at org.apache.tomcat.websocket.server.WsFilter#doFilter:53
        at org.apache.catalina.core.ApplicationFilterChain#internalDoFilter:189
        at org.apache.catalina.core.ApplicationFilterChain#doFilter:162
        at org.apache.catalina.core.StandardWrapperValve#invoke:202
        at org.apache.catalina.core.StandardContextValve#invoke:97
        at org.apache.catalina.authenticator.AuthenticatorBase#invoke:542
        at org.apache.catalina.core.StandardHostValve#invoke:143
        at org.apache.catalina.valves.ErrorReportValve#invoke:92
        at org.apache.catalina.valves.AbstractAccessLogValve#invoke:687
        at org.apache.catalina.core.StandardEngineValve#invoke:78
        at org.apache.catalina.connector.CoyoteAdapter#service:346
        at org.apache.coyote.http11.Http11Processor#service:374
        at org.apache.coyote.AbstractProcessorLight#process:65
        at org.apache.coyote.AbstractProtocol$ConnectionHandler#process:887
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor#doRun:1684
        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: ERROR 42X05: Table/View 'USERS_FORMCONNECTIONFAILED' does not exist.
        at org.apache.derby.iapi.error.StandardException#newException (Unknown Source)
        at org.apache.derby.iapi.error.StandardException#newException (Unknown Source)
        at org.apache.derby.impl.sql.compile.FromBaseTable#bindTableDescriptor (Unknown Source)
        at org.apache.derby.impl.sql.compile.FromBaseTable#bindNonVTITables (Unknown Source)
        at org.apache.derby.impl.sql.compile.FromList#bindTables (Unknown Source)
        at org.apache.derby.impl.sql.compile.SelectNode#bindNonVTITables (Unknown Source)
        at org.apache.derby.impl.sql.compile.DMLStatementNode#bindTables (Unknown Source)
        at org.apache.derby.impl.sql.compile.DeleteNode#bindStatement (Unknown Source)
        at org.apache.derby.impl.sql.GenericStatement#prepMinion (Unknown Source)
        at org.apache.derby.impl.sql.GenericStatement#prepare (Unknown Source)
        at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext#prepareInternalStatement (Unknown Source)
        ... 61 more 

         

            bmaurel Bérénice Maurel
            mfranchet Magali Franchet
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: