Reload Error only when "scheduled"

Fri, 17 May 2013 12:38:39 GMT

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

topic Reload Error only when "scheduled" in QlikView

Reload Error only when "scheduled"