topic Re: Schedule reload failure in QlikView

Schedule reload failure

Mon, 26 Jan 2026 18:19:17 GMT

We have reloads that are scheduled to run at around 06:30 and they keep failing. When we run them manually a few hours later they are successful. Any ideas on what could be causing the problem? Details bellow:

Environment

QlikView Server is on version 11.20, Windows Server 2012 R2

Database server is running SQL Server 2008 R2, Windows Server 2008 R2

From the document log (Build_Sales_Baseline.qvw.log)

29/01/2015 06:34:04: 0611 SQL SELECT * FROM AquaDW.dbo.FactAccountsRebates WHERE LastUpdated >= '1900-01-01'
29/01/2015 06:34:04:       Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionRead (Error SIO_KEEPALIVE_VALS()).]General network error. Check your network documentation.
29/01/2015 06:34:04:       General Script Error
29/01/2015 06:34:04:       Execution Failed

From the QlikView Windows Event Viewer

The Source Document was NOT reloaded successfully. DocumentPath=D:\QlikView\Documents\Live\DataMart\Build_Sales_Baseline.qvw.

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.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)

SQL server Windows Event Viewer and SQL Log File Viewer have no errors/warnings at the time of failures.

Re: Schedule reload failure

Gysbert_Wassenaar — Fri, 30 Jan 2015 10:09:08 GMT

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.

Re: Schedule reload failure

Fri, 30 Jan 2015 10:23:11 GMT

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)

Re: Schedule reload failure

avinashelite — Fri, 30 Jan 2015 10:35:38 GMT

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

Re: Schedule reload failure

Gysbert_Wassenaar — Fri, 30 Jan 2015 10:38:58 GMT

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.

Re: Schedule reload failure

Fri, 30 Jan 2015 15:00:06 GMT

What problem do I edit the scrip in?

Re: Schedule reload failure

Fri, 30 Jan 2015 15:08:21 GMT

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..

Re: Schedule reload failure

Anonymous — Thu, 19 Feb 2015 18:41:48 GMT

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)

Re: Schedule reload failure

Anonymous — Thu, 19 Feb 2015 18:53:13 GMT

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];

Re: Schedule reload failure

Colin-Albert — Thu, 19 Feb 2015 19:20:20 GMT

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?

Re: Schedule reload failure

Anonymous — Tue, 24 Feb 2015 12:47:55 GMT

Ok., its the Database permissions issue...

Found this out by connecting to the database utilizing the service account that was created for Qlikview server.

service account (This is usually the account that was utilized to install Qlikview server) has access to the SQL Server database or whatever your database may be.

In order to validate and ensure that all your services are running with the service account credentials you need to go to "Start > Run", typing in "services.msc" and validate that your Qlilview services are running with the service account credentials.

Then,

Informed company DBA to provide authorization to SQL server data . He added the Service Account username at:

SQL server > Databases > xxxdatabase > Security > Users > R.Click > New User.. > enter the Username and Login name > Make selection under 'Owned Schemas' and 'Role Members' ( eg: db_datareader , db_datawriter)

Now, Reload task is successfully working. Thank you.