Error using Google Drive connector to read or write QVD on Qlik Sense Saas

[nicolett_yuri]

Hello Guys, how are you?

Since yesterday (December 7th) I'm having problems using the Google Drive connector in Qlik Sense Saas. It seems to me that the error is very intermittent, that is, each time it occurs in a different part of my script.

Basically the error message I got is: Connector error: Error completing job: Object reference not set to an instance of an object.

I have already created a new test connection on another google drive, but the problem persists.

The qvds I'm generating or reading are small, no more than 20mb. The process has been running perfectly since January 2022. I also checked Google Drive space, but it is far from full.

Is anyone else experiencing this problem?

[achampire]

Hello @nicolett_yuri 

I am reassured to know that I am not the only one to have this issue.

I wrote a post this morning (https://community.qlik.com/t5/Connectivity-Data-Prep/Random-store-error-with-Google-Drive-connector-...) because I didn't find one which described this problem. It seems that I missed yours.

That said, I have the same problem and also since the 7th December. I wrote 6th december on my post because I have a hourly schedule and it begin to fail at 08:00PM CEST.

On my side I tried to run my script with an empty folder. The problem persists.

If a Qlik Employee read this post or mine, can you please answer about the problem ?

I guess there are not only nicolett_yuri and I to have this issue on Google Drive.

[nicolett_yuri]

Sometimes it's good to find people who are going through the same problem as yours haha

To update, today (December 9th) the reloads ended successfully. What did I do? I didn't do anything, they started working again without any explanation, just like they stopped.

The problem is that I can't tell you if it was a problem in google or in qlik (connector). Who can help us?

[achampire]

It seems that it is an error generated by Google but hard to say if it is link on Qlik connector or Google API itself.

I read other thread on that topic and there is no workaround at the moment. 

Qlik seems to propose a Sleep() intrusction to someone but it continue to fail.

I guess that the only good workaround is to change store location from Google to space's datafiles and wait for a Qlik correction or solution. 

[Albert_Candelario · Accepted solution]

Hello all,

As mentioned let's continue the discussion on Random store error with Google Drive connector Saa... - Qlik Community - 2014703. 

Cheers,

Albert