When loading a chart, google charts shows me a message: Error in query: Request timed out

300 views
Skip to first unread message

Orlando Canchola

unread,
Jul 24, 2020, 11:20:08 AM7/24/20
to Google Visualization API
Before I could load charts without that message, I didn't change anything in my code. The link to my spreadsheet is:
 

Please tell me, why I am getting that message?

Jim West

unread,
Jul 27, 2020, 9:21:17 AM7/27/20
to Google Visualization API

I am seeing the same problem with my Google Map application.
I have not changed anything in my application 2  weeks, but the "Error in Query" problem just started appearing in the last 2 days.
When I attempt to display my Google Map, there is a long delay, and then the message "Error in Query".
I have to click on the Error in Query message to see my Google Map.
I have attached a file, "WyRow.html" to this message containing an example of this problem.
I created a Google Map Support request and was told that this was a Google Chart problem outside their support area.
I am not aware of using Google Chart in my html code. 
Please explain what I can to do fix this problem.  There is a very long delay in display my Google Map.
Google Map Support has sent me to your forum. 
Has anything changed in a google library over the weekend to cause this problem ??

Thanks,
Jim West
WyRow.html

Daniel LaLiberte

unread,
Jul 27, 2020, 10:49:44 AM7/27/20
to Google Visualization API
I believe the general problem with the timed-out Query calls that are happening in the latest version (v49) is that the original spreadsheet URL is being redirected to another server but the redirect is not done in a way that works.  I've seen this happen in a couple different cases already, and I suspect other cases are similar.   

So if this is the case, you can work around this problem by looking in your browser's debugger to see what the URL is redirecting to, and then use that new URL directly.   

If this is not the case, then please post (or send me) a link to a page that demonstrates the problem you are seeing.

I hope that helps.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/618e60e7-29dc-48a8-abfe-e365ed561a70o%40googlegroups.com.


--

Avadhoot Dandekar

unread,
Jul 29, 2020, 6:46:50 AM7/29/20
to Google Visualization API
Hey Daniel,

Even today when you try a case that is explained in the Miscellaneous Examples here:


also throws the same "Request Timed Out" error. You can yourself check this now. This problem started only from the last 5-6 days. Till then all queries were working fine. Any thoughts on this? Please. Thanks.  

Joseph Janos

unread,
Jul 29, 2020, 7:06:21 AM7/29/20
to Google Visualization API
I repost this from a MS-Edge speciffic thread.

I experience this problem in a Chrome browser, on Ubuntu.

The query I use is from the Google guide:

As the spreadsheets are served by Google servers, we can assume that the server-side setup is correct. (And the browser is correct.)

And if I replace in the loader 'current' with '47', everything works correctly.

All this points to a v49 regression bug.

Hope this helps
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.

Avadhoot Dandekar

unread,
Jul 29, 2020, 1:42:18 PM7/29/20
to Google Visualization API
Hi Daniel,

Thank you for the response. I tried with the redirect workaround as you suggested but it does not help. It gives the same "Request Timed Out" error. I am sharing the below query, if you could please look into the same and help:
----------------------------------------------------------------------------
<!DOCTYPE html>
<html>
<head>
<style>
#f2dj__table table {
    font-size: 12pt;
    font-weight:bold;
}
#f2dj__table th {
    background: orange;
}
</style>
<script src="https://www.gstatic.com/charts/loader.js" type="text/javascript"></script><script type="text/javascript">
var f2dj_sskey='1gOEU8Oo9rPznYHIEkSSOpH0CyUqnvOVeDQTpBo1ERv0'
var f2dj_sheet=752311914
var f2dj_authkey='CITwr80K'
google.charts.load('current', {'packages' : ['table']});
//google.load('visualization', '1', {'packages':['table']});
function f2dj_getData(){
  var q='select A,C,D,E'
  var query = new google.visualization.Query(url);
  query.send(f2dj_displayTable);
}

function f2dj_displayTable(response){
if (response.isError()) {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
      }
    
      var data = response.getDataTable();
      visualization = new google.visualization.Table(document.getElementById('f2dj__table'));
      visualization.draw(data, null);   

     var table = new google.visualization.Table(document.getElementById('f2dj__table'));

     var formatter = new google.visualization.ColorFormat();
     formatter.addRange(-20000, -0, 'white', '#e74c3c');
     formatter.addRange(0, 20000, 'white', '#27ae60');
     formatter.format(data, 3); // Apply formatter to second column  

     table.draw(data, {allowHtml: true, showRowNumber: true, width:'100%', height:'100%' });
}     

//google.setOnLoadCallback(f2dj_getData)
google.charts.setOnLoadCallback(f2dj_getData)
</script>
</head>
<body>
<div id="f2dj__table">
</div>
<!-- END: f1dj Google Spreadsheet/viz api table insert -->
</body>
</html>
-----------------------------------------------------------------------------
I am just sharing one query. All these were working perfectly fine till 5-6 days before. Only now they are throwing the "Request Timed Out" error. Request you to please look into the same. Thanks.

Chris Rot

unread,
Aug 8, 2020, 4:33:00 AM8/8/20
to Google Visualization API
I'm using Google orgchart since late 2013 and it worked fine to display a hierarchical spreadsheet in orgchart/tree format until maybe 2 weeks ago. 
Here the html/css/js how it originally worked:  https://tree.j2-m172.info/pf5197/ or the older code with more comments and links:  https://tree.j2-m172.info/ with the line: 
google.load('visualization', '1', {'packages' : ['orgchart']});

I tried here https://codepen.io/ChrisRgen/pen/MWyYdjy to switch to the seemingly new loading as explained on https://developers.google.com/chart/interactive/docs/gallery/orgchart  
google.charts.load('current', {packages:["orgchart"]});  
then changed to 48 and 47 and booth seem to work so far
google.charts.load('48', {packages:["orgchart"]}); 

Please mind that I can not code JS or any script/programming language by myself. I was just able to change and adjust online samples code so that it worked ;-)
So is the solution to stick to loading v48? 
 

Daniel LaLiberte

unread,
Aug 8, 2020, 1:45:43 PM8/8/20
to Google Visualization API
Hi Chris,

The problem is most likely that your spreadsheet URL is redirected to a new URL that you should use instead.  You should be able to see the redirect in your browser's debugger, when using Google Charts version 49.  Unfortunately, the redirect loses security information that is now relied upon.  Earlier versions of Google Charts still work with the older spreadsheet URLs, for now, but we may eventually phase them out due to these same security concerns, and they will probably fail with MS Edge as well.

The next release of Google Charts will have a workaround for these older URLs so it works in most browsers, but again, users of MS Edge will still not be supported.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/59688d5f-0890-450a-b66b-13c2bbec4a33n%40googlegroups.com.

Chris Rot

unread,
Aug 10, 2020, 7:51:26 AM8/10/20
to Google Visualization API
Thanks Daniel. So I'm working on  https://tree.j2-m172.info/pf5197/  to bring to the current version (49). Before the spreadsheet URL was loaded like this: 
var dataSourceUrl = 'https://spreadsheets.google.com/tq?key=0AtajLqik04ZAdE80a21aR2doOGZYZ2dBdlR2V1J4d0E&gid=0&transpose=0&headers=1';
With looking into Inspect > Console and at the Google Spreadsheet Link + https://developers.google.com/chart/interactive/docs/spreadsheets I edited to this which worked together: 
google.charts.load('current', {packages:["orgchart"]});
Reply all
Reply to author
Forward
0 new messages