Your SAS programs, embedded in web apps and elsewhere

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

Reply
Contributor
Posts: 44

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

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?
Contributor
Posts: 44

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

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

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

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

Problem not solved

Problem is not solved.
I think Store Processes does not support Conditional processing.
Super Contributor
Posts: 269

Re: Problem not solved

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

Valued Guide
Posts: 3,208

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

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.

---->-- ja karman --<-----
Contributor
Posts: 26

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

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

Valued Guide
Posts: 3,208

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

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.

---->-- ja karman --<-----
Contributor
Posts: 26

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

Thanks, Jaap

I'll contact TS for that.

Regular Contributor
Posts: 217

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

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.)

           )

Ask a Question
Discussion stats
  • 9 replies
  • 1556 views
  • 0 likes
  • 5 in conversation