<p>Hi,</p>
<p> </p>
<p> My application is using birt as our reporting tool.. When the application is deployed on the Weblogic server I am getting this exception repeatedly " <span style="color:#ff0000;"><strong>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</strong></span>".. 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..</p>
<p> </p>
<p>Unable to open connection.<br>
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Listener refused the connection with the following error:<br>
ORA-12519, TNS:no appropriate service handler found<br>
.<br>
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:337)<br>
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:236)<br>
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:252)<br>
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)<br>
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)<br>
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)<br>
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)<br>
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)<br>
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)<br>
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:434)<br>
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:322)<br>
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:463)<br>
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)<br>
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)<br>
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:178)<br>
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:637)<br>
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)<br>
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:275)<br>
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1947)<br>
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)<br>
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)<br>
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)<br>
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)<br>
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)<br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)<br>
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)<br>
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)<br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:181)<br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)<br>
at ubq.reportingtoolframework.ReportingToolManager.iRunAndRenderTask(ReportingToolManager.java:1152)<br>
at ubq.reportingtoolframework.ReportingToolManager.generateReport(ReportingToolManager.java:100)<br>
at ubq.reportingtoolframework.ReportingToolServlet._generateReport(ReportingToolServlet.java:93)<br>
at ubq.reportingtoolframework.ReportingToolServlet.handleGet(ReportingToolServlet.java:46)<br>
at ubq.base.UHttpServlet.doGet(UHttpServlet.java:121)<br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)<br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)<br>
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)<br>
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)<br>
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)<br>
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)<br>
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3686)<br>
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)<br>
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)<br>
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)<br>
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)<br>
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)<br>
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)<br>
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)<br>
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)</p>
<p> </p>
<p> </p>
<p>Channamari</p>
