Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
maxgro
MVP
MVP
‎2014-03-21 06:14 AM

Server doesn't send alert mail when reload fails

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.

5,407 Views
0 Likes
1 Solution

Accepted Solutions
Not applicable
‎2014-06-24 03:33 AM

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

1,895 Views
7 Replies
maxgro
MVP
MVP
‎2014-03-23 11:09 AM
Author

last attempt

1,895 Views
0 Likes
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2014-03-25 11:59 AM

In response to maxgro

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

1,895 Views
Not applicable
‎2014-06-23 09:51 PM

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

1,895 Views
0 Likes
Not applicable
‎2014-06-24 03:33 AM

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.

1,896 Views
Not applicable
‎2014-06-26 07:32 PM

In response to

Yep. That did the trick. Thanks.

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

Nice one.

Thanks again.

Adam

1,895 Views
maxgro
MVP
MVP
‎2014-06-27 05:29 AM
Author

In response to

many thanks Andreas

it works for me too

1,895 Views
0 Likes
Not applicable
‎2014-07-28 08:37 PM

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?

1,895 Views
0 Likes