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

QlikSense Problem with Folderconnection

Hi - I'm having the darndest time with a folder connection.

 

I've connected the folder.

 

I'm trying to STORE the contents of a table into the *qvd file.

 

Everyone has write permissions to the folder behind the \\FolderConnection data connection.

 

Attached is a screen shot.

Connection Definition and FailureConnection Definition and Failure

 

 

 

Labels (2)
1 Solution

Accepted Solutions
jomamma1
Contributor III
Contributor III
Author

Found it!

 

I had to go into the QMC

 

Take off the uswin_v374914 that was being appended to the FolderConnection name.

 

I'm not sure HOW it got appended there (other than uswin_v374914) is my user id - but what a nuisance.

 

Thanks for the help out there.

 

View solution in original post

14 Replies
chriscammers
Partner - Specialist
Partner - Specialist

If you cannot rename it you do need to include the part in parenthesis after the name.

 

Usually the only way to remove that suffix it to remove it in the QMC

dplr-rn
Partner - Master III
Partner - Master III

can you share the relevant part of the script?
jomamma1
Contributor III
Contributor III
Author

this is all the script is doing ...

 

LIB CONNECT TO 'OneReporting_DB (uswin_v374914)';
ItamDeviceView:
SQL select top 10 *  from itam_reporting.reporting.vw_itamdevice;
Store ItamDeviceView into 'lib://FolderConnection/ItamDeviceView.qvd'

 

 

 

dplr-rn
Partner - Master III
Partner - Master III

Are you missing a ';'
in the picture on your original post i see a unquality below it
chriscammers
Partner - Specialist
Partner - Specialist

Try this...

Store ItamDeviceView into [lib://FolderConnection(uswin_v374914)/ItamDeviceView.qvd](qvd)

 

There may be a space before the parenthesis but I'm not sure

 

jomamma1
Contributor III
Contributor III
Author

Same error with the semi-colon ...

 

LIB CONNECT TO 'OneReporting_DB (uswin_v374914)';
ItamDeviceView:
SQL select top 10 * from itam_reporting.reporting.vw_itamdevice;
Store ItamDeviceView into 'lib://FolderConnection/ItamDeviceView.qvd';

 

dplr-rn
Partner - Master III
Partner - Master III

is this folder on your machine or network?

jomamma1
Contributor III
Contributor III
Author

*FileConnector | Data load editor - Qlik Sense

The following error occurred:
Connection not found: FolderConnection(uswin_v374914)
 
The error occurred here:
Store ItamDeviceView into [lib://FolderConnection(uswin_v374914)/ItamDeviceView.qvd](qvd)
 
Data has not been loaded. Please correct the error and try loading again.
jomamma1
Contributor III
Contributor III
Author

Local machine  .. d: drive if that matters