Time-out errors and version 49 of chart not working at all

[Hartmut Gunther]

Hello 
Daniel LaLiberte

The web page here  https://www.toxtest.com.au/results/hair-analysis-1-ub.html

contains visualisation of toxicology results using  google charts visualisation engine (v48) . I have been using this method since 2015 (with updates) and no problems. Chart pulls data from https://docs.google.com/spreadsheets/.  

In last few months the amount of time-out errors has steadily and randomly increased with some results on the page refusing to load. I know the page is complex and long but I've never had this problem before. Could you please have a look and let me know if i'm missing something.

ALSO when I try to use v49 - nothing loads at all - very concerning

thanks so much

Hartmut

[Hartmut Gunther]

Also, here is an example of the errors in the web browser javascript console when I use version 49

[Error] XMLHttpRequest cannot load https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet2&headers=1&tq=SELECT%20M,%20N,%20O,%20P,%20Q,%20R,%20S%20where%20BD%20=%22UB%22%20%20limit%201000%20offset%200&tqx=reqId%3A0 due to access control checks.

[Error] Failed to load resource: Origin null is not allowed by Access-Control-Allow-Origin. (tq, line 0)

[Error] Origin null is not allowed by Access-Control-Allow-Origin.

[Error] XMLHttpRequest cannot load https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT%20S,%20%20UB%20%20where%20Q%20=%20%22phosphorus%22%20%20limit%201000%20offset%200&tqx=reqId%3A29 due to access control checks.

[Error] Failed to load resource: Origin null is not allowed by Access-Control-Allow-Origin. (tq, line 0)

[Error] Error: Error handling Query: XhrHttpError: Request Failed, status=0, url=https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet2&headers=1&tq=SELECT M, N, O, P, Q, R, S where BD ="UB"  limit 1000 offset 0&tqx=reqId%3A0

(anonymous function) (jsapi_compiled_default_module.js:251:543)

[Error] Error: Error handling Query: XhrHttpError: Request Failed, status=0, url=https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT S,  UB  where Q = "phosphorus"  limit 1000 offset 0&tqx=reqId%3A29

(anonymous function) (jsapi_compiled_default_module.js:251:543)

[Error] Origin null is not allowed by Access-Control-Allow-Origin.

[Error] XMLHttpRequest cannot load https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT%20S,%20%20UB%20%20where%20Q%20=%20%22antimony%22%20limit%201000%20offset%200&tqx=reqId%3A2 due to access control checks.

[Error] Failed to load resource: Origin null is not allowed by Access-Control-Allow-Origin. (tq, line 0)

[Error] Error: Error handling Query: XhrHttpError: Request Failed, status=0, url=https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT S,  UB  where Q = "antimony" limit 1000 offset 0&tqx=reqId%3A2

(anonymous function) (jsapi_compiled_default_module.js:251:543)

[Error] Origin null is not allowed by Access-Control-Allow-Origin.

thanks

Hartmut

[Hartmut Gunther]

Daniel please also note that the time-out error is random - right now its working fine but this morning all pages similar to https://www.toxtest.com.au/results/hair-analysis-1-ub.html were timing out.

thanks

[Daniel LaLiberte]

Hi Hartmut,

Sorry to hear about your experience, and thanks for your report.  Although I don't understand why the Query requests would timeout sometimes, when using v48, but not consistently all the time, the problem with v49 is understandable since your spreadsheets appear to be using an older version, and a change in v49 to make the requests more secure turns out to fail with the older spreadsheets.  

I have a backward-compatibility fix that will be in the next release, though it will have a different problem with the Edge browser.  Since more errors of this kind are starting to surface now, a couple months after the release of v49, I am inclined to push out this new release relatively soon, perhaps in the next few weeks.

I wonder if the occasional timeout errors are also due to using the older version of spreadsheets, maybe because the servers are getting less attention or more problematic.  You might be able to workaround both problems by creating new spreadsheets and copying the contents from the old spreadsheets.  I don't know if there is a way to upgrade otherwise, but I expect not since the URLs are quite different.  

--
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/67fcd7a2-8a14-4864-9388-ae9f94594540n%40googlegroups.com.

--

Daniel LaLiberte

dlaliberte@Google.com   Cambridge MA

[Hartmut Gunther]

Thanks so much for the reply Daniel.

Just wanted to clarify - you mean to simply make a new spreadsheet within my existing google docs account (and not create a whole new account)

thanks again

Hartmut 

[Daniel LaLiberte]

Yes, starting with a new spreadsheet document, even in the same account, should use the latest version of spreadsheets.  I don't think that happens if you just copy a spreadsheet, however.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/5724efaa-cf30-45fd-868c-e3cd3a0579d8n%40googlegroups.com.

[Hartmut Gunther]

Thanks also for that Daniel.

I have implemented a new spreadsheet as indicated in addition to tidying up the page for any javascript errors and simplifying code significantly. Page speeds up greatly, however still get the load error - mostly on the first time page is loaded - however on subsequent attempts seems fine.

These are the type of errors I get from the javascript console -

[Error] Failed to load resource: the server responded with a status of 429 () (tq, line 0)

[Error] Failed to load resource: the server responded with a status of 429 () (tq, line 0)

[Error] Failed to load resource: the server responded with a status of 429 () (tq, line 0)

[Error] Refused to execute https://docs.google.com/spreadsheets/d/121gNWbe0b67RYplm8_nC2WX1ykyX3PIsbWO1uHnHmbc/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT%20S,%20%20U%20%20where%20Q%20=%20%22sulphur%22%20%20limit%201000%20offset%200&tqx=reqId%3A32 as script because "X-Content-Type-Options: nosniff" was given and its Content-Type is not a script MIME type.

Is it also  possible that these come up due to a slow connection to my server that hosts my website? These errors appear to indicate an exponential backup intervention ?

And finally - When the page works fine and loads fast there is still this last residual error message (from the js console) that I can't seem to find in my code - looks like a google js issue although I'm not sure

Error: Container is not defined - https://www.gstatic.com/charts/48.1/js/jsapi_compiled_default_module.js

Example of recently updated page is here - https://www.toxtest.com.au/results/hair-analysis-2-u.html

Also still can't load above page using v49 at all

thanks Daniel

Hartmut

[Daniel LaLiberte]

The errors you are seeing now are at least unrelated to the query errors you saw before, so that's progress.

The error about the "Container is not defined" is due to creating the chart object when the container element is not yet defined.   I don't see where that is happening in your page, but perhaps that gives you enough of a clue.

The other error about the spreadsheet doesn't make any sense to me.  "Refused to execute" sounds like it might be due to some incompatibility in the query with the new spreadsheet, but that is just a wild guess.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/712f722e-dd44-4210-94c9-0506ab7c95f1n%40googlegroups.com.