Query - google sheet - exception: the coordinates or dimensions of the range are invalid

  • 38Views
  • Last Post 19 March 2019
0
votes
Stew Stremel posted this 14 March 2019

I have a fairly large query (19k rows) that used to run successfully but is now returning with "exception: the coordinates or dimensions of the range are invalid".  The query runs fine inside of skyvia and I am able to do a full download to csv from here so it seems to be only inside of google-sheets.  I deleted the sheet and created a clean/blank sheet with the same results.

Order By: Standard | Newest | Votes
0
votes
Alex Burdine posted this 15 March 2019

I'd try accessing the query through the "Gallery" and then running it through the "edit" sql function. I've had problems for weeks now and was able to hack my way around it by going through those steps rather than "refresh sheet".

I can't even do that anymore. The Google Sheet functionality is broken from what they tell me and will take time to repair.

0
votes
Stew Stremel posted this 15 March 2019

Agree - even through the gallery it still breaks (works maybe one time out of ten).

0
votes
Mariia Zaharova posted this 19 March 2019

"exception: the coordinates or dimensions of the range are invalid"

This issue is fixed. Please try your scenario again and let us know the results.

0
votes
Stew Stremel posted this 19 March 2019

No error message - but - I only get a couple hundred records where I expect to get 18k.

Close