Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have inconsistent results when I reload from the server. I have a scheduled task set to reload a document every hour. It always fails. If I run the task manually it works some of the time, but not others. For example if I click run 3 times in a row, maybe 1 will work and 2 will fail. I have no clue what the issue is and the logs aren't giving much info. Any ideas? Here is the task result log for one failure.
<?xml version="1.0" encoding="utf-8" ?>
- <Root TaskID="5b22d38d-caf0-479f-a13b-38a75898f2e1" OwnedByClusterID="2" RunID="7136c683-1a8b-4ab5-b0a9-8ccc9044604d" TaskManuallyAborted="False" TaskException="" PreviousRunHadErrors="False" InternalError="True" LastExecution="1/23/2014 2:25:52 PM" StartedAt="1/23/2014 2:25:52 PM" FinishedAt="1/23/2014 2:25:56 PM" MaxRunTime="1.00:00:00" StartCount="12" HasWarnings="False" Status="Finished" Modified="2014-01-23T19:25:56.2874682Z">
- <LogFinalEntries>
<LogFinalEntry Type="Error" Date="1/23/2014 2:25:55 PM" Text="The Source Document was NOT reloaded successfully. DocumentPath=C:\QlikviewFS\UserDocs\TCLHIN_QVD_Creator.qvw." />
<LogFinalEntry Type="Error" Date="1/23/2014 2:25:56 PM" Text="The task "Hourly QVD Update" failed. Exception: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\QlikviewFS\UserDocs\TCLHIN_QVD_Creator.qvw. at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult) at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) --- End of inner exception stack trace --- at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) --- End of inner exception stack trace --- at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)" />
</LogFinalEntries>
</Root>
David
What is in the document log after failure ? [As in the .log file in the same folder as the qvw, assuming you have generate log file switched in]
Best Regards, Bill
Here it is the interesting part. Not sure why it finds the data source sometimes and not others?
01-23-2014 2:51:53 PM: 0131 ODBC CONNECT*UserId*Password*
01-23-2014 2:51:54 PM: Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
01-23-2014 2:51:54 PM: General Script Error
01-23-2014 2:51:54 PM: Execution Failed
01-23-2014 2:51:54 PM: Execution finished.
David
Looks like one to put past your database techie's.
Best Regards, Bill