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

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”
}

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?

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.

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

little interaction, very high duration

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?

Nope. :frowning:

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

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

1 Like

Yep, that’ll do it… :frowning:

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

1 Like