topic Re: BLANK CSV FILE IS STORED INTO ANOTHER SERVER. in QlikView

BLANK CSV FILE IS STORED INTO ANOTHER SERVER.

Icon_Arindam — Sat, 28 Aug 2021 06:03:41 GMT

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

Re: BLANK CSV FILE IS STORED INTO ANOTHER SERVER.

Vegar — Sat, 28 Aug 2021 06:00:56 GMT

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

Re: BLANK CSV FILE IS STORED INTO ANOTHER SERVER.

Icon_Arindam — Sat, 28 Aug 2021 06:44:06 GMT

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.

Re: BLANK CSV FILE IS STORED INTO ANOTHER SERVER.

Icon_Arindam — Sun, 29 Aug 2021 06:37:53 GMT

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.

Re: BLANK CSV FILE IS STORED INTO ANOTHER SERVER.

Vegar — Sun, 29 Aug 2021 11:38:16 GMT

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