Reload from server fails

[dcmcderm]

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>

[Anonymous]

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

[dcmcderm]

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.

[Anonymous]

David

Looks like one to put past your database techie's.

Best Regards,     Bill