Google vis api "request timed out" message

[fu...@globalfundexchange.com]

I published several dozen google api charts ranging from area to bar charts on my website and they have been working fine up until now. It seems that on some computers (not all), I get a request timed out message where my charts should be even after I republish every sheet. Is there something that these computers lack that might be limiting compatibility with the the google api charts? maybe a problem with javascript/ some plugin I am not aware of? it works fine on some computers and does not show up on others.

Thank you for your help

(view the front page under www.globalfundexchange.com/newgfe below "energy fund performance" to see an example)

[asgallant]

I am inclined to say that the problem is likely a slow connection between the client and Google's servers.

[fu...@globalfundexchange.com]

Should not be the case seeing as every computer I tested it from is under the same connection

On Monday, August 19, 2013 11:47:13 AM UTC-4, fu...@globalfundexchange.com wrote:

[asgallant]

Hmm.  Try using Chrome or Firefox's network activity logs to see where the hold up is.

[fu...@globalfundexchange.com]

noy sure what you mean by network activity logs, could you point me to it?

[asgallant]

In Chrome, hit ctrl+shift+j, then go to the "Network" tab.  In FF, hit ctrl+shift+q.

[fu...@globalfundexchange.com]

Alright- Im there now what should I be searching for?

On Monday, August 19, 2013 11:47:13 AM UTC-4, fu...@globalfundexchange.com wrote:

[asgallant]

Once you've opened the network panel, reload the page and watch the requests going out to see which ones are not returning.

[fu...@globalfundexchange.com]

these are the links to the 3 requests not returning:

http://www.globalfundexchange.com/newgfe/index.php?option=com_roksprocket&task=ajax&format=raw&ItemId=101
http://ig.icanfindthis.me:8080/adserver/static/js/inimage_s.js?pid=66&ext_domain=icanfindthis.me&ox_subId=200019822500000000

http://www.globalfundexchange.com/newgfe/templates/rt_oculus/images/logo/dark/logo.png

[asgallant]

The png should not affect anything, and at a guess the second link is for advertising, and so shouldn't affect this.  What does the first one do?

In any event, none of these are the urls of the google spreadsheets, so the connection problem you are having is not related to the queries.

[Eric Schrepel]

We have the same issue though not quite resolved yet. What we discovered with Chrome's Ctrl-Shift-J and watching Network resources is that the Request Timed Out error only happens when a user isn't logged into Google in some way. The Network log shows "ServiceLogin" calls at the bottom which never complete. We open another Chrome tab, have the user log into some Google account, then re-load the page and the Request Timed Out error goes away. Even logging back out of Google and reloading the page then works correctly, so it's something about having logged in once during the session or something.

Any thoughts from anyone about that? You don't have to have a Google account to simply view Google charts, correct? If so, that throws a bit of a wrench in our use of the charts.

[asgallant]

No, you don't require a Google account to view the charts.  Are you pulling any data from a Google service, like Google Docs Spreadsheets or Fusion Tables?

[Eric Schrepel]

Yes, Google Charts based on Google Spreadsheet doc that's publicly viewable/shared. It really is random; only in Chrome or IE do we get the timeout error when a user isn't logged into a Google account. And it's not on every machine in the office. Still troubleshooting.

[johns...@gmail.com]

I am having the same issue here with Google Charts on a website that I am implementing. I get the "Request Timed Out" on all the chart on the site across Safari, Chrome and Firefox.

http://www.gwieastafrica.org/dashboard/

 At the same time that I was viewing the page two other colleagues (one in UK and one in Germany) were able to see the charts. Caches have been cleared on all browsers etc etc. I assume that this must just be something to do with the web connections speed? Needless to say I am less than impressed with the Google Charts, apart from anything else, integrating them with Wordpress has been a nightmare, largely because each time I try to make a change to the charts or the page, Wordpress wraps the charts with datatags, rendering the charts useless.

The charts are also very hard to customise, with long titles and axis names being cropped and figures/data in various chart areas, being displayed unaligned on in the wrong place from the preview.

Disappointing.

[asgallant]

I can't help you with the connection problems or Wordpress interfering with the charts, but the alignment issues are usually caused by one of two things: either the charts are being drawn before the API is done loading, or the charts are being drawn inside hidden divs (hidden divs mess up the API's dimension detection algorithms).  I looked at your code, and the method you are using (Gadget loading) shouldn't result in any loading issues, but you do display the charts inside a tab interface, which is implemented as a series of divs that get hidden and shown when the user clicks on the appropriate headers - this is why the chart alignments are off.  Normally, the way to fix this is to either draw all charts before enabling the tab interface, or draw the charts in a tab the first time the tab is opened.  Gadget loading is incompatible with both of these strategies, however, as there is neither a way to control when the gadgets are drawn, nor is there a way to capture "ready" events from the gadgets to know when it is safe to initialize the tabs.  To fix these problems, you would have to change the way you are creating the charts.

[Rufeng]

Thanks Eric for detailing this issue. I am seeing the same problem on my site i.e. charts timed out if the user isn't logged into Google in some way. 

Charts can be loaded if

• User is signed in to Google
• User is signed out currently, but was signed in previously using this browser

The charts: http://gcdc2013-diyproperty.appspot.com/hdb.html

[asgallant]

The data query is returning the Google login page instead of the query results, which makes the browsers throw an error due to a mime-type mismatch (and, I suspect, the browsers block the bad data from reaching the Query object, causing the timeout).  I tried to access the spreadsheet directly (via https://docs.google.com/spreadsheet/ccc?key=0ArgBv2Jut0VxdEZXaFNxaVM3RUpSa3hiMFRUcmVJc2c&gid=0), and I can't view it without logging in from Chrome or IE. Google Docs is letting me view it without logging in if I use Firefox or Opera. This is definitely a problem on the Google Docs end of things and not on the Visualization API end.

[Hissashi Rocha]

I'm facing the same problem.

Is there any news on this matter since the last comment (2013)? Or the solution is to stop importing data from google spreadsheets?

[Eric Schrepel]

Never did get a decent answer to that, so we use a CSV loader to pull in CSVs from our own site for use in any Google Maps or visualization charts. Not the best answer, but still ran across timeouts, login/logout things affecting chart loading, etc.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/o2Okyr5vK3E/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/a7aa005e-0011-4352-8322-34a87fa3ed22%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.