Solved: Server doesn't send alert mail when reload fails - Qlik Community

maxgro · ‎2014-03-21

I have two reload task on a Qlikview server (without publisher) failed.

For first task I received the alert email

For second I didn't receive any alert mail

Why?

Log of the 2 task are below

FIRST TASK, MAIL RECEIVED, TASK LOG

21/03/2014 10:31:13.0716001 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\QLIKVIEW\ADMIN\test mail.qvw.

21/03/2014 10:31:13.1966190 Information Closing the document.

21/03/2014 10:31:13.8216742 Information Closed the QlikView Engine successfully. ProcessID=4748

21/03/2014 10:31:13.8216742 Error The task "Admin/test mail.qvw" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\QLIKVIEW\ADMIN\test mail.qvw.

at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

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)

21/03/2014 10:31:13.8216742 Information Task Execute Duration=00:00:02.1720188

21/03/2014 10:31:13.8216742 Information Sending Alert mail

21/03/2014 10:31:14.6668022 Information TaskResult.status=Finished

21/03/2014 10:31:14.6668022 Information Notifying all triggers of new state:FinishedWithErrors

21/03/2014 10:31:14.6668022 Information Notifying all triggers of new state:FinishedWithErrors - completed

21/03/2014 10:31:14.6668022 Information Saving Task Result

SECOND TASK, MAIL NOT RECEIVED, TASK LOG

21/03/2014 10:31:10.1245333 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\QLIKVIEW\SIB\LOGISTICA\DATI\Logistica EXT.qvw.

21/03/2014 10:31:10.2338993 Information Closing the document.

21/03/2014 10:31:10.8589466 Information Closed the QlikView Engine successfully. ProcessID=3868

21/03/2014 10:31:10.8589466 Error The task "Logistica_dati/Logistica EXT.qvw" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\QLIKVIEW\SIB\LOGISTICA\DATI\Logistica EXT.qvw.

at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

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)

21/03/2014 10:31:10.8589466 Information Task Execute Duration=00:00:02.4887065

21/03/2014 10:31:10.8589466 Information TaskResult.status=Finished

21/03/2014 10:31:10.8589466 Information Notifying all triggers of new state:FinishedWithErrors

21/03/2014 10:31:10.8589466 Information Notifying all triggers of new state:FinishedWithErrors - completed

21/03/2014 10:31:10.8745721 Information Saving Task Result

SECOND TASK, MAIL NOT RECEIVED, DOCUMENT LOG

21/03/2014 10:31:09.6557350 Information 21/03/2014 10:31:09: 0014 Directory

21/03/2014 10:31:09.9838766 Information 21/03/2014 10:31:09: 0016 OLEDB CONNECT*Provider*XPassword*

21/03/2014 10:31:09.9838766 Information 21/03/2014 10:31:09: Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Login failed for user 'XXXXX'.

21/03/2014 10:31:09.9838766 Information 21/03/2014 10:31:09: General Script Error

21/03/2014 10:31:09.9838766 Information 21/03/2014 10:31:09: Execution Failed

21/03/2014 10:31:09.9838766 Information 21/03/2014 10:31:09: Execution finished.

Report Inappropriate Content · ‎2014-06-24

Check so you don´t have email adress in both "Send all emails to" in the Mail server config window, and also have recipients in the Alert Mail tab under Distribution Service.

If so, remove mail adress from "Send all emails to" and save.

Also, if the task was configured before you configured mail server, go into the task again and re-save it.

View solution in original post

maxgro · ‎2014-03-23

last attempt

Peter_Cammaert · ‎2014-03-25

Don't know. Bug in QDS? Refuses to send email when task fails with General Script Error? (I don't like those errors either )

Did the first task fail with a General Script Error as well?

I would suggest to contact Qlik Support as your description borders on the mysterious and you will have more luck with the magicians up north. But please do keep us posted.

Good luck,

Peter

Report Inappropriate Content · ‎2014-06-23

I'm having a similar issue.

I can send test emails without a problem from the System->Setup->Mail Server screen, so I know my mail configuration is ok.

I've tested the email addresses in the System->Setup->QlikView Servers->Alerts screen.

I'm just not getting emails when Reloads fail.

Any pointers would be appreciated.

I'm running QVS 11.20.12235 x64 with no Publisher.

Thanks

Report Inappropriate Content · ‎2014-06-24

Check so you don´t have email adress in both "Send all emails to" in the Mail server config window, and also have recipients in the Alert Mail tab under Distribution Service.

If so, remove mail adress from "Send all emails to" and save.

Also, if the task was configured before you configured mail server, go into the task again and re-save it.

Report Inappropriate Content · ‎2014-06-26

Yep. That did the trick. Thanks.

Removes then re-added the reload task and the email came through.

Nice one.

Thanks again.

Adam

maxgro · ‎2014-06-27

many thanks Andreas

it works for me too

Report Inappropriate Content · ‎2014-07-28

We have the same issue. I have tried the suggestion from ako that seems to work for others, but it doesn't correct the issue for us.

We are running publisher with qds version 11.20.11643.0, and qvs 11.20.11716.0. Any ideas?