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

  • 24Views
  • Last Post 2 hours ago
0
votes
Stew Stremel posted this 4 days ago

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 4 days ago

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 4 days ago

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

0
votes
Mariia Zaharova posted this 4 hours ago

"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 2 hours ago

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

Close