Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The task "DataMart/Build_Sales_Baseline.qvw" 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=D:\QlikView\Documents\Live\DataMart\Build_Sales_Baseline.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)
Check the file D:\QlikView\Documents\Live\DataMart\Build_Sales_Baseline.qvw.log for errors. If that file does not exist open the document and enable the option Generate Logfile and save the file. Then reload the document again from the QMC and then check the log file.
Hi,
There is an error in the log file (as I mentioned in the first post). I have no idea what "[DBNETLIB][ConnectionRead (Error SIO_KEEPALIVE_VALS()).]General network error." means.
From the document log (Build_Sales_Baseline.qvw.log)
Hi Kelvin,
Their is some issue in the Qlikview script:
Go to>edit script> and use debug option and trace the issue.
this will get you know the exact issue.
Hope this helps you
My apologies, I didn't read your post as thoroughly as I should have. Have you tried searching the internet for this error. Or perhaps your network administrator can assist in troubleshooting the issue. In any case the problem is not caused by Qlikview. Qlikview merely logs the error that the OLEDB driver for SQL Server returns.
What problem do I edit the scrip in?
I agree I think the error is related to our SQL server.
I've posted a similar question on Microsoft TechNet SQL server forum for some help. I'll let you know how I get on..
Please let me know if you were able to resolve this issue
Error that I have in the Log:
Error: The task failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath= || 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)
Reload task that i created in QMC is still failing.
When I debug in the 'Edit Script' of my qlikview document,Result is :'connected'.
Here's my connection info in qlikview document:
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=xxxx;Data Source=yyyyyy;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=zzzzzz;Use Encryption for Data=False;Tag with column collation when possible=False];
Who are you logged in as when you say "When I debug in the 'Edit Script' of my qlikview document,Result is :'connected'."
The scheduled reload will run as the user account that runs the QDS service (QlikView Distribution Service)
Does the service account have permission to access the database?
Can you login to the server using the service account, and then test if the reload works from QlikView Desktop?