I have reload tasks that appear to fail in the QMC, and therefore trigger 'On Failure' actions. However, when looking at the scripts recorded by the reload, they complete without any problems. Does anyone know what this could be?
It finished like this...
01/11/2013 04:20:23.7233857 Information Reloading.......
01/11/2013 04:30:32.1350857 Information Reloading........
01/11/2013 04:33:33.5821750 Error The sourcedocument failed to reload.. Exception=System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.
at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug)
at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)
01/11/2013 04:33:33.6445762 Error Aborting Reload. Error=QDSMain.TaskResult
01/11/2013 04:33:33.6913771 Information Initializing Reload (0), Finished (9209242)
01/11/2013 04:33:33.7069774 Error Reload failed.
01/11/2013 04:33:33.7381780 Information Closing the document.
01/11/2013 04:33:33.8785807 Information Closed the QlikView Engine successfully. ProcessID=8312
01/11/2013 04:33:33.8785807 Information Initializing (0), Finished (171)
01/11/2013 04:33:33.8785807 Error Reload failed. Distribution skipped.
01/11/2013 04:33:33.8785807 Error The task "APPS/CreateSTDQVD.qvw" failed. ErrorCount=4
01/11/2013 04:33:33.8785807 Information Sending Alert Mail to 1 recipients.
01/11/2013 04:33:49.0108717 Error Exception=System.Net.Mail.SmtpFailedRecipientException: Mailbox unavailable. The server response was: 5.7.1 Unable to relay
at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception)
at System.Net.Mail.SmtpClient.Send(MailMessage message)
at QDSMain.SMTPServerResource.SendMail2(ILogBucket i_LogBucket, SmtpClient i_SmtpClient, MailMessage i_MailMessage)
It clearly failed. Why are you saying it was successful?
What happens when you run this script manually?
The report did successfully complete everything that was required of it. I can see that all the tasks involved in the script have been fulfilled, and when running manually it completes without any issues. The script also keeps a record of each step and this ends successfully, but occasionally, the qv server mistakenly thinks that the task failed...?
I don't think so. Based on your log it looks like it's something related to the source. IF it's a table, maybe it was being recreated? Some process might drop and recreate the source table so your qvw file won't be able to find it or read from it...
Are you saying that your Document Log has an
"Execution finished." message at the bottom?
I have seen a problem where the script finishes, but the task remains and is eventually killed by the timeout. Are you reaching the time limit for the task?
What version of Qlikview Server?
Yes, the log ends with 'Execution Finished', there's no sign of anything going wrong at all in the script, yet it fails the task. Do you know what causes this and how I can resolve it?
I'd endorse Rob's suggestion of putting it past QlikView Support.
But you could also have a look at this thread, but make sure you are sitting comfortably first as it is a long read.
Best Regards, Bill