topic Re: Failure Email in QV Server in QlikView

Re: Failure Email in QV Server

Wed, 23 Apr 2014 12:26:53 GMT

Hi All,

is it possible to trigger an auto mail specifying the error due to which the reload was failed??

thanks...

Re: Failure Email in QV Server

ashfaq_haseeb — Wed, 23 Apr 2014 12:31:10 GMT

Hi,

Yes,Very much possible.

Go to Management console --> system tab --> select mail server and configure your mail server there Save your setting,

Then go to Distribution service and select Alert email tab and here specify email address of recipients. save and close

Every time task fail the recipients specified will get Email notification about task failure.

Hope it helps

Regards

AHFAQ

Re: Failure Email in QV Server

Wed, 23 Apr 2014 12:37:30 GMT

Dear Ashfaq Mohammed,

Yeah,we are receiving a task failure email, but the email is not specifying due to which error the reload got failed. is there any way to specify the Error??

Thankss...

Re: Failure Email in QV Server

ashfaq_haseeb — Wed, 23 Apr 2014 12:47:16 GMT

Hi,

I believe there is a shot description it clearly shows the cause of task failure.

Can you please post msg that you receive in your mailbox.

Regards

ASHFAQ

Re: Failure Email in QV Server

Wed, 23 Apr 2014 12:56:56 GMT

The message is as follows,

The task "ABC.qvw" failed. Part of the log file follows:

4/23/2014 5:04:06 PM Error Document open threw an exception. Exception=The currently executing operation was aborted.

4/23/2014 5:04:07 PM Error The sourcedocument failed to open.. Exception=System.NullReferenceException: Object reference not set to an instance of an object.

at QVBWrapper.Document.Load(ILogBucket i_LogBucket, Boolean withData)

4/23/2014 5:04:07 PM Error The document failed to open.

4/23/2014 5:04:07 PM Error The task "ABC.qvw" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted.

at QVBWrapper.DocumentPool.Checkout(ILogBucket logBucket, eCheckoutMode checkoutMode, String fileName, Boolean clearAll, Boolean clearLocks, Boolean clearOneAndOnlyOnes, Boolean reduce, String variableName, String variableValue, AbortCallbackCheck abortCallbackCheck, String sectionAccessUsername, String sectionAccessPassword, DocumentRestoreMode documentRestoreMode, Boolean withData)

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

4/23/2014 5:04:07 PM Error Task failed with exception

4/23/2014 5:04:07 PM Error Exception=The currently executing operation was aborted.

Re: Failure Email in QV Server

ashfaq_haseeb — Wed, 23 Apr 2014 13:03:50 GMT

I believe this is failed because you have section access in your document.

Please go to distribution service --> advance tab --> provide section Access Admin user credentials here.

Save and restart all QlikView services.

Now monitor by re- running task and check if tasks still fails.

Hope it help

Regards

ASHFAQ

Re: Failure Email in QV Server

Wed, 23 Apr 2014 13:41:02 GMT

hi,

we are not havin section access in our applictn, the error was actually due to missing a comma in script. is it possible to specify the table name or smethng lik tht..

thnks...

Re: Failure Email in QV Server

ergustafsson — Wed, 23 Apr 2014 14:35:03 GMT

Hi Reena,

Could it be that there is a hidden script, which contains Section Access?

Regards,

Erik

Re: Failure Email in QV Server

Thu, 24 Apr 2014 03:56:10 GMT

Hi Erik,

for testing purpose we created one error in the script(ie..Removed one comma) and Reloaded the script. So the email was sent for failure. But our requirement is like, the error should be specified in the mail due to which the reload got failed(here it is a syntax error) . is it possible to do the same.

Thanks..

Re: Failure Email in QV Server

ergustafsson — Thu, 24 Apr 2014 06:11:11 GMT

Hi Reena,

No, there are no features to categorize error messages. One can send emails upon tasks that fail, or succeed. There can also be warnings, but if you want to categorize error messages, you need an email rule or similar.

Regards,

Erik

Re: Re: Failure Email in QV Server

ashfaq_haseeb — Thu, 24 Apr 2014 06:33:37 GMT

Hi Rema.

Please make sure there is no section access or any king of hidden script in your application.

Please do through at the attach document.

Hope it help.

Regards

ASHFAQ

Re: Re: Failure Email in QV Server

Thu, 24 Apr 2014 07:00:30 GMT

Hi,

Can yu please explain me through an example if possible,how we can create Email Rules to achieve the same?/

Thankss...

Re: Re: Failure Email in QV Server

ergustafsson — Thu, 24 Apr 2014 08:18:03 GMT

Hi Reena,

My apologies for not making this clear. With email rules, that is something you need to do on the email client side, meaning your email application (e.g. Outlook). Outlook can base rules and sort emails based on content in emails. This is not something QlikView can do.

Regards,

Erik

Re: Re: Failure Email in QV Server

ergustafsson — Thu, 24 Apr 2014 09:18:58 GMT

Hi again Reena,

Just struck my mind that there are some tags that you can add in your alert emails, that might help you further. In the QDS settings > Email Templates you can see a few, and check the QMC help for more information.

In the latest release, v11.20 SR6 there are a few new ones, such as:

[DocumentLog] – Adds the line of the error in the document log along with the line number. E.g Line 45 - Error: <error message>

See the Release Notes for further information: https://d1cf4w4kkla6tb.cloudfront.net/qlikview/11.20/12347/QlikView%2011.2%20build%2012347%20SR6%20Release%20Notes.pdf

Let me know if this helps.

Regards,

Erik

Re: Failure Email in QV Server

Tue, 29 Apr 2014 06:09:12 GMT

Hi Erik,

Thanks for the reply..but we are using Sr5 version. will upgrade the same nd will check...

Thanks..