Re: [Dev] [ESB][Connector] Google-spreadsheet connctor: Error while building Passthrough stream

2015-12-08 Thread Shakila Sivagnanarajah
Hi Riyafa, This may be caused because of too many requests or due to network issue. Some of the rows are not updated and that calls return 429 unknown status code. The number of failing calls also change time to time. So try with thread sleep in script mediator like [1]. [1]

Re: [Dev] [ESB][Connector] Google-spreadsheet connctor: Error while building Passthrough stream

2015-12-08 Thread Riyafa Abdul Hameed
Hi Shakila, Thank you very much. It worked without any exceptions for 500 rows. Thanks again, Riyafa On Tue, Dec 8, 2015 at 9:09 PM, Shakila Sivagnanarajah wrote: > Hi Riyafa, > > This may be caused because of too many requests or due to network issue. > Some of the rows are

[Dev] [ESB][Connector] Google-spreadsheet connctor: Error while building Passthrough stream

2015-12-07 Thread Riyafa Abdul Hameed
Hi, To be more generic I have created a proxy which fetches a column (the column shouldn't be empty) and updates the same column in an iteration. The two exceptions [1] are thrown when updating more than 500 rows. The proxy service is attached with this mail. A sample spreadsheet is at [2] and

Re: [Dev] [ESB][Connector] Google-spreadsheet connctor: Error while building Passthrough stream

2015-12-07 Thread Riyafa Abdul Hameed
[+ Thulasika] On Tue, Dec 8, 2015 at 10:26 AM, Riyafa Abdul Hameed wrote: > Hi, > > To be more generic I have created a proxy which fetches a column (the > column shouldn't be empty) and updates the same column in an iteration. > The two exceptions [1] are thrown when updating

Re: [Dev] [ESB][Connector] Google-spreadsheet connctor: Error while building Passthrough stream

2015-12-07 Thread Elilmatha Sivanesan
Hi Riyafa , As per the error here you are missing an end tag. org.apache.axiom.om.OMException: com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character 'I' (code 73) in prolog; expected '<' Thanks. On Tue, Dec 8, 2015 at 10:27 AM, Riyafa Abdul Hameed wrote: > [+

Re: [Dev] [ESB][Connector] Google-spreadsheet connctor: Error while building Passthrough stream

2015-12-07 Thread Riyafa Abdul Hameed
Hi Elilmatha, It is working without any exceptions for upto 300 rows. Thanks On Tue, Dec 8, 2015 at 10:44 AM, Elilmatha Sivanesan wrote: > Hi Riyafa , > > As per the error here you are missing an end tag. > > org.apache.axiom.om.OMException: >