topic Re: Macro not working on server after upgrading to 11.2 SR9 in QlikView

Macro not working on server after upgrading to 11.2 SR9

terezagr — Thu, 22 Jan 2015 11:21:19 GMT

Hi all,

we have just recently upgraded to 11.2 SR9. I have inherited an application that has a macro built in it. This macro works fine in Qlikview Client, but does not work ok in WebView and on Server 11.2. SR9.

Funny thing is, that the same macro works on QV 11.2 SR2. Same settings, same variables used - and it is working fine!

All suggestions what I might try to do are welcomed!

Re: Macro not working on server after upgrading to 11.2 SR9

cesaraccardi — Thu, 22 Jan 2015 12:25:05 GMT

Hi,

I would suggest to check the security settings of QVS. You can do that using QMC:

Re: Macro not working on server after upgrading to 11.2 SR9

jerrysvensson — Thu, 22 Jan 2015 12:36:29 GMT

What macro are you using?

Re: Macro not working on server after upgrading to 11.2 SR9

terezagr — Thu, 22 Jan 2015 12:45:12 GMT

Cesar, I am afraid that Allow Unsafe macro execution on server is not solving the issue

Re: Macro not working on server after upgrading to 11.2 SR9

terezagr — Thu, 22 Jan 2015 13:00:12 GMT

sub SwitchToFinancialSelections

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

' Set variable for show conditions

set v = ActiveDocument.Variables("vSelectionType")

v.SetContent "F",true

end sub

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

sub SwitchToDateRangeSelections

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

' Set variable for show conditions

set v = ActiveDocument.Variables("vSelectionType")

v.SetContent "DATE",true

end sub

sub SelectFiscalPeriodRange

set b = ActiveDocument.Variables("vBMTabSelected")

v = ActiveDocument.Variables("vPeriod_Fiscal").GetContent.String

if v <> "-" and b.GetContent.String = 1 Then

search = "<=" & v

ActiveDocument.Fields("Period_Mon").Clear

ActiveDocument.Fields("Period_Fis").Select search

ActiveDocument.Fields("Period_Mon").SelectPossible

ActiveDocument.Fields("Period_Fis").Clear

b.SetContent "0",true

End If

' if the user is on the bm page, set the flag to 1.

if ActiveDocument.ActiveSheet.GetProperties.Name = "BM" Then

'make sure that we only have a single value in Period_Month selected (if it is a range, select the last)

c = ActiveDocument.Variables("vMaxPeriodMonth").GetContent.String

ActiveDocument.Fields("Period_Mon").Clear

ActiveDocument.Fields("Period_Mon").Select "*"&c&"*"

'Update the flag, so we know the user is on this page.

b.SetContent "1",true

end if

end

Re: Macro not working on server after upgrading to 11.2 SR9

jerrysvensson — Thu, 22 Jan 2015 13:09:42 GMT

Strange.

We are actually doing the same 11 SR2 -> 11.2 SR9 at this moment. Almost all apps have macros.

First tests looks fine. We have similar Show/hide macros, also using ActiveSheet property.

Re: Macro not working on server after upgrading to 11.2 SR9

terezagr — Thu, 22 Jan 2015 13:21:30 GMT

what kind of settings do you have on your qvws? Is everything working fine for you in Web View? Do you also use Section Access in your apps?

I have tried following document settings, but all seem not to work in web view:

1. Macro override security = did not work at all

2. Admin override security = it did work when selecting the maxPeriod Month, but than break it when selecting the range

Re: Macro not working on server after upgrading to 11.2 SR9

cesaraccardi — Thu, 22 Jan 2015 13:30:43 GMT

What about the security settings on the edit module window of your document? Is it set to 'System Access'/'Allow System Access'?

Re: Macro not working on server after upgrading to 11.2 SR9

jerrysvensson — Thu, 22 Jan 2015 13:44:49 GMT

We only use WebView.

Section access in all apps.

We have both, Macro and Admin override security.

Re: Macro not working on server after upgrading to 11.2 SR9

terezagr — Thu, 22 Jan 2015 13:50:33 GMT

System Access/Allow System Access - problem still occurs

If I apply both Macro and Admin override security - problem still occurs

Re: Macro not working on server after upgrading to 11.2 SR9

jerrysvensson — Thu, 22 Jan 2015 14:08:59 GMT

On which line does it break?

Re: Macro not working on server after upgrading to 11.2 SR9

terezagr — Thu, 22 Jan 2015 14:31:23 GMT

It breaks on this line in web view:

sub SelectFiscalPeriodRange

set b = ActiveDocument.Variables("vBMTabSelected")

v = ActiveDocument.Variables("vPeriod_Fiscal").GetContent.String

if v <> "-" and b.GetContent.String = 1 Then

search = "<=" & v

ActiveDocument.Fields("Period_Mon").Clear

ActiveDocument.Fields("Period_Fis").Select search

ActiveDocument.Fields("Period_Mon").SelectPossible

ActiveDocument.Fields("Period_Fis").Clear

b.SetContent "0",true

End If

It selects the Max Period Month fine on BM tab, then when i go to next tab where should be selected the period range - there is only selected again Max Period Month. Then I go onto next tab in the app (again there should be the period range) and that is when the pop up message appears saying: Unexpected exception occured!

***This has been tested in Web View

Re: Macro not working on server after upgrading to 11.2 SR9

jerrysvensson — Thu, 22 Jan 2015 14:44:37 GMT

Comment out all lines and then add one at a time to see where it fails.

Like:

set b = ActiveDocument.Variables("vBMTabSelected")

'v = ActiveDocument.Variables("vPeriod_Fiscal").GetContent.String

'if v <> "-" and b.GetContent.String = 1 Then

'search = "<=" & v

' ActiveDocument.Fields("Period_Mon").Clear

' ActiveDocument.Fields("Period_Fis").Select search

' ActiveDocument.Fields("Period_Mon").SelectPossible

' ActiveDocument.Fields("Period_Fis").Clear

' b.SetContent "0",true

'End If

Re: Macro not working on server after upgrading to 11.2 SR9

terezagr — Thu, 22 Jan 2015 16:13:16 GMT

Jerry, I have tried and it seems to cause the error from this point:

ActiveDocument.Fields("Period_Month").SelectPossible

ActiveDocument.Fields("Period_Fiscal").Clear

b.SetContent "0",true

Any suggestions? The SelectPossible seems not to work

Re: Macro not working on server after upgrading to 11.2 SR9

jerrysvensson — Fri, 23 Jan 2015 07:32:21 GMT

Not really.

I would create a test app and try SelectPossible in that. To make sure it is a bug and not a problem in the datamodel.

Re: Macro not working on server after upgrading to 11.2 SR9

terezagr — Fri, 23 Jan 2015 10:06:44 GMT

Seems like the problem is some setting in my Qlikview. I have just asked my colleague to test it in the same version of QV and the macro error message was not coming up for her and all worked fine.

I have double checked with her the document properties and module settings and all seems to be the same..

Re: Macro not working on server after upgrading to 11.2 SR9

terezagr — Fri, 23 Jan 2015 16:58:46 GMT

My colleague pointed me to this direction: http://community.qlik.com/thread/122491

This worked for me too! After removing multiple boxes and current selections boxes and replacing these in the new version of QV - all worked fine! (all tested in WebView, Client, Browser)

Thank you all for your help!