Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I am facing this weird issue since this week.
I want to store table in csv format from QV server to another server.
Below store commands are storing blank csv file with just column names & blank rows from this last week
STORE TABLE_NAME INTO [\\ServerName\Path\TABLE_NAME.csv](txt);
STORE TABLE_NAME INTO [\\ServerAddress\Path\TABLE_NAME.csv](txt);
But when I tried to store table in same server where QV is installed, I am getting actual output csv file with complete data.
STORE TABLE_NAME INTO [D:\Path\TABLE_NAME.csv](txt);
NOTE:
File size which i want to store is 39 MB.
Enough space is available in both server.
Both servers can be accessible from individual folder path.
Any suggestions are always welcome.
#Qlikview #Issue
Hi Vegar,
I have found the resolution for this issue.
I just rebooted the QV server & then ran my QV file. Now its working as expected.
Thanks for your inputs.
I agree. It is a weird behaviour. I would suspect that the table is empty before you do the store. I would double/tripple check my table and spelling. I would also check that I don't have an old store command later in the script that is overwriting my first store with an empty table. Also make sure that you don't have any other system that is scanning and automatically processes and truncated your data file.
Do you get the same issue if you choose to store to qvd files?
I notice you are storing to csv using (csv) which is not a supported format. Try this instead.
STORE TABLE_NAME INTO [\\ServerAddress\Path\TABLE_NAME.csv] (txt);
Hi Vegar,
Thanks for your quick response.
I have check spelling of table name, also checked no overwrite store statement. Table has data & wrote below statement in QV server.
STORE TABLE_NAME INTO [\\ServerAddress\Path\TABLE_NAME.csv] (txt);
By mistake, I had posted wrong format here.
Hi Vegar,
I have found the resolution for this issue.
I just rebooted the QV server & then ran my QV file. Now its working as expected.
Thanks for your inputs.
That's great! Glad you found a solution to your problem.