topic Re: Macro not running in task in QlikView

Macro not running in task

chris_johnson — Mon, 15 Jan 2018 11:54:58 GMT

Hi,

I've been having a problem (which seems to have been happening since updating to QV Nov'17 version) with running a macro. There is a macro that does some text encoding on running of the scheduled task, does not access the file system, but will only run when ran on QV Desktop not in the QV Server.

I have checked in the QMC and macro execution is allowed (although unsafe macros is not ticked).

I don't understand why the macro will not run when the server runs the task.

Anyone have any ideas?

Thanks

Re: Macro not running in task

rubenmarin — Mon, 15 Jan 2018 12:14:24 GMT

Hi Adam, there is a list of macro limitations in server:

Using Macros in QV Documents on the QV-Server ‒ QlikView

Maybe is using OnPostReload trigger?

Re: Macro not running in task

marcus_sommer — Mon, 15 Jan 2018 12:16:31 GMT

AFAIK as a general rule no macro won't be executed by directly reloading an application through a qmc-task or starts the qmc-task an external batch/task? Are you sure it had worked before QV Nov'17?

- Marcus

Re: Macro not running in task

chris_johnson — Mon, 15 Jan 2018 12:29:13 GMT

It did work before the latest QV Nov'17 release, although I know that could be a coincidence. We had to upgrade due to a few other issues so could be something unrelated.

Re: Macro not running in task

chris_johnson — Mon, 15 Jan 2018 12:54:06 GMT

This is the VBScript function by the way:

Function URLEncode(ByVal str)

Dim strTemp, strChar

Dim intPos, intASCII

strTemp = ""

strChar = ""

For intPos = 1 To Len(str)

intASCII = Asc(Mid(str, intPos, 1))

If intASCII = 32 Then

strTemp = strTemp & "+"

ElseIf ((intASCII < 123) And (intASCII > 96)) Then

strTemp = strTemp & Chr(intASCII)

ElseIf ((intASCII < 91) And (intASCII > 64)) Then

strTemp = strTemp & Chr(intASCII)

ElseIf ((intASCII < 58) And (intASCII > 47)) Then

strTemp = strTemp & Chr(intASCII)

Else

strChar = Trim(Hex(intASCII))

If intASCII < 16 Then

strTemp = strTemp & "%0" & strChar

Else

strTemp = strTemp & "%" & strChar

End If

URLEncode = strTemp

End Function

Re: Macro not running in task

marcus_sommer — Mon, 15 Jan 2018 13:09:31 GMT

Please provide some more informations if the qvw is directly reloaded or per external batches and how the macro is triggerred and how it does look like.

Further there was various changes on the security-settings between the releases especially if the old release was an early QV 11 then there was many changes to the current release.

- Marcus

Re: Macro not running in task

chris_johnson — Mon, 15 Jan 2018 13:30:48 GMT

Hi Marcus,

I posted the macro function itself to the post but it is still being moderated.

The previous release was version 12 SR 1.

The macro is triggered via a line in the script:

let urlEncoded = URLEncode('$(url)');

where url is the url for what I need to reference (a Google Analytics address) and URLEncode is the VBScript funtion

Re: Macro not running in task

marcus_sommer — Mon, 15 Jan 2018 14:40:17 GMT

Ok. it's a function My using of vbs-functions during the load was along time ago and probably before we extended our solution to a server-environment. Therefore I'm not really sure but if you say it worked I think vbs-functions are executed as long they not trying to access the ActiveDocument.

Therefore I could imagine that some security-setting within the settings.ini is now per default different as before but I don't know which one. It's not directly related to your case but similar from (il)logic of changing settings and may help you to get ideas: QV 12.10 “Can Execute External Programs” is back | Qlikview Cookbook.

If your vbs-routine isn't too complicated you could try to switch it into a qlikview-variable and/or a sub-routine.

- Marcus

Re: Macro not running in task

marcus_sommer — Mon, 15 Jan 2018 16:41:45 GMT

If I understand this routine right it adjust an invalid url through replacing invalid chars into a valid url. Something like this could be done with a mapsubstring() like in this example:

Re: Passing parameter strings that contain special characters

- Marcus

Re: Macro not running in task

chris_johnson — Tue, 16 Jan 2018 09:28:35 GMT

Hi Marcus,

I switched it to script using the mapsubstring() function as you suggested (link to example I used: String manipulation)

Thanks for your help

Re: Macro not running in task

marcus_sommer — Wed, 17 Jan 2018 06:35:46 GMT

I think this would solve the origin cause: Re: Problems calling functions from load script QV 12 whereby in your case I believe I would remain by the mapsubstring-approach.

- Marcus

Re: Macro not running in task

rubenmarin — Wed, 17 Jan 2018 12:56:15 GMT

In case it helps in other cases, just readed this:

QlikView November 2017 and JScript Modules not ... | Qlik Community