Failure Email in QV Server

[#1]

Hi All,

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

thanks...

[ashfaq_haseeb]

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

[#3]

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

[ashfaq_haseeb]

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

[#5]

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:

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

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.

[ashfaq_haseeb]

Hi

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

[#7]

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

[ergustafsson]

Hi Reena,

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

Regards,

Erik

[#9]

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

[ergustafsson]

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