topic Cannot Execute stp via Proc stp on specific Appservercontext in Administration and Deployment

Cannot Execute stp via Proc stp on specific Appservercontext

CHandberg — Wed, 31 Jan 2018 14:18:02 GMT

Hi All

I'm trying to execute a STP via Proc Stp using the following code:

proc stp program="MetaPath/MyStp" odsout=store server="MyAppserverContext";

run;

I get this "error" in the log:

NOTE: Credentials for SAS/Connect server were incomplete or not found.

NOTE: The stored process will execute locally.

I've set my Metauser and MetaPass credentials and when I look in the meta-log i'm logged in as usual.

I get no log for the connect-server when executing the proc stp but get a log when I signon and rsubmits.

I've got the right authorization for all folders and servers in metadata. I can execute the STP via a browser without problems.

What to do?

Re: Cannot Execute stp via Proc stp on specific Appservercontext

JudeR — Thu, 01 Feb 2018 20:53:27 GMT

Hello Christian,

The note you are receiving...

NOTE: Credentials for SAS/Connect server were incomplete or not found.

...might be generated if you do not have a password stored in metadata with your metadata identity.

Since the Connect server is not available to PROC STP, it executes the stored process "locally" which means it will execute on the same machine where PROC STP is running. Is your stored process failing to execute or are you concerned about the NOTE statements?

If your stored process fails to execute properly, please open a track with SAS Technical Support and provide the complete log file that is created when you run PROC STP.

To eliminate the note, check your metadata identity using SAS Management Console and the User Manager plug-in. Open the properties for your user identity. Enter (or re-enter) your valid password on the "Accounts" tab. OK out of the user properties. Then rerun the PROC STP step. Do you still get the note that credentials for the Connect server were incomplete or not found?

You can also eliminate the note by specifying the SERVER=LOCAL option on the PROC STP statement, however I realize you already have specified SERVER=your-app-server-context. Remember that your stored process will have an application server context associated with it, so the SERVER= option might not be required.

If you need more information about how PROC STP decides whether to execute the stored process "remotely" or "locally", there is an explanation in the documentation for PROC STP:

http://go.documentation.sas.com/?docsetId=stpug&docsetTarget=p1n8x2zgs6jex1n126j0gi9u61ju.htm&docsetVersion=9.4&locale=en#n1136g12g3pjlqn1uxacdaryvpfh

I hope this helps!
With best regards,
JudeR

Re: Cannot Execute stp via Proc stp on specific Appservercontext

AllanBowe — Sat, 10 Apr 2021 19:54:56 GMT

this fixed it for me - thanks!