Schedule reload failure

[#1]

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

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

[Anonymous]

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.