Tag: OBIEE

OBIEE Oracle Support Notes – Useful One.

Posted on by Osama Mustafa in Fusion Middleware
A list of Information Centers:

  • Note 1378677.2 – Information Center: Enterprise Performance Management and BI Index (EPM/BI)
  • Note 1349989.2 – Information Center: Installing and Configuring Oracle Business Intelligence Enterprise Edition Release 10g and Later
  • Note 1349996.2 – Information Center: Optimizing Performance for Oracle Business Intelligence Enterprise Edition Release 10g and Later
  • Note 1349983.2 – Information Center: Oracle Business Intelligence Enterprise Edition (OBIEE) Release 10g and Later
  • Note 1350005.2 – Information Center: Security Information for Oracle Business Intelligence Enterprise Edition Release 10g and Later

List of Notes that may be useful :-

Note 1210310.1 – Master Note for Answers and Dashboards Issues in OBIEE
Note 1292894.1 – Master Note for BI Publisher Issues in OBIEE
Note 1292859.1 – Master Note for Briefing Book Issues in OBIEE
Note 1292904.1 – Master Note for Cache Issues in OBIEE
Note 1292936.1 – Master Note for Clustering Issues in OBIEE
Note 1293348.1 – Master Note for Crash/Hang Issues in OBIEE
Note 1293505.1 – Master Note for Data Warehouse Issues in OBIEE
Note 1293334.1 – Master Note for Disconnected Analytics Issues in OBIEE
Note 1265441.1 – Master Note for OBIEE 10g and 11g Essbase Integration issues (Doc ID )
Note 1293329.1 – Master Note for Integrated Security Issues in OBI Applications
Note 1248939.1 – Master Note for OBIEE 10g Integration with EBS, Siebel, SSO, Portal Server, Peoplesoft
Note 1301946.1 – Master Note for Internationalization and Globalization Issues in OBIEE
Note 1293391.1 – Master Note for iPhone BI Apps Issues in OBIEE
Note 1293337.1 – Master Note for Mapviewer Issues in OBIEE
Note 1293391.1 – Master Note For Oracle Business Intelligence Mobile Applications (iPhone/iPad) Issues in OBIEE
Note 1293344.1 – Master Note for Multi-user Development Issues in OBIEE
Note 1293301.1 – Master Note for Office Integration Issues in OBIEE
Note 1364889.1 – Master Note For OBIEE use with OPatch
Note 1293374.1 – Master Note for Performance Issues in OBIEE
Note 1293435.1 – Master Note for Presentation Server Administration Issues in OBIEE
Note 1293384.1 – Master Note for Repository Design Issues in OBIEE
Note 1293351.1 – Master Note for Scorecard & KPI Issues in OBIEE
Note 1293407.1 – Master Note for Security/Access Control Issues in OBIEE
Note 1293411.1 – Master Note for Server Execution Issues in OBIEE
Note 1293394.1 – Master Note for SOAP API Issues in OBIEE
Note 1293424.1 – Master Note for System Configuration EM/JMX Issues in OBIEE
Note 1293415.1 – Master Note for Usage Tracking Issues in OBIEE
Note 1293477.1 – Master Note for Webcat Replication Issues in OBIEE
Note 1293490.1 – Master Note for Write Back Issues in OBIEE
Note 1307975.1 – Summary Note About OBIEE 10.1.3.4.1 Patch 9492821: Information Applicable Prior To, Or After, Install
Note 1391648.1 – OBIEE11g: Installation, Migration and Upgrade Hints and Tips
Note 1589028.1 – Master Note For Oracle Hyperion Smart View For Office Issues in OBIEE

