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:

  1. 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....

    ReplyDelete
  2. 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 .

    ReplyDelete
  3. @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.

    ReplyDelete
  4. 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.

    ReplyDelete
  5. Hi Shreyas

    Please follow the thread

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

    it may be helpful to you.

    ReplyDelete
  6. 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.

    ReplyDelete