topic Re: False Failure in QlikView

False Failure

johnso2080 — Fri, 01 Nov 2013 09:31:27 GMT

Hello,

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?

Thanks

Darren

Re: False Failure

Fri, 01 Nov 2013 09:35:32 GMT

Hi Darren,

What does the task log say?

Re: False Failure

johnso2080 — Fri, 01 Nov 2013 10:51:58 GMT

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)

Thanks

Darren

Re: False Failure

jvitantonio — Fri, 01 Nov 2013 10:56:10 GMT

Hi Darren,

It clearly failed. Why are you saying it was successful?

What happens when you run this script manually?

BI Experience | A place to share our Business Intelligence experiences

Re: False Failure

johnso2080 — Fri, 01 Nov 2013 14:23:37 GMT

Hello,

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

Re: False Failure

jvitantonio — Fri, 01 Nov 2013 14:28:09 GMT

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

BI Experience | A place to share our Business Intelligence experiences

Re: False Failure

rwunderlich — Fri, 01 Nov 2013 18:39:48 GMT

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?

-Rob

Re: False Failure

johnso2080 — Mon, 04 Nov 2013 09:19:25 GMT

Hi Rob,

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?

Many Thanks

Darren

Re: False Failure

rwunderlich — Thu, 07 Nov 2013 19:29:34 GMT

I would take this one to support.

-Rob

Re: False Failure

Anonymous — Thu, 07 Nov 2013 21:35:06 GMT

Darren

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.

http://community.qlik.com/thread/20455

Best Regards, Bill