NOTE:1293490.1 – Master Note for Write Back Issues in OBIEE
NOTE:1293505.1 – Master Note for Data Warehouse Issues in OBIEE
NOTE:1301946.1 – Master Note for Internationalization and Globalization Issues in OBIEE
NOTE:1349983.2 – Information Center: Oracle Business Intelligence Enterprise Edition (OBIEE) Release 10g and Later
NOTE:1349989.2 – Information Center: Installing and Configuring Oracle Business Intelligence Enterprise Edition Release 10g and Later
NOTE:1349996.2 – Information Center: Optimizing Performance for Oracle Business Intelligence Enterprise Edition Release 10g and Later
NOTE:1350005.2 – Information Center: Security Information for Oracle Business Intelligence Enterprise Edition Release 10g and Later
NOTE:1364889.1 – Master Note For OBIEE use with OPatch
NOTE:1378677.2 – Information Center: Business Analytics Index (EPM/BI)
NOTE:1293391.1 – Master Note For Oracle Business Intelligence Mobile Applications (iPhone/iPad) Issues in OBIEE
NOTE:1293394.1 – Master Note for SOAP API Issues in OBIEE
NOTE:1293407.1 – OBIEE 11g: Master Note for Security/Access Control Issues
NOTE:1293411.1 – Master Note for Server Execution Issues in OBIEE
NOTE:1293415.1 – Master Note for Usage Tracking Issues in OBIEE
NOTE:1293424.1 – Master Note for System Configuration EM/JMX Issues in OBIEE
NOTE:1293435.1 – Master Note for Presentation Server Administration Issues in OBIEE
NOTE:1293477.1 – Master Note for Webcat Replication Issues in OBIEE
NOTE:1210310.1 – Master Note for Answers and Dashboards Issues in OBIEE
NOTE:1248939.1 – Master Note for OBIEE 10g Integration with EBS, Siebel, SSO, Portal Server, Peoplesoft
NOTE:1265441.1 – Master Note for OBIEE 10g and 11g Essbase Integration issues
NOTE:1267009.1 – Oracle Business Intelligence Enterprise Edition (OBIEE) Product Information Center (PIC)
NOTE:1292859.1 – Master Note for Briefing Book Issues in OBIEE
NOTE:1292894.1 – Master Note for BI Publisher Issues in OBIEE
NOTE:1292904.1 – Master Note for Cache Issues in OBIEE 10g and 11g
NOTE:1292936.1 – Master Note for Clustering Issues in OBIEE 10g and 11g
NOTE:1293301.1 – Master Note for Office Integration Issues in OBIEE
NOTE:1293329.1 – Master Note for Integrated Security Issues in OBI Applications
NOTE:1293334.1 – Master Note for Disconnected Analytics Issues in OBIEE
NOTE:1293337.1 – OBIEE: Master Note for Mapviewer Issues
NOTE:1293344.1 – Master Note for Multi-user Development Issues in OBIEE
NOTE:1293348.1 – Master Note for Crash/Hang Issues in OBIEE 10g and 11g
NOTE:1293351.1 – Master Note for Scorecard & KPI Issues in OBIEE
NOTE:1293374.1 – Master Note for Performance Issues in OBIEE
NOTE:1293384.1 – Master Note for Repository Design Issues in OBIEE
NOTE:1589028.1 – Master Note For Oracle Hyperion SmartView (Smart View) For Office Issues in OBIEE

Cheers
And Enjoy Reading 
Osama mustafa

System is in manitance mode. Please try again later OBIEE

Posted on by Osama Mustafa in Fusion Middleware
When trying to update any reports in OBIEE the below errors appears :-

to solve this issue just follow the screen :-

1- Access to OBIEE Link http://ip-hostname:9704/analytics
2- Choose Administration from the upper right corner.

3- Turn Maintenance mode to off by press the link.

Good Luck.

Cheers
Osama

Invalid User name and password OBIEE 11g (Analytics)

Posted on by Osama Mustafa in Fusion Middleware
When trying to Access to the URL:// hostname:9704/analytics with username weblogic the below error generated in the Adminserver logs :-

java.security.AccessControlException: access denied (oracle.security.jps.service.credstore.CredentialAccessPermission context=SYSTEM,mapName=oracle.bi.system,keyName=system.user read)
at java.security.AccessControlContext.checkPermission(AccessControlContext.java:374)
at java.security.AccessController.checkPermission(AccessController.java:546)
at oracle.security.jps.util.JpsAuth$AuthorizationMechanism$3.checkPermission(JpsAuth.java:463)
at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:523)
at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:549)
at oracle.security.jps.internal.credstore.util.CsfUtil.checkPermission(CsfUtil.java:684)
at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.getCredential(SspCredentialStore.java:562)
at oracle.bi.security.opss.CredentialReader.getPasswordCredential(CredentialReader.java:69)
at oracle.bi.security.opss.CredentialReader.getPasswordCredential(CredentialReader.java:57)
at oracle.bi.security.service.SystemUserValidator$ReadSystemUserCredentialsAction.run(SystemUserValidator.java:291)
at oracle.bi.security.service.SystemUserValidator$ReadSystemUserCredentialsAction.run(SystemUserValidator.java:278)
at oracle.bi.security.service.SystemUserValidator.readSystemUserCredential(SystemUserValidator.java:186)
at oracle.bi.security.service.SystemUserValidator.validateSystemUserCredentials(SystemUserValidator.java:146)
at oracle.bi.security.service.SystemUserValidator.access$000(SystemUserValidator.java:26)
at oracle.bi.security.service.SystemUserValidator$1.run(SystemUserValidator.java:107)
at oracle.bi.security.service.SystemUserValidator$1.run(SystemUserValidator.java:101)
at oracle.bi.security.service.SystemUserValidator.validate(SystemUserValidator.java:117)
at oracle.bi.security.service.SecurityServiceBean.initialise(SecurityServiceBean.java:89)
at oracle.bi.security.service.SecurityServiceBean.getAuthenticatedUserWithLanguageAndProperties(SecurityServiceBean.java:129)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

If you recive the above error, you don’t have permission to access to the analytics, permission saved  in Files called

system-jazn-data.xml

Located :-

 $DOMAIN_HOME/config/fmwconfig

Edit the files and add these lines :-

   

Or copy this file from another OBIEE Environment after backup the old one, and restart AdminServer and managed Server

Thank you
Osama Mustafa