topic Re: The stored process api failed to save stored process metadata in Developers

The stored process api failed to save stored process metadata

Kurt_Bremser — Tue, 25 Oct 2016 05:57:33 GMT

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

Re: The stored process api failed to save stored process metadata

Quentin — Wed, 26 Oct 2016 13:08:52 GMT

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.

Re: The stored process api failed to save stored process metadata

Kurt_Bremser — Thu, 27 Oct 2016 06:26:08 GMT

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.