Issues related to the OBIEE.

Troubleshooting

Problem

Unable to create user id and groups in OBIEE 10.1.3.4.1

Solutions

On the Obiee server , I have edited the configuration file : xmlp-server-config.xml from path OracleBIxmlpXMLPAdminConfiguration .



Changed the below property to:

<property name=”SECURITY_MODEL” value=”XDO”/>

---

Problem

Once we have configured Obiee Schedular with the analytics.war file deployed on Weblogic Server and if the Schedular Database is not up, then the analytics application will not come into active state and weblogic server will throw the below errors :

Message icon - Error An error occurred during activation of changes, please see the log for details.
Message icon - Error [HTTP:101216]Servlet: "QuartzInitializer" failed to preload on startup in Web application: "xmlpserver". org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ORA-00942: table or view does not exist [See nested exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ]] at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493) at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.quartz.ee.servlet.QuartzInitializerServlet.init(QuartzInitializerServlet.java:157) at oracle.apps.xdo.servlet.scheduler.quartz.ExtendedQuartzInitializerServlet.init(ExtendedQuartzInitializerServlet.java:124) at

Soultion:

Replace the file XMLP/Admin/Scheduler/quartz-config.properties by the original file (before install Schedule Schema). The server can be started and everything works

---

Issue

While starting the oc4j publishing server below errors were being received and service was not starting:

[nQSError: 46116] The locale EN_US.UTF-8 needs to be installed on the machine for the Oracle BI locale setting English-usa specified in NQSConfig.INI.



WORKAROUND

Installed the EN_US.UTF-8 Locale on AIX.

 

---

Issue

OC4J JAS instance not shutting down properly when the below command was used to shutdown the oc4j service:

oc4j -shutdown -port 23791 -password oc4jadmin

Below errors were received:

java.lang.NullPointerException at com.evermind.server.ObjectReferenceCleaner.cleanupApplicationLogLevels(ObjectReferenceCleaner.java:145)

 

WORKAROUND: Changed the JAVA_HOME option in oc4j script from java 1.6 to java 1.5.