SAS 9.2:
I want to create a stored process, but the message (see subject) comes.
Only when I give the user the role "Metadata Server: Unrestricted" (which I surely do not want with an end-user), I can create a stored process.
Happens both in Enterprise Guide and Management Console
No, it wasn't in the name.
The reason was a missing write permission on the "Stored Process Source Directory" object, which is to be found in SMC - Authorization Manager - By Location - (Application Server Name)
I had created a new Application Server object (parallel to SASApp) for a specific group of users, and a SP server under that.
When one then defines a new directory where to store the stored process sources, ths SP Source Dierctory object is automatically created, but does not receive the necessary write permissions.
Once I set write permission for that specific user group, it worked.
I don't suppose there is an & in the name? This note says that was a problem in 9.2.
http://support.sas.com/kb/43/264.html
The note also says there is more info in metadata server log, so perhaps checking that would help.
Those are just guesses. Also probably a good idea to double-check metadata permissions on the metadata directory you are trying to write the stored process to. Maybe make that directory read/writeable by world, just to start. Or make a new metadata directory and try saving a STP in the new directory.
No, it wasn't in the name.
The reason was a missing write permission on the "Stored Process Source Directory" object, which is to be found in SMC - Authorization Manager - By Location - (Application Server Name)
I had created a new Application Server object (parallel to SASApp) for a specific group of users, and a SP server under that.
When one then defines a new directory where to store the stored process sources, ths SP Source Dierctory object is automatically created, but does not receive the necessary write permissions.
Once I set write permission for that specific user group, it worked.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.