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

Reply via email to