Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
dcmcderm
Partner - Contributor III
Partner - Contributor III

Reload from server fails

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>

Labels (1)
3 Replies
Anonymous
Not applicable

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
Partner - Contributor III
Partner - Contributor III
Author

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
Not applicable

David

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

Best Regards,     Bill