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
