Macro not working on server after upgrading to 11.2 SR9

[terezagr]

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!

T.

[cesaraccardi]

Hi,

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

[jerrysvensson]

What macro are you using?

[terezagr]

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

[terezagr]

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

[jerrysvensson]

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.

[terezagr]

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

[cesaraccardi]

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

[jerrysvensson]

We only use WebView.

Section access in all apps.

We have both, Macro and Admin override security.

[terezagr]

System Access/Allow System Access - problem still occurs

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