Uploaded image for project: 'Forms'
  1. Forms
  2. FORMS-621

Data export fails if values cannot be retreived from tableref

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • 2.18.0, 2.17.9
    • 2.18.0
    • Form data

      STEPS TO REPRODUCE :

      • Create a form with a field based on a tableref
      • Display this form on site and submit entries using values from tableref
      • Remove from tableref values used in entries
      • Try to export forms data in xls

      This kind of error occurs :

      Date : 16/10 17:26:16.342
      Utilisateur : dcartier#utilisateurs
      Thread : Thread[http-nio-8082-exec-5,5,main]
      Niveau : ERROR
      Catégorie : org.ametys.plugins.forms.question.types.ChoicesListQuestionType
      URI de la requête : /plugins/forms/forms/entries.xls
      Message : An error occurred while saxing addionnal infos of the select.
      Emplacement : org.ametys.plugins.forms.question.types.ChoicesListQuestionType.saxEntryValue(ChoicesListQuestionType.java:408)
      
      Pile d'appels :
      
      org.ametys.plugins.repository.UnknownAmetysObjectException: There's no node for id content://24ecc6af-cfd1-4310-a155-6fb8c0867687
      at org.ametys.plugins.repository.jcr.SimpleAmetysObjectFactory#getNode:187
      at org.ametys.plugins.repository.jcr.SimpleAmetysObjectFactory#getAmetysObjectById:137
      at org.ametys.plugins.repository.jcr.SimpleAmetysObjectFactory#getAmetysObjectById:58
      at org.ametys.plugins.repository.AmetysObjectResolver#resolveById:382
      at org.ametys.cms.data.ContentValue#getContent:127
      at org.ametys.plugins.forms.question.sources.TableRefSourceType#getEntry:143
      at org.ametys.plugins.forms.question.sources.TableRefSourceType#getEntry:59
      at org.ametys.plugins.forms.question.types.ChoicesListQuestionType#saxEntryValue:394
      at org.ametys.plugins.forms.generators.FormEntryInformationGenerator#_saxQuestion:199
      at org.ametys.plugins.forms.generators.FormEntryInformationGenerator#_saxEntry:163
      at org.ametys.plugins.forms.generators.FormEntriesGenerator#generate:74
      at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#processXMLPipeline:581
      at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline#processXMLPipeline:301
      at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#process:782
      at org.apache.cocoon.components.source.impl.SitemapSource#toSAX:414
      at org.apache.cocoon.components.source.SourceUtil#toSAX:101
      at org.apache.cocoon.components.source.SourceUtil#parse:321
      at org.apache.cocoon.sitemap.ContentAggregator#generate:125
      at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#processXMLPipeline:581
      at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline#processXMLPipeline:301
      at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#process:483
      at org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode#invoke:144
      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.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.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:779
      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:177
      at org.apache.catalina.core.StandardContextValve#invoke:97
      at org.apache.catalina.authenticator.AuthenticatorBase#invoke:541
      at org.apache.catalina.core.StandardHostValve#invoke:135
      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:360
      at org.apache.coyote.http11.Http11Processor#service:399
      at org.apache.coyote.AbstractProcessorLight#process:65
      at org.apache.coyote.AbstractProtocol$ConnectionHandler#process:891
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor#doRun:1784
      at org.apache.tomcat.util.net.SocketProcessorBase#run:49
      at org.apache.tomcat.util.threads.ThreadPoolExecutor#runWorker:1191
      at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker#run:659
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable#run:61
      at java.base/java.lang.Thread#run:833
      
      Caused by: javax.jcr.ItemNotFoundException: 24ecc6af-cfd1-4310-a155-6fb8c0867687
      at org.apache.jackrabbit.core.ItemManager#getItemData:384
      at org.apache.jackrabbit.core.ItemManager#getItem:328
      at org.apache.jackrabbit.core.ItemManager#getItem:621
      at org.apache.jackrabbit.core.SessionImpl#getNodeById:538
      at org.apache.jackrabbit.core.SessionImpl#getNodeByIdentifier:1142
      at org.ametys.plugins.repository.jcr.SimpleAmetysObjectFactory#getNode:176
      ... 87 more
      
      Caused by: org.apache.jackrabbit.core.state.NoSuchItemStateException: 24ecc6af-cfd1-4310-a155-6fb8c0867687
      at org.apache.jackrabbit.core.state.SharedItemStateManager#getItemState:290
      at org.apache.jackrabbit.core.state.LocalItemStateManager#getNodeState:110
      at org.apache.jackrabbit.core.state.LocalItemStateManager#getItemState:175
      at org.apache.jackrabbit.core.state.XAItemStateManager#getItemState:260
      at org.apache.jackrabbit.core.state.SessionItemStateManager#getItemState:161
      at org.apache.jackrabbit.core.ItemManager#getItemData:382
      ... 92 more
      
      Caused by: org.apache.jackrabbit.core.state.NoSuchItemStateException: 24ecc6af-cfd1-4310-a155-6fb8c0867687
      at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager#load:492
      at org.ametys.plugins.repository.provider.AmetysPersistenceManager#load:201
      at org.apache.jackrabbit.core.state.SharedItemStateManager#loadItemState:1878
      at org.apache.jackrabbit.core.state.SharedItemStateManager#getNonVirtualItemState:1798
      at org.apache.jackrabbit.core.state.SharedItemStateManager#getItemState:271
      ... 97 more 

      It would be better export doesn't fail in this case but export empty values if they cannot be retrieved.

            ldurand Laurie Durand
            dcartier David Cartier-Michaud
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: