BLANK CSV FILE IS STORED INTO ANOTHER SERVER.

[Icon_Arindam]

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

[Vegar]

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);

[Icon_Arindam]

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.

[Icon_Arindam · Accepted solution]

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.

[Vegar]

That's great! Glad you found a solution to your problem.