Hi Riyafa, For the google spreadsheet connector, you need to enable the following builders and formatters.
<messageFormatter contentType="application/atom+xml" class= "org.apache.axis2.transport.http.ApplicationXMLFormatter"/> <messageformatter contenttype="text/csv" class= "org.apache.axis2.format.PlainTextFormatter"/> <messageBuilder contentType="application/atom+xml" class="org.apache.axis2.builder.ApplicationXMLBuilder" /> <messagebuilder contenttype="text/csv" class="org.apache.axis2.format.PlainTextBuilder"/> Thanks, Thulasika On Mon, Dec 7, 2015 at 1:15 PM, Malaka Silva <mal...@wso2.com> wrote: > Riyafa seems like a builder error. Can you try enabling wire logs and > analyse the response from the APIs. > > Also what is your use case? > > On Mon, Dec 7, 2015 at 12:08 PM, Riyafa Abdul Hameed <riy...@wso2.com> > wrote: > >> Hi, >> >> I have a proxy service which I have attached with the mail which makes >> several one call to the salesforce api using the salesforce connector and >> two calls to the google spreadsheet api using the google-spreadsheet >> connector in each iteration. When the number of rows I call (or the number >> of iterations) increase beyond 35 the proxy service starts throwing the >> following two exceptions: >> >> >> *[2015-12-07 11:22:03,785] ERROR - RelayUtils Error while building >> Passthrough stream * >> >> *org.apache.axiom.om.OMException: javax.xml.stream.XMLStreamException: >> DOCTYPE is not allowed * >> >> * at >> org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:296) >> * >> >> * at >> org.apache.axiom.om.impl.llom.OMDocumentImpl.getOMDocumentElement(OMDocumentImpl.java:109) >> * >> >> * at >> org.apache.axiom.om.impl.builder.StAXOMBuilder.getDocumentElement(StAXOMBuilder.java:570) >> * >> >> * at >> org.apache.axiom.om.impl.builder.StAXOMBuilder.getDocumentElement(StAXOMBuilder.java:566) >> * >> >> * at >> org.apache.synapse.transport.passthru.util.DeferredMessageBuilder.getDocument(DeferredMessageBuilder.java:149) >> * >> >> * at >> org.apache.synapse.transport.passthru.util.RelayUtils.builldMessage(RelayUtils.java:133) >> * >> >> * at >> org.apache.synapse.transport.passthru.util.RelayUtils.buildMessage(RelayUtils.java:98) >> * >> >> * at >> org.apache.synapse.core.axis2.SynapseCallbackReceiver.handleMessage(SynapseCallbackReceiver.java:400) >> * >> >> * at >> org.apache.synapse.core.axis2.SynapseCallbackReceiver.receive(SynapseCallbackReceiver.java:172) >> * >> >> * at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) * >> >> * at >> org.apache.synapse.transport.passthru.ClientWorker.run(ClientWorker.java:247) >> * >> >> * at >> org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) >> * >> >> * at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >> * >> >> * at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >> * >> >> * at java.lang.Thread.run(Thread.java:745) * >> >> *Caused by: javax.xml.stream.XMLStreamException: DOCTYPE is not allowed * >> >> * at >> org.apache.axiom.util.stax.dialect.DisallowDoctypeDeclStreamReaderWrapper.next(DisallowDoctypeDeclStreamReaderWrapper.java:36) >> * >> >> * at >> org.apache.axiom.om.impl.builder.StAXOMBuilder.parserNext(StAXOMBuilder.java:681) >> * >> >> * at >> org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:214) >> * >> >> * ... 14 more * >> >> And >> >> >> *[2015-12-07 11:22:04,040] ERROR - RelayUtils Error while building >> Passthrough stream * >> >> *org.apache.axiom.om.OMException: >> com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character 'I' >> (code 73) in prolog; expected '<' * >> >> *at [row,col {unknown-source}]: [1,1] * >> >> * at >> org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:296) >> * >> >> * at >> org.apache.axiom.om.impl.llom.OMDocumentImpl.getOMDocumentElement(OMDocumentImpl.java:109) >> * >> >> * at >> org.apache.axiom.om.impl.builder.StAXOMBuilder.getDocumentElement(StAXOMBuilder.java:570) >> * >> >> * at >> org.apache.axiom.om.impl.builder.StAXOMBuilder.getDocumentElement(StAXOMBuilder.java:566) >> * >> >> * at >> org.apache.synapse.transport.passthru.util.DeferredMessageBuilder.getDocument(DeferredMessageBuilder.java:149) >> * >> >> * at >> org.apache.synapse.transport.passthru.util.RelayUtils.builldMessage(RelayUtils.java:133) >> * >> >> * at >> org.apache.synapse.transport.passthru.util.RelayUtils.buildMessage(RelayUtils.java:98) >> * >> >> * at >> org.apache.synapse.core.axis2.SynapseCallbackReceiver.handleMessage(SynapseCallbackReceiver.java:400) >> * >> >> * at >> org.apache.synapse.core.axis2.SynapseCallbackReceiver.receive(SynapseCallbackReceiver.java:172) >> * >> >> * at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) * >> >> * at >> org.apache.synapse.transport.passthru.ClientWorker.run(ClientWorker.java:247) >> * >> >> * at >> org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) >> * >> >> * at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >> * >> >> * at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >> * >> >> * at java.lang.Thread.run(Thread.java:745) * >> >> *Caused by: com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected >> character 'I' (code 73) in prolog; expected '<' * >> >> *at [row,col {unknown-source}]: [1,1] * >> >> * at >> com.ctc.wstx.sr.StreamScanner.throwUnexpectedChar(StreamScanner.java:639) * >> >> * at >> com.ctc.wstx.sr.BasicStreamReader.nextFromProlog(BasicStreamReader.java:2052) >> * >> >> * at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1134) * >> >> * at >> org.apache.axiom.util.stax.wrapper.XMLStreamReaderWrapper.next(XMLStreamReaderWrapper.java:225) >> * >> >> * at >> org.apache.axiom.util.stax.dialect.DisallowDoctypeDeclStreamReaderWrapper.next(DisallowDoctypeDeclStreamReaderWrapper.java:34) >> * >> >> * at >> org.apache.axiom.om.impl.builder.StAXOMBuilder.parserNext(StAXOMBuilder.java:681) >> * >> >> * at >> org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:214) >> * >> >> * ... 14 more * >> >> >> I have tried the following which do not seem to work in this case: >> >> >> - Redeclare the properties inside the proxy service so that any >> problem because of the properties being out of context inside the proxy is >> resolved. >> - Increase the http.socket.timeout in the >> wso2esb-4.9.0/repository/conf/passthru-http.properties file to a quite >> large value >> - Increase the synapse.global_timeout_interval in >> wso2esb-4.9.0/repository/conf/synapse.properties to 600000. >> - Run the two iterations in the proxies separately which made it >> possible to run up to 150 rows without any exceptions. >> >> The exceptions sometimes seem to reduce when http.socket.timeout was >> increased, but still continue to appear. >> >> What could be done to resolve this issue? Please help. >> >> >> Thank you, >> >> Riyafa >> >> -- >> Riyafa Abdul Hameed >> Software Engineering intern, WSO2 >> >> Email: riy...@wso2.com >> Website: https://riyafa.wordpress.com/ <http://riyafa.wordpress.com/> >> <http://facebook.com/riyafa.ahf> <http://lk.linkedin.com/in/riyafa> >> <http://twitter.com/Riyafa1> >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > > Best Regards, > > Malaka Silva > Senior Tech Lead > M: +94 777 219 791 > Tel : 94 11 214 5345 > Fax :94 11 2145300 > Skype : malaka.sampath.silva > LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 > Blog : http://mrmalakasilva.blogspot.com/ > > WSO2, Inc. > lean . enterprise . middleware > http://www.wso2.com/ > http://www.wso2.com/about/team/malaka-silva/ > <http://wso2.com/about/team/malaka-silva/> > https://store.wso2.com/store/ > > Save a tree -Conserve nature & Save the world for your future. Print this > email only if it is absolutely necessary. > -- Thulasika Associate Software Engineer Mobile:0778014295 email: thulas...@wso2.com <sanj...@wso2.com>
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev