Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Scheduled reloads fail instantly until server is restarted

Hello all,

We seem to be getting this issue about once a week on average. Scheduled reloads fail as soon as they try and connect to SQL Server - the error is 'OLEDB connection failed'. Stopping and restarting the services doesn't fix the issue however after rebooting the server, everything works perfectly. Obviously rebooting the server once or more per week is not a great solution!!! Has anyone come across this issue before? The problem is not with SQL Server as reloading the documents works fine on the server desktop and other non-related applications can connect quite happily. It's just an issue for the scheduled reloads through the QMC. I'll post a few log extracts....


Qlikview version is 11.2 SR5.

21/01/2014 06:09:04.0325431 Information 21/01/2014 06:09:03: 0032  Holidays:

21/01/2014 06:09:04.0325431 Information 21/01/2014 06:09:03: 0033  LOAD date(CalendarDate) as BankHoliday,

21/01/2014 06:09:04.0325431 Information 21/01/2014 06:09:03: 0034   1 as Marker

21/01/2014 06:09:04.0325431 Information 21/01/2014 06:09:03: 0035      where WeekDay(CalendarDate)<5

21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:03: 0036  SQL SELECT  CalendarDate

21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:03: 0037  FROM xxx.dbo.xxx where CalendarDate>='2012-01-01' and IsShopDate=0

21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:03: 0038   group  by CalendarDate order by CalendarDate

21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:04:       Error: OLEDB connection failed

21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:04:       General Script Error

21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:04:       Execution Failed

21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:04:      Execution finished.

21/01/2014 08:49:00.6138630 Information Waiting for the document log "C:\QV Documents\QVD Gen-ADP.qvw" to become available.. Check until 21/01/2014 08:49:04

21/01/2014 08:49:00.6919501 Information Found a document log. FileName=C:\QV Documents\QVD Gen-ADP.qvw.log

21/01/2014 08:49:00.6919501 Information Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20140121\084859 - QVD Gen-ADP.qvw\DocumentLog.txt

21/01/2014 08:49:00.9975336 Information The Source Document reload complete. DocumentPath=C:\QV Documents\QVD Gen-ADP.qvw

21/01/2014 08:49:00.9975336 Information Memory Allocation Delta for this file=1.79 Mb. Available Physical Memory Before Reload=36542.90 Mb. Available Physical Memory After Reload=36534.03 Mb. Total Physical Memory=36534.03 Mb.

21/01/2014 08:49:01.2006546 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\QV Documents\QVD Gen-ADP.qvw.

21/01/2014 08:49:01.2631572 Information Closing the document.

21/01/2014 08:49:01.9037585 Information Closed the QlikView Engine successfully. ProcessID=12304

21/01/2014 08:49:01.9506736 Error The task "QVD Gen-ADP.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=C:\QV Documents\QVD Gen-ADP.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)

21/01/2014 08:49:01.9506736 Information Task Execute Duration=00:00:02.3993355

21/01/2014 08:54:45.9718713 Information 21/01/2014 08:54:45: 3069  if 'all'='21' or 'all'='all' then

21/01/2014 08:54:46.2062915 Information 21/01/2014 08:54:45: 3075    OLEDB CONNECT*Provider*

21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46: 3079    Rejects:

21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46: 3080     SQL SELECT * FROM xxxx.dbo.V_QlikviewRejectReport

21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46:         Error: OLEDB connection failed

21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46:         General Script Error

21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46:         Execution Failed

21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46:      Execution finished.

21/01/2014 08:54:46.5031335 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\QV Documents\QVD Gen2.qvw.

21/01/2014 08:54:46.5500095 Information Closing the document.

21/01/2014 08:54:47.1906960 Information Closed the QlikView Engine successfully. ProcessID=16032

21/01/2014 08:54:47.2063212 Error The task "QVD Gen2.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=C:\QV Documents\QVD Gen2.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)

21/01/2014 08:54:47.2063212 Information Task Execute Duration=00:00:02.3438492

21/01/2014 08:54:47.2063212 Information Sending Alert mail

21/01/2014 08:54:47.2375663 Information TaskResult.status=Finished

21/01/2014 08:54:47.2375663 Information Notifying all triggers of new state:FinishedWithErrors

3 Replies
Highlighted
Partner
Partner

Re: Scheduled reloads fail instantly until server is restarted

Check if the user that runs the Qlikview services has the same rights to access/read the datasource like used in the OLEDB connection.

Highlighted
Creator
Creator

Re: Scheduled reloads fail instantly until server is restarted

Yes, I've double checked and the user has all the necessary server / SQL Server permissions.

Highlighted
Partner
Partner

Re: Scheduled reloads fail instantly until server is restarted

Try this then:

1. Log in again to all the services with that same user that has SQL server permissions.

2. Re-install/repair you Qlikview installation.

Before trying these please check to see if the Event viewer gives you any usefull errors.