Catalog Manager > Right Click on "/" > Click Permissions > Under explicit permissions, authenticateduser had "open". Change it Full Control and then check on the box for Apply Recursively and click OK. Thats it.
Or check this link https://blogs.oracle.com/pa/entry/obiee_11_1_1_web
If helps pls mark as correct or helpful
Edited by: veeravalli on Nov 6, 2012 4:02 PM
No updates on this and created a new post for same topic?!!!
When the catalog is moved from Dev to Test/prod permissions are not copied. The users are part of the system folder (i.e Catalog Manager > Users > Properties > Owner Account = System Account), which is why Catalog Manager does not transfer the permissions.
I guess that is the reason you were able to run the reports from dev and not from test/prod. To have them work you might need to refresh GUID's check the Oracle note [ID 1467256.1].
1. Stop the Presentation Server.
2. Backup the instanceconfig.xml file at [middleware_home]/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/instanceconfig.xml
Under the 'Catalog' section, add the 'Recover' tag. For Example:
You should able to do offline mode, try to stop the Presentation service and give permissions. If you dont see any affects then it might be SSL security.
Make sure you set the CredentialStore tag in instanceconfig.xml
BTW: Java version also matters during SSL, jdk1.7.0_03 is good one to go too.