topic Re: keep old data when reload fail in QlikView

keep old data when reload fail

Thu, 30 Apr 2015 15:58:54 GMT

Hello,

is it possible to keep opld data when reload fail ?

thks

Re: keep old data when reload fail

Anonymous — Thu, 30 Apr 2015 15:59:54 GMT

If reload fails, the old data is kept.

Re: keep old data when reload fail

Thu, 30 Apr 2015 16:01:54 GMT

I'd also set 'Save Before Reload' in 'Settings > User Pref' so you don't loose any work!

Re: keep old data when reload fail

buzzy996 — Thu, 30 Apr 2015 16:04:18 GMT

even ur job fails,still ur old data with ur app.

Re: keep old data when reload fail

Thu, 30 Apr 2015 16:09:14 GMT

I asked my question wrong in fact I want to test the presence of a file if I see I reload table else I want to get out of the script without lose old data.

Re: keep old data when reload fail

Thu, 30 Apr 2015 16:09:52 GMT

I asked my question wrong in fact I want to test the presence of a file if I see I reload table else I want to get out of the script without lose old data.

Re: keep old data when reload fail

Thu, 30 Apr 2015 16:10:31 GMT

Michael, I asked my question wrong in fact I want to test the presence of a file if I see I reload table else I want to get out of the script without lose old data.

thks

Re: keep old data when reload fail

Thu, 30 Apr 2015 16:12:40 GMT

If the error is not critical (like a table not found), then the script asks you if you want to "continue" or just cancel. The script will continue executing but obviously you can lose some data.

If the error is critical, then it will fail automatically and you will recover the old data.

Re: keep old data when reload fail

Thu, 30 Apr 2015 16:16:33 GMT

the best way to test the presence of a file is to comment the rest of the script, and after this file add something wrong that will fail the script. Then, when the script is executing just look at the script windows in order to see if your file is loaded or not. Because of the failure of the script, you will be sure that you don't lose data.

Re: keep old data when reload fail

Thu, 30 Apr 2015 16:16:43 GMT

I launch the script with the server not in desktop, so i just want to get out of the script when the file is missing

Re: keep old data when reload fail

Thu, 30 Apr 2015 16:18:30 GMT

Ok, then the only suggestion would be to look at the log file.

Re: keep old data when reload fail

Anonymous — Thu, 30 Apr 2015 16:20:37 GMT

If the file is missing, the reload task will fail, there will be no changes in your QVW file, you're not losing any data.

Re: keep old data when reload fail

Thu, 30 Apr 2015 16:22:58 GMT

I have three tasks and this is the first that tests for the presence of the file if the task fall an error in the other two tasks will not engage therefore ideal for me and to test if the file is not present or whether I charge if I do anything without losing my data

Re: keep old data when reload fail

Thu, 30 Apr 2015 16:25:38 GMT

The production team don't want that the task fall in errore it is for his I seek another solution. EDX I tried but I do not understand how to set it up

Re: keep old data when reload fail

Anonymous — Thu, 30 Apr 2015 16:44:47 GMT

The "don't want" doesn't seem to be a valid reason for implementing some complex solution

Re: keep old data when reload fail

Thu, 30 Apr 2015 17:27:53 GMT

They suggest to find an another solution so.

Is it exist a command to reload old data?

Re: keep old data when reload fail

cwolf — Thu, 30 Apr 2015 17:31:38 GMT

to run EDX Tasks you need the qmsedx.exe. Have a look at

Using EDX in QlikView 11

and

QMSEDX Enhanced

Re: keep old data when reload fail

cwolf — Thu, 30 Apr 2015 18:16:13 GMT

With EDX then all what you have to do in the script of your first task:

for each File in filelist ('\\Path\To\TestFile')

//File exist!

//run the next task

//No spaces anywhere in the names!!

EXECUTE \\Path\To\qmsedx.exe -task=YourEdxTaskName -qms=YourServerName -password=YourEdxPassword ;

next File

Re: keep old data when reload fail

Fri, 01 May 2015 11:03:16 GMT

Hi sorry to answer later i'm in France.

I just have to put this code in my script ?

But this task should have to run automatically when users put the flag file.

How to do it ?

Re: keep old data when reload fail

cwolf — Tue, 05 May 2015 14:27:26 GMT

Instead of creating a flag file, the user can call the EDX task directly via a batch file for example.