False Failure

[johnso2080]

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

[#2]

Hi Darren,

What does the task log say?

[johnso2080]

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

[jvitantonio]

Hi Darren,

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

What happens when you run this script manually?

JV

BI Experience | A place to share our Business Intelligence experiences

[johnso2080]

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

[jvitantonio]

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

JV

BI Experience | A place to share our Business Intelligence experiences

[rwunderlich]

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

[johnso2080]

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

[rwunderlich]

I would take this one to support.

-Rob

[Anonymous]

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