Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tpaulSQL
Contributor II
Contributor II

Save as QVD

Hello all!

 

I'm new to Qlik Sense community (and Qlik Sense).

I am trying to save the results of a SQL query into a QVD.

My query runs successfully but returns following error when saving to QVD. 

StoreQVD_ErrorMessage.PNG

Below is the connector.

StoreQVD_FolderConnector.PNG

 

 

The store statement I am using is...

Store BoxWO into ['lib://PE_tpaul_folder (na_tpaul9)/BoxWO.qvd'] (qvd);

 

Any help is greatly appreciated,

Thomas

Labels (1)
1 Solution

Accepted Solutions
tpaulSQL
Contributor II
Contributor II
Author

I have found the issue. Qlik cannot write to that network due to security permissions. I decided to write to a different location. Thanks everyone for the quick responses and help.

View solution in original post

6 Replies
PrashantSangle

remove ' single quote and try.
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
tpaulSQL
Contributor II
Contributor II
Author

I got the same error.StoreQVD_ErrorMessage2.PNG

-Thomas

pradosh_thakur
Master II
Master II

Store BoxWO into 'lib://PE_tpaul_folder (na_tpaul9)/BoxWO.qvd'  (qvd);

Learning never stops.
tpaulSQL
Contributor II
Contributor II
Author

Same error.

The following error occurred:
Cannot open file: 'lib://PE_tpaul_folder (na_tpaul9)/BoxWO.qvd'
 
The error occurred here:
Store BoxWO into 'lib://PE_tpaul_folder (na_tpaul9)/BoxWO.qvd' (qvd)
 
On another note, I have used this connection to access files in that location, so I know that QS Server can access the location.
 
-Thomas
tpaulSQL
Contributor II
Contributor II
Author

Correction, I have loaded data from this location in the past. I have never tried to write to this location before.
tpaulSQL
Contributor II
Contributor II
Author

I have found the issue. Qlik cannot write to that network due to security permissions. I decided to write to a different location. Thanks everyone for the quick responses and help.