org.eclipse.birt.report.data.oda.jdbc.JDBCException:ORA-12519, TNS:no appropriate service handler fo

Hi,
 
 My application is using birt as our reporting tool.. When the application is deployed on the Weblogic server I am getting this exception repeatedly " org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found".. Kindly advice as to why this is occuring repeatedly and as soon as possible.. We are using birt 4.4.1 version, Java1.6 and Oracle 11g database.. It should also noted that i am facing this issue only when the application is deployed on the clients weblogic server.. It works perfectly fine when run in apache.. Attached is the entire stack trace.. Thanks in advance..
 
Unable to open connection. 
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Listener refused the connection with the following error: 
ORA-12519, TNS:no appropriate service handler found 
. 
 at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:337) 
 at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:236) 
 at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:252) 
 at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162) 
 at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250) 
 at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165) 
 at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224) 
 at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212) 
 at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217) 
 at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:434) 
 at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:322) 
 at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:463) 
 at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190) 
 at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178) 
 at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:178) 
 at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:637) 
 at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152) 
 at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:275) 
 at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1947) 
 at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80) 
 at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) 
 at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) 
 at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) 
 at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) 
 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) 
 at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92) 
 at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100) 
 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:181) 
 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) 
 at ubq.reportingtoolframework.ReportingToolManager.iRunAndRenderTask(ReportingToolManager.java:1152) 
 at ubq.reportingtoolframework.ReportingToolManager.generateReport(ReportingToolManager.java:100) 
 at ubq.reportingtoolframework.ReportingToolServlet._generateReport(ReportingToolServlet.java:93) 
 at ubq.reportingtoolframework.ReportingToolServlet.handleGet(ReportingToolServlet.java:46) 
 at ubq.base.UHttpServlet.doGet(UHttpServlet.java:121) 
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) 
 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:300) 
 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183) 
 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3686) 
 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650) 
 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) 
 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) 
 at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268) 
 at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174) 
 at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446) 
 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201) 
 at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
 
 
Channamari

Find more posts tagged with

Comments

Clement Wong

To compare the working environment running Apache with the non-working running Weblogic...
 
1. Is Apache (Tomcat) on the same machine as the non-working Weblogic? If not, what's different between the machines? Can the working Tomcat be deployed to the non-working machine as a test? Is Java 1.6 also the same version on both working and non-working?
 
2. On the non-working Weblogic machine, can it communicate to the Oracle 11g server outside of the BIRT framework? That is, does a simple JSP page work? Or can a simple Java app with JDBC communicate?
 
3. Is this an intermittent issue, or does it happen to all reports?
 
This stackoverflow article has a few suggestions to try:
<a data-ipb='nomediaparse' href='http://stackoverflow.com/questions/205160/what-can-cause-intermittent-ora-12519-tns-no-appropriate-handler-found-errors'>http://stackoverflow.com/questions/205160/what-can-cause-intermittent-ora-12519-tns-no-appropriate-handler-found-errors</a>
 
Have you also reached out to Oracle to see if they have other troubleshooting suggestions?

Channamari

Hi,
 I'll answer the questions accordingly..
 
1. No.. Both the servers are in different machines ..
2. Yes, The entire application works fine leaving apart the BIRT framework..
3. It affects all the reports.. After the first time this exception is thrown all the reports start throwing this exception..
 
As a temporary solution (Probably) i have incorporated the solution in this article <a data-ipb='nomediaparse' href='https://community.oracle.com/thread/2471899?tstart=0'>https://community.oracle.com/thread/2471899?tstart=0</a>.. I am not sure as to how effective a solution this is, Kindly help me figure out the root cause..
 
 
Thanks
Channamari