topic Save as QVD in Connectivity & Data Prep

Save as QVD

tpaulSQL — Tue, 28 Dec 2021 20:12:24 GMT

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.

Below is the connector.

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

Re: Save as QVD

PrashantSangle — Fri, 29 Mar 2019 12:29:26 GMT

remove ' single quote and try.

Re: Save as QVD

tpaulSQL — Fri, 29 Mar 2019 12:33:02 GMT

I got the same error.

-Thomas

Re: Save as QVD

pradosh_thakur — Fri, 29 Mar 2019 12:40:46 GMT

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

Re: Save as QVD

tpaulSQL — Fri, 29 Mar 2019 12:44:54 GMT

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

Re: Save as QVD

tpaulSQL — Fri, 29 Mar 2019 13:21:01 GMT

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

Re: Save as QVD

tpaulSQL — Fri, 29 Mar 2019 14:32:42 GMT

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.