Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
achampire
Partner - Contributor III
Partner - Contributor III

Random store error with Google Drive connector Saas

Hello guys,

I am facing since the 6th december 2022 a problem with applications using Store instruction on a Google Drive folder.

Everything worked fine until this date. Applications runned hourly without any problems and all my QVDs were generated correcly.

Since the 6th december at 08:00 PM CEST, my reload tend to fail on a random Store instruction. By random, I mean that it is not especially one QVD.

I have 2 types of error thatI am facing

Data has not been loaded. Please correct the error and try loading again.
The following error occurred:
Cannot open file: 'lib://Google drive connector/<idfolder>/accounts.qvd' (Connector error: Error completing job: Object reference not set to an instance of an object.)
The error occurred here:
Store accounts into [lib://Google drive connector/<idfolder>/accounts.qvd] (qvd)
Data has not been loaded. Please correct the error and try loading again.
The following error occurred:
Cannot open file: 'lib://Google drive connector/<idfolder>/projet .qvd' (Connector error: Exception in reading response chunk for upload: Status(StatusCode="Unknown", Detail="Error during upload: Object reference not set to an instance of an object."))
The error occurred here:
Store projet into [Google drive connector/<idfolder>/projet .qvd] (qvd)

 Do you guys have an idea about why do I have this errors? Are you facing the same problem since the 6th december too?

 

Labels (1)
33 Replies
Albert_Candelario

Apologies on my late replay here as was on planned leave.

Thanks for raising the cases for Qlik Support team to work with you.

Cheers,

Albert 

Please, remember to mark the thread as solved once getting the correct answer
korsikov
Partner - Specialist III
Partner - Specialist III

Hello all,

I'm faced with random store error into google drive. Error is not dependent to run time or size of QVD. it's error appear randomly.

adding a 3 second delay (sleep())  before each store did not help solve the problem. I would appreciate any advice or tips

 

 

Data has not been loaded. Please correct the error and try loading again.
The following error occurred:
Cannot open file: 'lib://RBC Group:Google_Drive - support@domain.com/14HwzmOhgjcVjqW3k5nbwmNqT6vJBwT11/UsrIncomeSubtypeList.qvd' (Connector error: Failed on attempt 2 to PATCH. (The remote server returned an error: (410) Gone.))
The error occurred here:
Store	"UsrIncomeSubtypeList"	into	[lib://RBC Group:Google_Drive - support@domain.com/14HwzmOhgjcVjqW3k5nbwmNqT6vJBwT11/UsrIncomeSubtypeList.qvd] (qvd)

. I 

ngrieve
Contributor
Contributor

I am running into this issue now. My colleague and I are trying to use Google Drive and receive this error when getting to the STORE statement. Any update on this?

 

 

Albert_Candelario

Those errors seems to be different from the original one been reported, might be better to open a new post to have better visibility.

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer