Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
wigli
Contributor
Contributor

Connection not found (folder)

Hi, could anybody give me some glue for this error?

Connection not found: TestyMS(..): Store [TableName] into 'lib://TestyMS(..)/TableName.qvd' (qvd)

I have folder D:\QlikSense\TestyMS on Qlik server

and connection TestyMS in DataConnections , where i have chosen folder D:\QlikSense\TestyMS

Thank you in advance.

 

1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Hi Wigli,

I understand, but by loading it in, you will get the right store path.

Then you can use this path:

FROM [lib://TestyMS/TMPPayables_Receivables.qvd](qvd);

And transform it into:

STORE [TMPPayables_Receivables] INTO [lib://TestyMS/TMPPayables_Receivables.qvd](qvd);

It can also be that your table can't be found.

Jordy

Climber

Work smarter, not harder

View solution in original post

5 Replies
JordyWegman
Partner - Master
Partner - Master

Hi Wigli,

Try to create another connection and load a file from this connection. Then use this string for you original load. This will fix the problem.

Jordy

Climber

Work smarter, not harder
wigli
Contributor
Contributor
Author

Thank you

I don't understand, I want store not load file.

My command:

Store [TMPPayables_Receivables] into 'lib://TestyMS/TMPPayables_Receivables.qvd' (qvd);

JordyWegman
Partner - Master
Partner - Master

Hi Wigli,

I understand, but by loading it in, you will get the right store path.

Then you can use this path:

FROM [lib://TestyMS/TMPPayables_Receivables.qvd](qvd);

And transform it into:

STORE [TMPPayables_Receivables] INTO [lib://TestyMS/TMPPayables_Receivables.qvd](qvd);

It can also be that your table can't be found.

Jordy

Climber

Work smarter, not harder
wigli
Contributor
Contributor
Author

It works. 

But my folder was empty , then I had to copy some file in it.

Then I loaded this file in  Data Load editor and I gave longer path: 

[lib://TestyMS ( sth like user)/TMPPayables_Receivables.qvd] 

which i used in store command.

Thank you very much.

 

JordyWegman
Partner - Master
Partner - Master

Great, please mark the post as solved!

Jordy

Climber

Work smarter, not harder