4 Replies Latest reply on Oct 21, 2015 11:02 AM by Ramesh Reddy

    Error filling up cache when getting very long Web Service SOAP XML response

    ejlp12 ejlp12 Newbie

      Hi,

       

      I was creating a virtual table and set it as materialized (internal cache), but I got following error. It also happened when I set the cache to external table in a RDBMS.

      How to resolve the above error? Is there any configuration parameter for making children elements higher than the default?



      19:09:38,264 INFO  [org.teiid.PROCESSOR.MATVIEWS] (Worker7_QueryProcessorQueue115) TEIID30013 Loading materialized view table #MAT_POC_XYZ_WS_TABLE.V_WS_WIL

      19:09:38,289 INFO  [org.apache.cxf.service.factory.ReflectionServiceFactoryBean] (Worker11_QueryProcessorQueue116) Creating Service {http://teiid.org}teiid from class org.apache.cxf.jaxws.support.DummyImpl

      19:09:48,402 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker7_QueryProcessorQueue117) TEIID30015 Failed to load materialized view table #MAT_POC_XYZ_WS_TABLE.V_WS_WIL.: org.teiid.core.TeiidProcessingException: TEIID30151 Error building Source for context item.

        at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:140) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]

        at org.teiid.query.processor.relational.XMLTableNode$1.run(XMLTableNode.java:242) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_40]

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40]

        at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]

      Caused by: nu.xom.ParsingException: Error reported by XML parser: Maximum Number of Children Elements Exceeded

        at nu.xom.Builder.build(Builder.java:1175) [xom-1.2.7.redhat-4.jar:1.2.7.redhat-4]

        at nu.xom.Builder.build(Builder.java:602) [xom-1.2.7.redhat-4.jar:1.2.7.redhat-4]

        at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:134) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]

        ... 7 more

      Caused by: org.xml.sax.SAXException: Error reported by XML parser: Maximum Number of Children Elements Exceeded

      net.sf.saxon.trans.XPathException: Error reported by XML parser: Maximum Number of Children Elements Exceeded

        at org.teiid.query.xquery.saxon.SaxonReader.parse(StreamingUtils.java:171) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]

        at nu.xom.Builder.build(Builder.java:1162) [xom-1.2.7.redhat-4.jar:1.2.7.redhat-4]

        ... 9 more

      Caused by: net.sf.saxon.trans.XPathException: Error reported by XML parser: Maximum Number of Children Elements Exceeded

        at net.sf.saxon.evpull.StaxToEventBridge.next(StaxToEventBridge.java:159) [saxonhe-9.2.1.5.jar:]

        at net.sf.saxon.evpull.EventStackIterator.next(EventStackIterator.java:54) [saxonhe-9.2.1.5.jar:]

        at net.sf.saxon.evpull.EventIteratorToReceiver.copy(EventIteratorToReceiver.java:34) [saxonhe-9.2.1.5.jar:]

        at net.sf.saxon.event.Sender.sendPullEventSource(Sender.java:523) [saxonhe-9.2.1.5.jar:]

        at net.sf.saxon.event.Sender.send(Sender.java:148) [saxonhe-9.2.1.5.jar:]

        at net.sf.saxon.Configuration.buildDocument(Configuration.java:3317) [saxonhe-9.2.1.5.jar:]

        at net.sf.saxon.Configuration.buildDocument(Configuration.java:3262) [saxonhe-9.2.1.5.jar:]

        at org.teiid.query.xquery.saxon.SaxonReader.parse(StreamingUtils.java:169) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]

      19:09:48,406 WARN  [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue117) TEIID30020 Processing exception for request BwSRXLVRea7Q.0 'TEIID30151 Error building Source for context item.'. Originally TeiidProcessingException 'Error reported by XML parser: Maximum Number of Children Elements Exceeded' StaxToEventBridge.java:159. Enable more detailed logging to see the entire stacktrace.