Presentation Services Access Denied Issue

During migration or copying of presentation web catalogs, some will no doubt come across this error for users when they log in:

access denied for user to path/users/{username}/_portal/dashboard layout

What this generally is saying is that the user does not have access to their dashboard or any dashboard.  They could type ‘answers’ after the ‘?’ in the URL and be able to access answers, if they have that privilege.  Pretty much what happened is that the migration/copy of the web catalog user folder did not copy the users’ permissions correct.

If you want, you could open the source web catalog that was copied and the web catalog that has the issue via cat manager and see the permissions for that user folder for each web catalog.  You should see that the permissions are different.

Now to fix the issue.  It is pretty simple, open cat manager and set permissions for the user’s folder to that user.  So the user needs at least ‘Change/Delete’ permissions on that folder and have this permission set recursively to sub-items and sub-folders.

And that should fix it.

OBIEE Services

OBIEE Services and Process

OBIEE Services & Process:

Technical Details

Below is the list of components which runs as server in OBIEE.

1) Oracle Business Intelligence Server (Oracle BI Server)

2) Oracle Business Intelligence Presentation Services (Oracle BI Presentation Server)

3) Oracle Business Intelligence Javahost (Oracle BI Java Host)

4) Oracle Business Intelligence Scheduler (Oracle BI Scheduler)

5) Oracle Business Intelligence Cluster Controller ( Oracle BI Cluster Controller)

If you followed the default installation then first 3 service will have start up type as Automatic and 4th and 5th will have start up type as Manual.

Please note that in Oder to enable Scheduler and Cluster Controller additional configuration is required. That will be discussed in separate post.

Below Screen print shows those services.

OBIEE Services

If changes have been made to Oracle BI serve’s configurations, repository files, Web Catalog for Answers , other configurations etc then above services needs restart.

Please not that order in which services are being restarted is very important. And it is as below.

1) Oracle Business Intelligence Server (Oracle BI Server)

2) Oracle Business Intelligence Presentation Services (Oracle BI Presentation Server)

3) Oracle Business Intelligence Javahost (Oracle BI Java Host)

4) Oracle Business Intelligence Scheduler (Oracle BI Scheduler)

5) Oracle Business Intelligence Cluster Controller ( Oracle BI Cluster Controller)

Important this is not all services needs restart each time you make any of the changes describe. It mainly depends on the changes you are making.