Re: Error: Resource has been exhausted (e.g. check...

Rustam · 06-19-2019 08:58 PM

Explain what this error is and how to avoid it.
Error:
"Unable to add / edit / delete row in table ‘Photo Preview’. → Google.Apis.Requests.RequestError \ r \ nResource has been exhausted (eg check quota). [429] \ r \ nErrors [\ r \ n \ tMessage [Resource has been exhausted (eg check quota).] Location Reason [rateLimitExceeded] Domain [global] \ r \ n] \ r \ n "

Properties:
{
“IfModifiedSinceDate”: “2019-06-19T10:31:13.1841712Z”,
“settings”: “{”_RowNumber":“0”,"_EMAIL":"","_NAME":"","_LOCATION":"",“Options Heading”:"",“Option 1”:"",“Option 2”:"",“Country Option”:"",“Language Option”:"",“Option 5”:"",“Option 6”:"",“Option 7”:"",“Option 8”:"",“Option 9”:"","_THISUSER":“onlyvalue”}",
“getAllTables”: “true”,
“checkLocation”: “true”,
“isPreview”: “false”,
“apiLevel”: “2”,
“tzOffset”: “-180”,
“locale”: “ru-RU”,
“tableTimestamps[_Per User Settings]”: “2019-06-19T13:03:23.9021207Z”,
“tableTimestamps[Машины]”: “2019-06-19T13:03:23.9041165Z”,
“tableTimestamps[Фотоосмотр]”: “2019-06-19T13:03:23.9041165Z”,
“tableTimestamps[менеджеры]”: “2019-06-19T13:03:24.7141416Z”,
“tableTimestamps[Партнеры]”: “2019-06-19T13:03:25.2771633Z”,
“lastSyncTime”: “2019-06-19T13:03:26.6712163Z”,
“appStartTime”: “2019-06-19T11:30:31.116Z”,
“dataStamp”: “2019-06-19T13:03:26.6712163Z”,
“clientId”: “57c49a34-df79-4c8c-b0a3-1450c3208083”,
“build”: “a0dda2a3595730fb4509-1560899653458-030cb2210c”,
“hasValidPlan”: “false”,
“localVersion”: “1.000020”,
“AppTemplateName”: “1b379e83-7a9c-4a95-9e48-b42cd8a937ef”,
“Operation”: “App sync”,
“RecordType”: “Stop”,
“AppTemplateVersion”: “”,
“AppDefinitionChanged”: true,
“Performance”: “{“Version”:1,“Time”:“00:05:20.0475688”,“PerformanceTimingRoot”:{“Mid”:130,“Timer”:{“Time”:“00:05:20.0475688”},“Children”:[{“Mid”:63,“Timer”:{“Time”:“00:05:20.0320304”},“Children”:[{“Mid”:62,“Timer”:{“Time”:“00:00:00.0299455”}},{“Mid”:244,“Timer”:{“Time”:“00:00:00.0190946”}},{“Mid”:155,“Timer”:{“Time”:“00:00:00.0064415”}},{“Mid”:117,“Params”:{“ParamList”:[{“Pid”:5,“Value”:“2”}]},“Timer”:{“Time”:“00:05:19.9600420”},“Children”:[{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Фотоосмотр”},{“Pid”:21,“Value”:“01.31.03.698112”}]},“Timer”:{“Time”:“00:04:50.6945060”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:04:50.6942194”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Фотоосмотр”}]},“Timer”:{“Time”:“00:04:50.6942063”},“Children”:[{“Mid”:28,“Timer”:{“Time”:“00:00:00.3728052”},“Children”:[{“Mid”:25,“Timer”:{“Time”:“00:00:00.3696334”}}]},{“Mid”:33,“Timer”:{“Time”:“00:04:50.3206907”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:04:50.3206489”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:02:27.9983955”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:02:27.9983529”}}]},{“Mid”:238,“Timer”:{“Time”:“00:02:22.3222237”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:02:22.3222119”}}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Машины”},{“Pid”:21,“Value”:“01.31.03.698112”}]},“Timer”:{“Time”:“00:05:19.9592359”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:05:19.9592238”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Машины”}]},“Timer”:{“Time”:“00:05:19.9592148”},“Children”:[{“Mid”:28,“Timer”:{“Time”:“00:00:00.0084325”},“Children”:},{“Mid”:33,“Timer”:{“Time”:“00:05:19.9501067”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:05:19.9500884”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:05:19.9500551”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:05:19.9500171”}}]}]}]}]}]}]}]}]}]},“IsEmpty”:false}”,
“Result”: “Failure”
}

Aleksi

Normally the “Quota” error means that there has been too many requests at the same time. Do you have lot of users using the app at the same time?

Rustam

at the time of the error, only 2 users used the application according to statistics. Therefore, I do not understand where this error comes from. Could it be that someone from the users on the device has a virus that makes many requests without his knowledge? but then it would be reflected in the statistics of your system, but it is not.

Aleksi

When you check the Audit history, do you see lot of interactions at that time?

Rustam

little interaction, very high duration

Kyle_Grieb

I am experiencing the same issue. I have a log of multiple users attempting to sync but unable to do so do to
"Unable to add/edit/delete row in table 'Info'. → {\"error_summary\": \"too_many_requests/..\", \"error\": {\"reason\": {\".tag\": \"too_many_requests\"}, \"retry_after\": 15}}"
Is there a way to pause/queue syncs from users as an administrative control, so that I may force the clients to sync one-by-one?

Steve

Nope.

If you haven’t already done so, I encourage you to engage support@appsheet.com for help with this.

Kyle_Grieb

Fixed the issue by closing my “Excel for the web” browser tab for Dropbox edit.

Steve

Yep, that’ll do it…

Koichi_Tsuji

Look another practical example of the case, Excel + Appsheet is not good combination.

Ses_Puipplesdil

This always rages me out

Error: Resource has been exhausted (e.g. check quota)