Skip to main content

How to do perform troubleshooting in OBIEE

By

 



Troubleshooting Services


Service = Oracle BI Java Host





1. Oracle BI Java Host service is not running, check Services.


2. Important for initial installation for OBIEE servers. Can be turned back to original settings after OBIEE installation.


Before you install the OBIEE software on a Windows 2003 server make sure you "Turn on Data Execution Prevention (DEP) for essential Windows programs and services only.‟ This located on the Advanced tab of the System Properties. In addition, install the Microsoft .NET Framework 2.0





1) Experiment with stopping the Oracle BI Java Host service and running a report with a chart.


2) Locate where to change the DEP settings.





1. If the location of the Java SDK folder location changes or is renamed while the Oracle BI Java Host is running it will have no impact. Only after the service is restarted will Analytics notice the change.





2. The instanceconfig.xml file tells the service where to locate the Java SDK.


Service = Oracle BI Server






1. Check the log file every other day for suspicious or error messages.


2. If there‟s an incorrect entry in the NQSConfig.ini file the service will not start.






1) Restart the Oracle BI Server service and view the log file.


2) In the configuration file enter the name of a repository that does not exist, restart the service and view the log.



Service = Oracle BI Presentation ServerAlways








1. After checking the \OracleBIData\web\log\sawlog.log, check the Event Viewer for suspicious or error messages.


2. If there‟s an entry in the instanceconfig.xml file to a webcat that does not exist a new webcat will be created.


3. Always stop the BI Presentation service before stopping the BI Server service.



Service = Oracle BI Scheduler 






1. Check for suspicious entries or errors in the \OracleBI\Server\Log\NQScheduler.log the same time you are looking at the other logs.


2. Check the Data Source Name to make sure it works as expected.






3. If the Administrator Name (SchedulerAdmin) password was recently changed and the Job Configuration screen was not updated then the Scheduler service will not start.






Forgetting the OC4J Password


OC4J password is necessary to uninstall or upgrade OBI. If the password is forgotten or lost, please use following steps to reset the OC4J password:


1.Navigate to the <oc4j_root>/j2ee/home/configdirectory 

2. Backup the file: system-jazn-data.xml for restore or later reference 

3. Edit the file: system-jazn-data.xmla. 

    a. Locate the following entries…

    <user>

        <name>oc4jadmin</name>

       <display-name>OC4J Administrator</display-name>

       <description>OC4J Administrator</description>

     credentials>{903}MMGWnYKcnMKBBOR1LroHHrQpy3zmVbGEohN4aUSjxK4=        </credentials>

     </user>

    b. …and add the XML attribute deactivated="true", as shown below: 

    <user deactivated="true">

     <name>oc4jadmin</name>

     <display-name>OC4J Administrator</display-name>

     <description>OC4J Administrator</description>

     credentials>{903}MMGWnYKcnMKBBOR1LroHHrQpy3zmVbGEohN4aUSjxK4= 

     </credentials>

     </user>


4.When you next start the oc4j instance using "oc4j -start" the container will re-prompt you for the password and add the newly encrypted password to the <credentials> tag in the oc4jadmin entry.



Oracle Resources

My Oracle Support


My Oracle Support = https://support.oracle.com/CSP/ui/flash.html





1. Enter the topic, subject, keyword, error message, etc that you are researching and click Go. If many results are returned try adding the word „Analytics‟ to your search to further refine the results. 


2. Select a specific topic to view or search entries.


3. If you have a question or issue that you cannot find an answer to then open a SR (Service Request).



Oracle Technology Network


Oracle Technology Network (OTN) is a means to download any of Oracle‟s products, including new releases and patches for free as long as the software is not used in any production environment. Example on how to download and install OBIEE on Windows.

1.Go tohttp://www.oracle.com/technology/software/index.html

2.Click „Oracle Business Intelligence Suite EE‟ under the Middleware section.

3.Agree to the download agreement.

4.Typically, only the latest version of OBIEE is available for download.

5.Click on Oracle Business Intelligence Enterprise Edition v…..

6.Download the individual file.

7.Extract to your computer.

8.Run EXTRACTED FOLDER\SERVER\Oracle_Business_Intelligence\setup.exe and follow the install instructions that are part of the 402 –Day 1 training materials.



If you need a license code for any product go to: http://licensecodes.oracle.com

Note: OBIEE does not need a license code.

Labels:

Comments

Post a Comment

Popular posts from this blog

Contact Me

By
Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com
3 comments
Read more

Top 130 SQL Interview Questions And Answers

By
1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10
32 comments
Read more

Informatica sample project

By
Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope
Post a Comment
Read more