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] <script language="js"> java.lang.Thread.sleep(<INTERVAL>);</script> Thank you On Tue, Dec 8, 2015 at 8:52 PM, Shakila Sivagnanarajah <[email protected]> wrote: > Hi Riyafa, > > This may be caused because of too many requests or due to network issue. I > attach the result here. 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] <script language="js"> java.lang.Thread.sleep(5000);</script> > > Thank you > > On Tue, Dec 8, 2015 at 10:46 AM, Riyafa Abdul Hameed <[email protected]> > wrote: > >> Hi Elilmatha, >> >> It is working without any exceptions for upto 300 rows. >> >> Thanks >> >> On Tue, Dec 8, 2015 at 10:44 AM, Elilmatha Sivanesan <[email protected]> >> wrote: >> >>> 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 <[email protected]> >>> wrote: >>> >>>> [+ Thulasika] >>>> >>>> On Tue, Dec 8, 2015 at 10:26 AM, Riyafa Abdul Hameed <[email protected]> >>>> 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 more than 500 rows. The >>>>> proxy service is attached with this mail. >>>>> >>>>> A sample spreadsheet is at [2] and a sample call is as given below: >>>>> >>>>> { >>>>> >>>>> "accesstoken":"ya29.RAK1F3bpXOp1TxuTg7N96CPFj5d4O1p5dyTCudfXmRTSz7UWK2OzTXmbZ2-_IBfuctb-", >>>>> "key":"1HI9u5PuNxURVapBPSbj_aI_eM3C5NU6p8ftTyHdHW-g", >>>>> "workSheetId":"1", >>>>> "startRowNum":"1", >>>>> "numRows":"500", >>>>> "RetrievecolNum":"1" >>>>> } >>>>> >>>>> >>>>> [1] >>>>> https://docs.google.com/document/d/1z37FzNjo2WHlHZHDyBoMR8zP1_w_WA_qJwz4O3AxEGk/edit >>>>> [2] >>>>> https://docs.google.com/spreadsheets/d/1HI9u5PuNxURVapBPSbj_aI_eM3C5NU6p8ftTyHdHW-g/edit#gid=0 >>>>> >>>>> -- >>>>> Riyafa Abdul Hameed >>>>> Software Engineering intern, WSO2 >>>>> >>>>> Email: [email protected] >>>>> Website: https://riyafa.wordpress.com/ <http://riyafa.wordpress.com/> >>>>> <http://facebook.com/riyafa.ahf> <http://lk.linkedin.com/in/riyafa> >>>>> <http://twitter.com/Riyafa1> >>>>> >>>> >>>> >>>> >>>> -- >>>> Riyafa Abdul Hameed >>>> Software Engineering intern, WSO2 >>>> >>>> Email: [email protected] >>>> 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 >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> *S.Elilmatha* >>> Associate Software Engineer, >>> >>> WSO2 Inc.; http://wso2.com >>> lean.enterprise.middleware >>> >>> Mobile 0779842221. >>> >>> >> >> >> -- >> Riyafa Abdul Hameed >> Software Engineering intern, WSO2 >> >> Email: [email protected] >> Website: https://riyafa.wordpress.com/ <http://riyafa.wordpress.com/> >> <http://facebook.com/riyafa.ahf> <http://lk.linkedin.com/in/riyafa> >> <http://twitter.com/Riyafa1> >> > > > > -- > Shakila Sivagnanarajah > Associate Software Engineer > Mobile :+94 (0) 768 856837 > [email protected] > -- Shakila Sivagnanarajah Associate Software Engineer Mobile :+94 (0) 768 856837 [email protected]
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
