I recently ran into an issue with one of my qvws that would successfully reload when using the desktop client on the server but it would error out whenever I scheduled it using the Management Console. There were no "errors" in the Document Log to help me. Here is the only clue I had:
5/17/2013 07:06:11.2999765 Information 5/17/2013 7:06:11 AM: Error: Table not found
5/17/2013 07:06:11.2999765 Information 5/17/2013 7:06:11 AM: General Script Error
5/17/2013 07:06:11.2999765 Information 5/17/2013 7:06:11 AM: Execution Failed
5/17/2013 07:06:11.2999765 Information 5/17/2013 7:06:11 AM: Execution finished.
I couldn't figure out why this table wasn't being created and therefore causing this error when I tried to drop it.
It turns out that the case sensitivity in some statements are different if you are using desktop client vs. a Task to do the reload. Here was my problem. This was my original statement that was my root cause:
//store the folder path of this qvw
let ActiveQVWFilePath=replace(DocumentPath( ),DocumentName( ),'');
//navigate to the Source Data tree instead of the QlikView Apps tree.
let vfilepath = replace('$(ActiveQVWFilePath)', 'QlikView Apps', 'Source Data');
This worked locally but not on the server. By executing some trace statements and reviewing the Document Log. I realized the Task reload was not doing the replace correctly and therefore not finding the files I was trying to load. So I took a shot at converting everything to UPPER CASE and it worked!!!!
//store the folder path of this qvw
let ActiveQVWFilePath=upper(replace(DocumentPath( ),DocumentName( ),''));
//navigate to the Source Data tree instead of the QlikView Apps tree.
let vfilepath = replace('$(ActiveQVWFilePath)', 'QLIKVIEW APPS', 'SOURCE DATA');
I hope this helps someone else.
P.S. This is a good video for an introduction to troubleshooting reload issues. http://community.qlik.com/docs/DOC-3868
