Can not create Store Process from an EG-project with prompts

[AndersBergquist]

I have finalized a EG-project I want to publish as a Store Process. The problem is I got this error message:

"Unable to make a connection to the metadata server possibly due to missing or bad OMR configuration file(s)."

Searching on Googles point me to a note on SAS homepage which tell me it is a problem with prompts, but not what problem and how to solve the problem.

Can someone help me?

[AndersBergquist]

After some investigation, I think everything come done to the fact that Store Processes is not compatible with EG conditional processing.

[AndersBergquist]

Problem solved.
It is a bug in SAS which does only accept US letters in the branchnames. I will rapport this to support.

[AndersBergquist]

Problem is not solved.
I think Store Processes does not support Conditional processing.

[saspert]

Is there any SAS Usage note regarding this? My client is facing a similar issue.

[jakarman]

is it a dynamic prompt using a dataset as input (9.2 and later)?

In that case there are undocumented requirements possible indicating a design/coding error by SAS institute.

[ShenQicheng]

Hi, Jaap

The same error occured in my EG project that have a dynamic prompt using a dataset. (EG 6.1)

Where can I get the undocumented requirements that you mentioned?

Or should I ask tech support?

Thanks inadvance.

Shen

[jakarman]

You should surely contact TS for that.

The directio I am aiming at is that conditional prompts dynamic prompts are processed before your process has been started. Not necessary sharing the same Sas session or even not necessary sharing the same app server.

When that is the real root cause that is a sas design and sas implemtation error. The common behavior of SAS TS is avoiding that kind of internal Sas trouble and going for bypasses instead.

So be sure on what you requirements are and implementation is.

[ShenQicheng]

Thanks, Jaap

I'll contact TS for that.

[jwillis]

I had a similar issue and developed a workaround.

*Make certain that your code contains the following *ProcessBody;   %stpbegin;   %stpend; statements in the right places.

*Make certain that your code defines all macro variables as global.  This works best for me if I place the %global before the *ProcessBody;.

*Have a general understanding of the macro %_eg_WhereParam

*If your macro variable can contain many values, be sure to understand the macroname0, macroname and &macroname_count macro variables.  My macro variable is named      brand.  The Stored Process prompt returned the macro variables "brand", "brand0" and "brand_count".  The number of brand variables I found are brand1 to brand&brand_count.

%macro bildin(bran=&brand.);

%let sp = ,;

%if %sysevalf(&brand_count) = %sysevalf(1) %then %do;

       %let brandlst = "&bran.";

%end;

%else %do;

    %let brandlst =;

    %do k = 1 %to %sysevalf(&brand_count.);

      %if &k. = 1 %then %let brandlst = %quote("&&brand&k.");

      %else %let brandlst = %qsysfunc(catx(%quote(&sp.),&brandlst.,%QUOTE("&&brand&k.")));

    %end;

    %if k = %sysevalf(&brand_count.) %then %do;

        %let brandlst = %quote(&brandlst.);

    %end;

%end;

%mend bildin;

%bildin;

I used the &brandlist macro this way.

WHERE t1.BRAND NOT IS MISSING

        AND t1.BRAND IN 

           (

           %UNQUOTE(&BRANDLST.)

           )