Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
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