Stored Process with prompts not displaying

[Quentin]

Hi,

I'm migrating some stored processes from a SAS server running 9.3 to a new server running 9.4M3.

I thought I had everything working, but when I asked a user to test, they can see the stored processes (in SPWA) but when they click a stored process, the prompts don't appear.  All they get is a run button, which does nothing when clicked.

I'm thinking perhaps there is a permissions issue involved, but I'm not seeing it.  THe stored process has a handful of prompts, some are shared and/or dynamic, but some are just simple prompts.  And none of them are showing up for my end user.  But when I click it (or an admin clicks it), the prompts display fine.

Even if one the prompts was dependent upon a data source a user didn't have access to, or even if one of the shared prompts couldn'tbe read, I wouldn't think this would prevent it from displaying all prompts, would it?

I just made a new stored process with a single prompt, and that is showing up fine.

Thanks for any thoughts.

--Q.

[Quentin]

The stored process had one dynamic prompt.  I removed that prompt, and now all the other prompts load fine for the user.

I assume this means one of:

  1. The user does not have metadata permissions to the metadata table used to populate the prompt

  2. The user does not have metadata permissions to the metadata library used to register the metadata table used to populate the prompt

  3. The user does not have OS permissions to the SAS dataset used to populate the prompt.

Today, I weep for not having Metacoda. 

I suppose if I sit down with the user for 30 minutes and have him repeatedly try stuff as I brute force various permissions, I might manage to get it working.  But if it was just a metadata permissions issue, I would think the user would still see all the prompts defined, but some prompts might say "no data available" (or be blank) when the source data couldn't be found.  I know I've seen that before.  Does it make sense these sorts of problems would cause all prompts not to display?

I'm not an admin on this server.  Curious if there are server logs I should ask the admin to review. That is, when this user clicks a stored process in SPWA, which has prompts defined, but none of the prompts are displayed (and all they see is a non-fuctional "run" button), is it likely that the metadata server or stored process server would have thrown some errors when it tried to load the stored processs?

Thanks,

-Q.

[Quentin · Accepted solution]

Well, I think I've got this sorted.

Turns out the metadata permissions and OS permissions were fine.

But the metadata library that had the data for the prompt was not assigned on the correct server. 

It's surprising that it worked when I tested it.  I assume I must have got permission to use the data from some other inheritance path, while the user must have needed to inherit through this metata library.  Also suprised that this caused none of the prompts to load/display.  I assume if I asked the admin to go digging through logs, they would have found errors.