Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rajeshvaswani77
Valued Contributor III

Batch File to return success or failure

Hi Folks,

I have a requirement that at a particular time a batch file should run, fetch a file from SFTP location and then perform QVD reloads that will sue the file. I would like to achieve the same by creating a Job A in the QMC that will run the batch file and get the file. On success or failure of Job A, Job B should create the QVD's then the next Job to reload teh dashboard. Note that on Success of A, B will run, on success of B, C will run. There is a scenario where I would like to force fail the job. Say we have not received the file and Job A should fail which will send out a email. Then there will be manual intervention to look at getting the files.

How do I make Job A fail which is a batch file execution, when the batch file did not get any file from SFTP? 

thanks,

Rajesh Vaswani


2 Replies
danielrozental
Honored Contributor II

Re: Batch File to return success or failure

There isn't a clean way to make a QVW Script fail, there is no exit(error) that will cause the desired behaviour.

You should just try to read a file that doesn't exist or something like that

LOAD * FROM FORCE_ERROR.QVD;

Not applicable

Re: Batch File to return success or failure

You can have an alertmail inside your Qvw application that will send out an alertmail when the file has been updated with a value change. But there is no check that will "look" for a file to be fetched, all based on data being loaded. QMC acts on failures vs success, so that can´t be used in such scenario either.

Best would be if you implement a load of somekind inside the qvw that can trigger an alert mail, when the file is fetched.

Community Browser