Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Macro parsing failed and the functionality was lost (its in Qlickview server)

Hi All,

I have one Qv document from where i am calling other QV documents through macro.

And my macro is as below,

Sub Absorption

dim SelectedReportPath

set mySelections = ActiveDocument.fields("DESCRIPTION").GetPossibleValues
'Only if one selection is done
if mySelections.Count = 1 then
set FileName = ActiveDocument.fields("PATH").GetPossibleValues
SelectedReportPath = FileName.Item(0).text
Set App = ActiveDocument.GetApplication
Set newdoc = App.Opendoc (SelectedReportPath,"","")
newdoc.Activate
End if
End Sub

This one is working proper in Qlickview developer.

But when I am putting them in QV server its throwing one error, the error is " Macro parsing failed, the functionality was lost"?

Will some one please help me out saying what i am missing here?

Thanks In Advance,

Mahasweta

7 Replies
Not applicable

Macro parsing failed and the functionality was lost (its in Qlickview server)

what is the operating system of your server ?

i have this error message for some macros when using qlikview server on a windows server 2008 machine

usually, macros generating this error on server also generates an error in qlikview developer on vista machine

Not applicable

Macro parsing failed and the functionality was lost (its in Qlickview server)

Hi Jgeorge,

I have Windows server 2003 OS in my syatem?

Could you please suggest me now, what am missing here?

Thanks,

Mahasweta

Not applicable

Macro parsing failed and the functionality was lost (its in Qlickview server)

Will please someone help me for this issue?

i need this urgent.

Thanks,

Mahasweta

Not applicable

SV:Re: Macro parsing failed and the functionality was lost (its in Qlickview server)

Try putting messageboxes in it to see where it fails.

Sub Absorption

dim SelectedReportPath

set mySelections = ActiveDocument.fields("DESCRIPTION").GetPossibleValues
'Only if one selection is done
if mySelections.Count = 1 then
set FileName = ActiveDocument.fields("PATH").GetPossibleValues
msgbox("FileName= " & FileName)
SelectedReportPath = FileName.Item(0).text
msgbox("SelectedReportPath= " & SelectedReportPath)
Set App = ActiveDocument.GetApplication
msgbox("After GetApplication")
Set newdoc = App.Opendoc (SelectedReportPath,"","")
newdoc.Activate
msgbox("After Activate")
End if
End Sub

/Michael

Not applicable

SV:Re: Macro parsing failed and the functionality was lost (its in Qlickview server)

The only time I have seen this error is when the client's ActiveX plug-in was an older version than the Developer and/or Server version.

mov
Esteemed Contributor III

Macro parsing failed and the functionality was lost (its in Qlickview server)

Check your server settings. In server management console, go to QV server settings, security tab. There are two checkboxes for macros:
allow macro execution on server - you need this
allow macro execution on server - you don't need this for the macro in question, but maybe need for another macro.

jsn
Honored Contributor

Macro parsing failed and the functionality was lost (its in Qlickview server)

Can't you just simply use the "Open QlikView Document" action from a button for example? The action is found under the External category.

Community Browser