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

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

AndersBergquist — Wed, 06 Apr 2011 19:12:07 GMT

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?

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

AndersBergquist — Thu, 07 Apr 2011 06:27:27 GMT

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

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

AndersBergquist — Thu, 07 Apr 2011 06:30:20 GMT

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

Problem not solved

AndersBergquist — Thu, 07 Apr 2011 07:03:47 GMT

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

Re: Problem not solved

saspert — Mon, 15 Jul 2013 20:20:53 GMT

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

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

jakarman — Fri, 02 Aug 2013 12:58:21 GMT

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.

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

ShenQicheng — Tue, 30 Jun 2015 10:23:50 GMT

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

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

jakarman — Tue, 30 Jun 2015 12:28:34 GMT

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.

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

ShenQicheng — Tue, 30 Jun 2015 12:57:08 GMT

Thanks, Jaap

I'll contact TS for that.

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

jwillis — Tue, 30 Jun 2015 19:35:07 GMT

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;

%mend bildin;

%bildin;

I used the &brandlist macro this way.

WHERE t1.BRAND NOT IS MISSING

AND t1.BRAND IN

(

%UNQUOTE(&BRANDLST.)

)