Problem Note 15848: ERROR: "Stored Process Error, Unable to execute stored process. The Personal Repository is not available from the GlobalProfile for user..."
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:
- Select Foundation Services Manager ► ID Portal Local Services ► BIP Local Services OMR ►BIP Information Service. Then, right-click and select Properties.
- In the Information Service Properties window
select the Service Configuration tab. Then, click the
Edit Configuration button.
- In the Information Service Configuration window, select
the Repositories tab. Then, click the WebDAVDemo
Repository.
- Select Edit. On the Edit Information
Service Repository window for the WebDAVDemo Repository, select Auto-Connect. Then, click OK.
- 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
| SAS System | SAS Information Delivery Portal | Microsoft Windows 2000 Datacenter Server | 2.0 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Professional | 2.0 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Server | 2.0 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows NT Workstation | 2.0 | 4.2 | 9.1 TS1M3 SP3 | |
| Microsoft Windows XP Professional | 2.0 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| 64-bit Enabled HP-UX | 2.0 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| 64-bit Enabled Solaris | 2.0 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 2.0 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| 64-bit Enabled AIX | 2.0 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2007-04-23 09:42:52 |
| Date Created: | 2005-07-28 15:48:15 |