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.
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
ReplyDeletewait 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....
Hi,
ReplyDeletei 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 .
@Shreyas,
ReplyDeleteSorry 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.
Hi Sir,
ReplyDeleteThe 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.
Hi Shreyas
ReplyDeletePlease follow the thread
https://forums.oracle.com/forums/thread.jspa?threadID=431752&tstart=0
it may be helpful to you.
Hi Sir,
ReplyDeleteThe 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.