BookmarkSubscribeRSS Feed
Obsidian | Level 7

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";



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?

SAS Employee

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:

I hope this helps!
With best regards,

Barite | Level 11
this fixed it for me - thanks!
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 3 in conversation