Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview Batch File run but failed to get refreshed data

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,

8 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
Highlighted
Not applicable

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

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

Thanks,

Highlighted
MVP & Luminary
MVP & Luminary

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

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.


talk is cheap, supply exceeds demand
Highlighted
Not applicable

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

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

Thanks,

Highlighted
MVP & Luminary
MVP & Luminary

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

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.


talk is cheap, supply exceeds demand
Highlighted
Not applicable

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

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,

Highlighted
MVP & Luminary
MVP & Luminary

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

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?


talk is cheap, supply exceeds demand
Highlighted
Not applicable

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

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,