Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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)
35 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://RG:Google_Drive - su@domain.com/14HwzmOhgjcVj/UList.qvd' (Connector error: Failed on attempt 2 to PATCH. (The remote server returned an error: (410) Gone.))
The error occurred here:
Store	"UList"	into	[lib://RG:Google_Drive - su@domain.com/14HwzmOhgj/UList.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
julian_rodriguez
Partner - Specialist
Partner - Specialist

Hello @Albert_Candelario 

 

We are facing this error. Google search bring me to here, because I don't know where to find the soluction.

Cannot open file: 'lib://1. QVF Extracción DES:Google_Drive_Premise/1xxxxxxx/xxxxxx.qvd' (Connector error: Exception in reading response chunk for upload: Status(StatusCode="Unknown", Detail="Range header in response was bytes=0-8388607 but last byte sent was 10485759. Connector does not currently handle resending missed data."))

Could you help us please?

Albert_Candelario

Hello @julian_rodriguez,

For this specific, if is still occurring for you, I would advise to raise a Support case with our Support while providing all the relevant information into the case.

Thanks for your collaboration.

Cheers,

Albert

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