I am attempting to pass existing stored procedures into a SAS program (SAS version 9.4M4) that's executing in batch mode on my org's dedicated SAS Azure server. When submitting Proc STP for my test program within SAS Enterprise Guide, it runs successfully. When I run the program through batch mode using the SASSRV account with highest privileges however, I receive the following error in the log:
Proc STP Program="/Financial Research/AzTest";
Run;
ERROR: Insufficient information provided for a connection to the metadata server.
ERROR: Failed to connect to the metadata server.
NOTE: PROC_STP: ====== Proc STP Execution Ending ======
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE STP used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
When I saw this error, I added the following before Proc STP:
Options MetaServer='server address' MetaPort=**** MetaUser=sassrv MetaPass=**************;
Rinse, repeat, and received this error in the log:
ERROR: Stored Process /Financial Research/AzTest does not exist.
For this specific test stored process, I added 'Read Metadata' authorization for the SAS General Servers user group in SAS Management Console so that the SASSRV user could have read access to the metadata in the event that was the issue...but to no avail.
I feel like it has to do with some kind of permissions issue between the SASSRV account and the metadata, but I'm stumped. Any help is appreciated!
I don't think you can use `sassrv` as your metadata identity, precisely because it is a service account in the General Servers group.
I'd suggest creating a new SAS identity (eg sasbatch) and use those credentials to connect to metadata instead.
I don't think you can use `sassrv` as your metadata identity, precisely because it is a service account in the General Servers group.
I'd suggest creating a new SAS identity (eg sasbatch) and use those credentials to connect to metadata instead.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.