If you attempt to run a stored process from the BI Portal and the stored process has an output type of "Transient Result Package", you might receive the following error message:

   Stored Process Error
   Unable to execute stored process.
   The Personal Repository is not available from the GlobalProfile
   for user <logon user name here>.

This error message usually means that the user is not connected to the WebDAV repository. The problem might occur because the WebDAV server repository definition is not marked as "autoconnect" in the "BIP Information Service" configuration metadata. To correct this problem, follow these steps in the SAS^® Management Console:

1. Select Foundation Services Manager ► ID Portal Local Services ► BIP Local Services OMR ►BIP Information Service. Then, right-click and select Properties.
2. In the Information Service Properties window select the Service Configuration tab. Then, click the Edit Configuration button.
3. In the Information Service Configuration window, select the Repositories tab. Then, click the WebDAVDemo Repository.
4. Select Edit. On the Edit Information Service Repository window for the WebDAVDemo Repository, select Auto-Connect. Then, click OK.
5. Retart your SAS Remote Services application and your middle-tier server.

Another circumvention is to change the stored process output type to "Streaming" rather than "Transient Result Package".

Operating System and Release Information