topic Re: Qlikview Batch File run but failed to get refreshed data in QlikView

Qlikview Batch File run but failed to get refreshed data

Thu, 24 Dec 2015 19:19:47 GMT

Hi,

I scheduled a batch file every 5 minutes with the below code using some simple data, but batch file ran at the scheduled timing but dashboard shows old data when I opened.

"C:\Program Files\QlikView\qv.exe" /R "E:\Qlikview\Qlikview Batch File\Source\Batch File Test Qlikview.qvw"

copy "E:\Qlikview\Qlikview Batch File\Source\Batch File Test Qlikview.qvw" "E:\Qlikview\Qlikview Batch File\Destination\"

Exit

And I am not sure once batch file run, will qvw file goes to destination path where I defined or do I need to check source path only?

And I have used reloadtime() in the dashboard but that still shows the old reload time only, not sure why?

Can any pls let me know where I am doing wrong?

Thanks,

Re: Qlikview Batch File run but failed to get refreshed data

Gysbert_Wassenaar — Fri, 25 Dec 2015 07:10:15 GMT

Perhaps the reload failed. Did you check the log file? Or didn't you enable the generate logfile option in the document properties first?

Re: Qlikview Batch File run but failed to get refreshed data

Fri, 25 Dec 2015 07:52:35 GMT

I have enabled log file, but not sure where to check?

Thanks,

Re: Qlikview Batch File run but failed to get refreshed data

Gysbert_Wassenaar — Fri, 25 Dec 2015 07:54:25 GMT

In the same place as the where the qlikview .qvw file is stored. There'll be a file with the same name as the .qvw file with .log appended.

Re: Qlikview Batch File run but failed to get refreshed data

Fri, 25 Dec 2015 08:29:41 GMT

It looks its executed correctly, not sure where is the wrong in my batch file code?

Thanks,

Re: Qlikview Batch File run but failed to get refreshed data

Gysbert_Wassenaar — Fri, 25 Dec 2015 10:08:32 GMT

Check that the reloaded file was actually copied to the location where you expect it. And make sure to close the document in Qlikview before opening the reloaded copy.

Re: Qlikview Batch File run but failed to get refreshed data

Fri, 25 Dec 2015 11:20:20 GMT

I did the same way, but when I do manual running batch file the file is updating at the same source location, ofcourse I use the destination is the same source location.

When I to scheduling dashboard is not refreshing.

Thanks,

Re: Qlikview Batch File run but failed to get refreshed data

Gysbert_Wassenaar — Fri, 25 Dec 2015 16:15:28 GMT

What are you using to schedule the execution of the batch file? Windows Scheduled Tasks? If so have you checked the event log files for error messages concerning the scheduled task for your batch file?

Re: Qlikview Batch File run but failed to get refreshed data

Fri, 25 Dec 2015 18:07:16 GMT

I am using Task Scheduler only and I have enabled log file as well, can you please any sample file and the process.

Appreciated you much support.

Thanks,