R12 issue when Generate Explain Plan

Dan Costea

Summary

R12 issue when Generate Explain Plan

Content

Hi,

I have a customer, (also tested internally) which reported that with the R12 upgrade when trying to Generate Explain Plan the txt file contains the below errors:

For the Oracle BI EE database: <?xml version="1.0" encoding="UTF-8"?><error><![CDATAhttp://Explain plan available only for Oracle database.]></error>

For the ApplicationDB_HCM database:

< SQL_EXPLAIN_PLAN>

< DATA_DS>

< ![CDATA[

  Datamodel SQL Explain Plan Report 

=========

< SQL_EXPLAIN_PLAN>
< DATA_DS>
< ![CDATA[
  Datamodel SQL Explain Plan Report 

================================================================

Driver Details:JDBC Driver:Oracle JDBC driver:weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection:11.2.0.3.0
DBName:Oracle
DBVersion:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
java.lang.NullPointerException
at oracle.xdo.dataengine.queryparser.QueryBuilder.addQueryTrace(QueryBuilder.java:727)
at oracle.xdo.dataengine.XMLPGEN.updateDataSourceQuery(XMLPGEN.java:2345)
at oracle.xdo.dataengine.diagnostic.Xplan.processSQLDataSource(Xplan.java:198)
at oracle.xdo.dataengine.diagnostic.Xplan.generate(Xplan.java:110)
at oracle.xdo.dataengine.diagnostic.Xplan.generate(Xplan.java:409)
at oracle.xdo.servlet.ui.datamodel.ValidationServlet.getExplainPlan(ValidationServlet.java:4773)
at oracle.xdo.servlet.ui.datamodel.ValidationServlet.doGet(ValidationServlet.java:505)
at oracle.xdo.servlet.ui.datamodel.ValidationServlet.doPost(ValidationServlet.java:530)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:74)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:230)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.wls.filter.SSOSessionSynchronizationFilter.doFilter(SSOSessionSynchronizationFilter.java:422)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal 

Any help is very appreciated.

Brajesh Shukla-95078

More or less its DBA related question...