Deploying stored proces with FMQuery as webservice - only the webservice call fails

Reply
New Contributor
Posts: 2

Deploying stored proces with FMQuery as webservice - only the webservice call fails

Hi.

 

I'm somewhat puzzled by the fact that i have written a simple stored proces that uses SAS Financial Management macros to extract model members and facts from SAS Financial Management using the SAS supplied finance macros located in ..\SASHome\SASFoundation\9.4\finance\sasmacro.

 

When running the stored proces from SAS Information Delivery Portal it works just fine, but when i deploy it as a webservice and calls that from SOAPUI i get the errors

 

MLOGIC(EXECUTEMODELFUNCTION):  Beginning execution.
MLOGIC(EXECUTEMODELFUNCTION):  %PUT QUERY PARAMS: &funcNameAndArgs
SYMBOLGEN:  Macro variable FUNCNAMEANDARGS resolves to "getModelMembers", 'EKSTERNT REGNSKAB'
QUERY PARAMS: "getModelMembers", 'EKSTERNT REGNSKAB'
SYMBOLGEN:  Macro variable ENVIRONMENT resolves to ""
MLOGIC(EXECUTEMODELFUNCTION):  %IF condition &environment ne "" is FALSE
SYMBOLGEN:  Macro variable LOCALE resolves to "default"
MLOGIC(EXECUTEMODELFUNCTION):  %IF condition &locale ne "default" is FALSE
SYMBOLGEN:  Macro variable DELIM resolves to ';'
SYMBOLGEN:  Macro variable FUNCNAMEANDARGS resolves to "getModelMembers", 'EKSTERNT REGNSKAB'
SYMBOLGEN:  Macro variable OUTPUTDATASETNAME resolves to 'query_parm_accounts'
SYMBOLGEN:  Macro variable SASLIBNAME resolves to 'Work'

NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

MLOGIC(EXECUTEMODELFUNCTION):  Beginning compilation of FILETODS using the autocall file D:\Program Files\SASHome\SASFoundation\9.4\finance\sasmacro\filetods.sas.
MLOGIC(EXECUTEMODELFUNCTION):  Ending compilation of FILETODS.
MLOGIC(FILETODS):  Beginning execution.
MLOGIC(FILETODS):  This macro was compiled from the autocall file D:\Program Files\SASHome\SASFoundation\9.4\finance\sasmacro\filetods.sas
WARNING: Apparent symbolic reference OUTPUTFILE not resolved.
WARNING: Apparent symbolic reference OUTPUTLIBNAME not resolved.
WARNING: Apparent symbolic reference OUTPUTDSNAME not resolved.
SYMBOLGEN:  Macro variable DELIM resolves to ';'
MLOGIC(FILETODS):  Parameter INFILENAME has value &outputFile
MLOGIC(FILETODS):  Parameter OUTPUTLIBNAME has value &outputLibName
ERROR: The text expression &OUTPUTLIBNAME contains a recursive reference to the macro variable OUTPUTLIBNAME.  The macro variable will be assigned the null value.
MLOGIC(FILETODS):  Parameter OUTPUTDATASETNAME has value &outputDSName
                                                                                          

 

 

 

Any idea's as to what i'm missing?

 

This is the code invoking the macro's

 

%MODEL;

%GETMODELMEMBERS ('Work', 'query_parm_accounts', 'EKSTERNT REGNSKAB');
Ask a Question
Discussion stats
  • 0 replies
  • 93 views
  • 0 likes
  • 1 in conversation