Our app has been working fine with both manual reload and scheduled task of reload. However, after we add section access, it is fine to load data in script, but failed for both manual and scheduled reload.
The Log file in is the same directory as the model. It will have the same name but a txt extension.
e.g. if your model is called Sales.qvw then the log file is Sales.txt
To make sure you are creating the log file check that under the Settings menu then Document Properties option and on the General tab you have the second checkbox ticked which is Generate LogFile
When you have created your section access then you must check that you have also set these properties.
Again, under the Settings menu then Document Properties option and on the Opening tab then half way down the tab you need to check the checkbox for Initial Data Reduction Based on Section Access and the checkbox for Strict Exclusion too.
This should be enough for the manual reload.
For scheduled reloads you will need to provide the Username and Password for the reload.
You do this in the QlikView Management Console under the Documents tab (select your model you want to reload) then on the Reload tab at the bottom tick the Section Access checkbox and set the username and password.
Also, make sure that you have an admin set up in the section access otherwise you could lock yourself out!