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

[#1]

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

[#2]

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

[#3]

Hi Jgeorge,

I have Windows server 2003 OS in my syatem?

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

Thanks,

Mahasweta

[#4]

Will please someone help me for this issue?

i need this urgent.

Thanks,

Mahasweta

[#5]

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

[#6]

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.

[Anonymous]

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.

[Anonymous]

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