QVSource random Field not found error

[Anonymous]

Hi,

I'm using QVsource web edition to extract some data from a google spreadsheet, but I'm keeping getting the message Field not found randomly. When the message is triggered, I try to load the data from the Connector --> Get Spreasheet option and no errors are returned, I have also tried to load the url from the load statement in my browser and no error is being returned. As I said before this happens sometimes, there are other times in which content is reloaded with no issues. Have anybody had this type of issue before?

Thank you in advance for your comments.

Regards,

--Karla

[chrisbrain]

Hi,

If you check the QVSource logs do you see some 429 errors?

If so this is likely a new issue which appears to be due to a recent change to Google's API which means they now throttle repeated requests to the API more strictly.

Unfortunately this is out of our control but in the next release (contact support if you would like to try this out now) we have put in some additional wait and retry logic to attempt to avoid this error bubbling up to QlikView/Qlik Sense.

The workaround in the interim appears to be to simply introduce sleeps into your load script between requests to this table, perhaps start at 5s and if you still get the error increase up to about 10s.

[Anonymous]

Hi Brian,

I have checked the log files as you suggested, and yes it's returning error 429. We will try to add a sleep time as you say.

Thank you for your help.

Regards,

--Karla