topic Re: Macro not working disconnected from Server in QlikView

Macro not working disconnected from Server

urivera — Sat, 08 Feb 2014 23:04:02 GMT

Hi,

I have a problem with a macro to sending mail:

Server:

64B,

Windows 2008 SP2

QlikView Server 11

Desktop 11 R5

QV Document

1.- It has a macro to send email using a mail account with the proper code.

2.- The corresponding setting in a macro editor and in a document, referent a security and access to system are ok.

2.- In a bat file there are the necessary command to invoke qv.exe and the document.

Running the task

1.- In a manual mode no problem, the mail it sent.

2.- When use scheduled task of server and run it, no problem

3.- When close the conn, (not log off), the task not send email and the task administrator show it with zero activiy, but en memory.

Finding the "error", I created diferent scheduled task according below:

1.- Task under Windows 2008 (options in task)

2.- Task under Windows 2003 (options in task)

3.- bat file with param /r

4.- bat file with param /l

5.- bat file with param /v to trigger or not the macro.

6.- bat file with without param

7.- Trigger macro onPostReload

8.- Trigger macro onOpen

9.- Run task at user belong administrator Group

10.- Run task at user administrator

11.- Run task with other account gmail.

Note.-

When the task is in point 2.., and sometime, the macro editor is open and the macro stop, but not error is present, only stop.

I debug the macro and the problem maybe the mail routine because without this code lines, the macro don't stop.

Anybody know a similar situation and how to resolve this?

This is the code macro for sending email:

Sub EnviarGmail(sTo, sSubject, sBody, sFile)

    ' Object creation
    Set objMsg = CreateObject("CDO.Message")
    Set msgConf = CreateObject("CDO.Configuration")

    ' Server Configuration
    msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
    msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmail.com"
    msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 465
    msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
    msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "cuenta@dominio.net"
    msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password"
    msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = 1
    msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60
    msgConf.Fields.Update

    ' Email
    objMsg.To             = sTO
    objMsg.From         = "cuenta@dominio.net"
    objMsg.Subject         = sSubject
    objMsg.HTMLBody     = sBody
    objMsg.Sender         = "xxxx"

    for i=0 to 9
        if sFile(i) <> "" then
           objMsg.AddAttachment sFile(i)
           ActiveDocument.GetApplication.WaitForIdle
        end if
    Next

    Set objMsg.Configuration = msgConf

    objMsg.Send

    Set objMsg = nothing
    Set msgConf = nothing

End Sub

Thk.

Ulises

Re: Macro not working disconnected from Server

urivera — Sun, 16 Feb 2014 16:19:14 GMT

nobody any suggest?

Re: Macro not working disconnected from Server

vikasmahajan — Mon, 17 Feb 2014 10:23:23 GMT

First and for Most you try to reload manually see it reload ok and giving log file ok.

Vikas

Re: Macro not working disconnected from Server

urivera — Tue, 18 Feb 2014 00:35:31 GMT

Hi Vikas

I can reload manually without problem and the log file is ok, but when i disconnected or loged out from server the task start and working one or twice and to the next sequence sotpedd and qv remain with zero cpu... and nothing appear at email...

Recently downlload a scheduler software, put in it the task and is the same... the task remain without activity...

Ulises

Re: Macro not working disconnected from Server

vikasmahajan — Tue, 18 Feb 2014 03:57:23 GMT

Hii,

While setting Task in windows Scheduler Please attached setting.

Hope your problem will resolve.

Good Luck

Vikas

Re: Re: Macro not working disconnected from Server

vikasmahajan — Tue, 18 Feb 2014 03:58:16 GMT

PFA settings

Re: Macro not working disconnected from Server

urivera — Tue, 18 Feb 2014 14:45:40 GMT

Thks for your answer,

I will change the settings tonight.

BR.

Re: Macro not working disconnected from Server

urivera — Wed, 19 Feb 2014 13:08:40 GMT

Hi,

I changed the sttings and nothing,

I made a delphi program that send a simple mail, y made a scheduler task and is the same, works only 1 or twice and then stopped, is another problem.

Y discovery that the windows is Windows 2008 standard SP2, not Windows 2008 R2 SP1, maybe it's the problema?

Thks...