Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Tuesday, July 28, 2009

Issues and Fixes with OBIEE

For Installation of the OBIEE please follow my previous post http://balajiabhi.blogspot.com/2009/07/installation-and-configuration-of-obiee.html


Issue:
The login page failed to login using Administrator/Administrator
Fix:
1. Shutdown the oc4j using
$(ORACLE_BI_HOME)/setup/oc4j

oc4j will give the options like
-start
-shutdown -port (ORMI Port) -password (Password which you gave during the installation) for oc4jadmin

ORMI Port:
Locate rmi.xml in the
$ORACLE_BI_HOME/oc4j_bi/j2ee/home/config/rmi.xml
Inside you can get the port of the ORMI Port.
In my case it was 23971
I stopped oc4j
like

ORACLE_BI_HOME/setup/oc4j -shutdown -port 23971 -password Welcome1
Shutdown OC4J instance...

The locate the xmlp-server-config.xml inside
$ORACLE_BI_HOME/ xmlp/ XMLP/ Admin/ Configuration /xmlp-server-config.xml

Change the variableproperty name=”SECURITY_MODEL” value=”BI_SERVER“/
TO
property name=”SECURITY_MODEL” value=”XDO“/
3. Restart the oc4j from
$ORACLE_BI_HOME/setup/oc4j -start
Now the Administrator/Administrator will work
You can now navigate to Admin page from welcome page.

Issue 2:
When you access the Dashboard from the OBIEE Page, you may encounter

500 Internal Error: - servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

I resolved the issue like this:
1. Edit ./oc4j_bi/j2ee/home/applications/analytics/analytics/WEB-INF/web.xml

Replace the port as 9703 instead of 9710

2. Go to $ORACLE_BI_HOME/setup/

$run-sa.sh stop

wait for 10 seconds

$run-saw.sh stop

wait for 10 seconds

$run-sa.sh start

$run-saw.sh start.

Now click on the application Dashboard. It will work fine.


6 comments:

Anonymous said...

Hey could you be a little bit specif...am using oracle 11g and i wasn't able to find the port and further more i didn't understand about the $run-sa.sh stop

wait for 10 seconds

$run-saw.sh stop

wait for 10 seconds

$run-sa.sh start

$run-saw.sh start.
i would be glad for your help.I am a newbie....

shreyas said...

Hi,
i have already XDO parameter in the xml file as you said.
But i am still not able to login my 10.1.3.4.2 upgraded BI from 10.1.3.4.0. I am unable to login.

Help me on this .

Balaji Srinivasan said...

@Shreyas,

Sorry for the delayed response.

Could you please send me the error from the access log or from the oc4j? did you follow the document from oracle?

http://docs.oracle.com/cd/E10415_01/doc/bi.1013/e10416.pdf

-Balaji Srinivasan.

shreyas said...

Hi Sir,
The issue is solved. i am able to login now. i have added path in xmlp-server-config.xml file so.
But after upgradation from 10.1.3.4.0 to 10.1.3.4.2, template files are not generating (User > Report > Layouts > Auto Generate Layout). it gives error 'Failed to Load Auto Layout'.

application.log says:

End tag does not match start tag 'group'.
at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:320)
at oracle.xml.parser.v2.NonValidatingParser.parseEndTag(NonValidatingParser.java:1395)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1340)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:362)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:308)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:306)
at oracle.apps.xdo.dataengine.DataProcessor.getSQLRTFLayout(Unknown Source)
at oracle.apps.xdo.dataengine.DataProcessor.writeDefaultLayout(Unknown Source)
at oracle.apps.xdo.servlet.resources.ResourceServlet.createAutoLayout(ResourceServlet.java:288)
at oracle.apps.xdo.servlet.resources.ResourceServlet.service(ResourceServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.jav:303)


i am not able to troubleshoot this issue since 1 week and it is become critical now. Please help me on this.

Balaji Srinivasan said...

Hi Shreyas

Please follow the thread

https://forums.oracle.com/forums/thread.jspa?threadID=431752&tstart=0

it may be helpful to you.

shreyas said...

Hi Sir,
The thread you have provided is for report builder issue. i have different thing.
The error i got is still exists. i have not edited any xml file as well after upgradation .
So what should be done.

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Labels

11.5.1. to 11.5.5 Cloning Procedure. 11g 11i 11i and R12 11i Autoconfig 11i Cloning 12.1.1 SSL 2 Node RAC Adconfig.sh errors out adgennls.pl adop Advanced Replication Apache version Apex Apex for Oracle database Apex Installation Apex Installation on Oracle E Business Suite. 11i with Apex Apex on 11i Apex on Oracle 11i Apex402 apexins.sql APPL_TOP Character Application Express Application server Issue APPLSYS password Apps Password Asynchronous Replication Autoconfig Autoconfig Managed Beehive Bit of operating system Block block media corrupt BPEL Central Inventory Character Set Conversion Cloning of 11i Cloning of Oracle Applications Clusterware Concurrent CPU 2011 CPU 2012 April CPU 2012 January. CPU 2012 October CRS custom top Custom Top Creation Database . Database Query Dataguard DBMS_REPAIR Demantra . Domain Name E Business Suite Migration EBS 12.2 EPM exp/imp Oracle Applications Flashback table flows_020200 FND_TOP/resource FNDCPASS FNDCPUCF Forms server upgrade Forms startup FRM-92101 Fusion Middleware Hostname Hot Backup Hot cloning HotBackup Hotbackup Cloning of Oracle Apps hrglobal.drv. NLS Saudi Arabian HRMS hyperion Import and Export Oracle Applications Install Oracle Installation of R12 Installation Steps integration Oracle EBS Issues Database issues Oracle EBS Issues with Upgrade 12.1.1 Java Mission Control Java Upgrade java/sql/SavePoint JInitiator Junk Characters Language Translation Linux Linux Migration listener trace Listner version Local Inventory Login Page Master-Master Replication Memory Tuning Multiple Language NLS Non-Autoconfig Enabled OBIEE 11g Installation OBIEE Issues OIM Opatch version OpenSSL ora-01031 Oracle oracle 11g Oracle Announcement Oracle Application servers Oracle Application services Oracle Applications Oracle Applications 11i oracle applications 12.2 Oracle Applications Cloning Oracle Applications Upgrade Oracle Applications. Oracle Apps cloning Oracle BPEL oracle certifications oracle database Oracle Database RMAN Oracle Database upgradation Oracle DB oracle E Business suite 12.2 Oracle EBS oracle EPM Oracle Forms Logo oracle Fusion Applications Oracle Inventory oracle news Oracle OUI Oracle R12 oracle Sun Solaris Oracle Tuning Oracle Virtual Box Oracle Webgate Oracle WMA configuration orcladmin password for Oracle Applications Pasta Configuration pasta.cfg patch PDF Performance Physical Standby Platform migration Printer Configuration Profile Option R12 RAC Rapid Install Rapidwiz Real Application Clusters 10g Recovery RMAN RMAN Recovery SA Gosi Service Oriented Architecture SOA SQLTXPLAIN SSL Configuration step-by-step upgrade Sun solaris Swap Tablespace Trace Enable Trace file Translation Synchronization Patch transport tablespace tuning Tuning SGA uifont.ali Underscore Universal Content Management updates.oracle.com Upgradation of 12.0.5 to 12.1.1 Upgrade Upgrade 11g Upgrade Apps Upgrade DB Upgrade to 11g UTF8 version of oracle applications versions Web server upgrade weblogic windows workflow version XML Publisher version