Insufficient quota to proceed (503) errors when using GData APIs and Data Feed Query Explorer

[Tom Collier]

Starting over the weekend, all of my app's calls to the GData APIs for Google Analytics result in an "Insufficient quota to proceed" error message. Additionally, when I use the Data Feed Query Explorer to pull down any data, the "Get Data" button appears unresponsive. When I open up the JS console on my browser, though, I see that clicking the button does issue an HTTP request, but the response has a "Insufficient quota to proceed" error message.

In my app, the URL that I use to request data has the parameter "key=<API_key>" (with my actual sever key value of course), but my Google API console (https://code.google.com/apis/console) reports zero usage for that key. For example, my URLs (with sensitive data snipped out) look like:

https://www.google.com/analytics/feeds/data?ids=ga%3A<snip>&metrics=ga%3AuniquePageviews&start-date=2012-01-23&end-date=2012-02-06&max-results=50&key=<snip>

Our app uses Google Analytics data in a way that is critical to our core users. 

Note: I have posted an issue with the same symptoms before on Feb 6 (https://groups.google.com/forum/#!msg/google-analytics-data-export-api/ISc91eYk5-c/51v3i6Q2ZAEJ). Last time the resolution was to create a new API key, but that did not solve the problem this time.

[Tom Collier]

This appears to be functioning properly again.

[Tom Collier]

And now it's broken again. Anyone else have a similar issue?

It's only specific Google Analytics profiles that give me this error. Most other profiles return data successfully.

[anup tilak]

Might be Query looping is happening....

Please check the GA query in query explorer....

Thanks & Regards
Anup Tilak
Web Developer,
Cell: +91- 99235-07463

On Tue, Apr 3, 2012 at 10:31 PM, Tom Collier <tcol...@gmail.com> wrote:

And now it's broken again. Anyone else have a similar issue?

It's only specific Google Analytics profiles that give me this error. Most other profiles return data successfully.

--
You received this message because you are subscribed to the Google Groups "GA Data Export API" group.

To view this discussion on the web visit https://groups.google.com/d/msg/google-analytics-data-export-api/-/4Od_Z12G5i8J.

To post to this group, send email to google-analytics...@googlegroups.com.
To unsubscribe from this group, send email to google-analytics-data-...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-analytics-data-export-api?hl=en.

[Tom Collier]

Hi Anup,

Thanks for the response. I'm not sure what you mean by "query looping". If are are suggesting the the code that queries the data API is looping and hitting the API too much, I can assure you that is not the case. The job that my app runs to make the data API requests has not changed in months and it has worked fine for a long time.

Also, as I mentioned in the original post, I have run the Data Feed Query Explorer (http://code.google.com/apis/analytics/docs/gdata/gdataExplorer.html). The result was that no data is returned, not even an error message. As a result, I opened up the JavaScript console and saw the error "self.showSampled is not a function: ga-explorer.js (line 632)" and set a well-placed breakpoint to see the query was returning a similar error (see below) that I saw in my app. This error is only generated for one specific profile; the same query against other profiles return the data expected.

Error from Query Explorer: 

Error: <errors xmlns='http://schemas.google.com/g/2005'><error><domain>GData</domain><code>rateLimitExceeded</code><internalReason>Insufficient quota to proceed.</internalReason></error></errors>

  -Tom

[Nick]

Hi,

Do you have any more info about what you are trying to query from the API or if other people in your organization is accessing the same profile?

Generally if you hit the rateLimit, then you need to reduce the number of requests you are making to our API at a given time.

-Nick

[Tom Collier]

Hi Nick,

I am trying to pull uniquePageviews for about 1,000 pages that match a certain filter and timeOnPage for about 10,000 pages that match a different filter. All requests are paginated into pages with 100 results each. I see this error on the very first request, though.

Only a handful of employees have access to that profile and I doubt more than 2 or 3 ever access the Analytics website (http://www.google.com/analytics) simultaneously. None have reported getting a similar error and I can access the profile via the Analytics website even when my app fails.

  -Tom

[Nick]

ok, feel free to send me the profile ID that this is happening to and we can look into it.

-Nick

[Tom Collier]

Property ID: UA-11685477-3

Profile ID: 25831756

Thanks!

[Nick]

Quickly looking, it looks like you're using an old version of our API.

Do you mind switching to our new backwards compatible version?

All you need to do is

Switch the base URL

from: https://www.google.com/analytics/feeds/data

to: https://www.googleapis.com/analytics/v2.4/data

Then register in the Google APIs console: https://code.google.com/apis/console/

Under API access, you'll find an API key. This needs to appended as a "key" query parameter to all our API requests

ie ?key=xxx where xxx is from the console.

Everybody using the older version of the API will have to do this within a couple of months, or switch entirely over to the latest version 3.

-Nick

[Tom Collier]

I'm using an older client library that only supports the old API. However after some fiddling around it looks like your suggestion fixes my issues. I'll look into using a more modern client library.

Thanks, Nick!