Skip to main content

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Onpost Reload to Trigger Macro Failed

Hi All,

I have a macro send email to tell me that the process reload is succes. The macro is excecuted OnPost Reload qvw automatically, with the schedule reload in QMS. The macro working fine in Qlikview desktop, but its not working in qlikview server.  Anybody can help me?

I had add 'Macro override security' in the QVW and check the 'Allow macro execution on server','  Allow unsafe macro execution on server' on QMS. But it still not working.

Below is the macro I am using:


Dim objEmail

Const cdoSendUsingPort = 2

Const cdoAnonymous = 0

Const cdoBasic = 1

Const cdoNTLM = 2

SMTPServer = "mail.xxxxx.xx.xx"

Const SMTPPort = 25

Const SMTPTimeout = 60

'Sending mail

Set objEmail = CreateObject("CDO.Message")

Set objConf = objEmail.Configuration

Set objFlds = objConf.Fields

With objFlds


' Detalles del servidor SMTP

.Item("") = 2

.Item("") = SMTPServer

.Item("") = cdoAnonymous

.Item("") = SMTPPort

.Item("") = False

.Item("") = SMTPTimeout



End With

objEmail.To = "abc@xxxxx.xx.xx;def@xxxxx.xx.xx

objEmail.From = "mail@xxxxx.xx.xx"

objEmail.Subject = "Reload Qlikview Success"

objEmail.TextBody = "Schedule Reload Qlikview Success"


Set objFlds = Nothing

Set objConf = Nothing

Set objEmail = Nothing

end sub

2 Replies

The Reference manual states the following:

82.3 Macro trigger limitations

The following triggers are not to be used in the QlikView Server environment, since they lack meaning or

may cause unexpected results:




Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable

Bill has already pointed out that the Publisher will not execute certain triggers.

However there is a workaround to this. Basic principle is:

1) Create a CMD file on the QlikView Server that will start the reload

2) Create a Windows task that will run the CMD file

3) Create a CMD file that calls the Windows Scheduler

4) In the QMC go to 'Systems' tab, select 'Supporting Tasks' and 'External Programs' and create a new external program task. On the 'Triggers' tab of the just created task, it can be attached to any other existing task.

Hope this helps!

Best regards,