Hi, My use case is I get the column of project keys from a google-spreadsheet [1] and iterate through the project keys. Using the project key I query the salesforce using the salesforce connector and obtain the invoice number. Then using the invoice number I find the invoice from. I use the google spreadsheet connector to get the cell which is to be updated--this is to get the cell version. Then I update the relevant cell with the invoice from.
Then in a different second iterator I get a different column and repeat the procedure mentioned above to perform some more filtering. I need to update upto 6000 lines. As for logging I logged the *org.apache.synapse.core.axis2.SynapseCallbackReceiver *and obtained the following result which gives no valuable indication: *[2015-12-07 12:36:22,755] DEBUG - SynapseCallbackReceiver Synapse received an asynchronous response message * *[2015-12-07 12:36:22,755] DEBUG - SynapseCallbackReceiver Received To: null * *[2015-12-07 12:36:22,755] DEBUG - SynapseCallbackReceiver SOAPAction: * *[2015-12-07 12:36:22,755] DEBUG - SynapseCallbackReceiver WSA-Action: * *[2015-12-07 12:36:22,755] DEBUG - SynapseCallbackReceiver Body : * *<?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ <http://schemas.xmlsoap.org/soap/envelope/>"><soapenv:Body/></soapenv:Envelope> * *[2015-12-07 12:36:22,756] DEBUG - SynapseCallbackReceiver FORCE_ERROR_ON_SOAP_FAULT is true, checking for SOAPFault * *[2015-12-07 12:36:22,758] 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 12:36:44,523] DEBUG - SynapseCallbackReceiver Synapse received an asynchronous response message * *[2015-12-07 12:39:19,702] DEBUG - SynapseCallbackReceiver Received To: null * *[2015-12-07 12:39:19,702] DEBUG - SynapseCallbackReceiver SOAPAction: * *[2015-12-07 12:39:19,702] DEBUG - SynapseCallbackReceiver WSA-Action: * *[2015-12-07 12:39:19,702] DEBUG - SynapseCallbackReceiver Body : * *<?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ <http://schemas.xmlsoap.org/soap/envelope/>"><soapenv:Body/></soapenv:Envelope> * *[2015-12-07 12:39:19,702] DEBUG - SynapseCallbackReceiver FORCE_ERROR_ON_SOAP_FAULT is true, checking for SOAPFault * *[2015-12-07 12:36:44,520] DEBUG - SynapseCallbackReceiver Callback added. Total callbacks waiting for : 165 * *[2015-12-07 12:36:44,518] DEBUG - SynapseCallbackReceiver Callback added. Total callbacks waiting for : 164 * *[2015-12-07 12:36:44,500] DEBUG - SynapseCallbackReceiver Callback removed for request message id : urn:uuid:1275435f-896e-4ab1-93f5-3dffa4310215. Pending callbacks count : 162 * *[2015-12-07 12:36:44,498] 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 * Thank you, Riyafa [1] https://docs.google.com/spreadsheets/d/1YsXYQsaBbuOIgUzF-bflZceEPT-4_3J6PNQWp1UjYqc/edit#gid=147342676&vpid=A1 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. > -- 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
