topic Re: Recovery mechanism in QlikView

Recovery mechanism

Tue, 20 May 2014 16:13:10 GMT

Hi,

In the following scenario :

A .qvw application that extract 100 tables, say after the 60th table load the application crash. Is there a built in recovery mechanism to restart the .qvw but without loading again the tables that got processed successfully. or do I have to implement that mechanism myself. For example using a table (TABLE_NAME, LOAD_OK_OR_NOT) and if then else conditions.

Thank you.

Re: Recovery mechanism

its_anandrjs — Tue, 20 May 2014 17:01:34 GMT

Use log files to check from which table load the extractor fails and then in your load script restart the extractor from that position where the error comes. Just use exit script command from there and reload the remaining files in the load script and extract remaining files.

Other wise you can use Errormode for extractors

Eg:-

Set ErrorMode = 10;

Set ErrorMode = 11;