Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
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.
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.