I am getting ORA-12519, TNS:no appropriate service handler found
gadar Jul 23, 2016 7:29 AMHi All,
I am getting ORA-12519, TNS:no appropriate service handler found while writing excel file and downloading.
I am using oracle 10G and JBoss 7.
Logs:
-----------------------
19-Jul-2016 17:13:28 INFO com.kpn.common.properties.PropertiesHelper [getProperties] - getProperties called..
19-Jul-2016 17:13:28 INFO com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport [getReportDetailsWAP] - Inside getReportDetailsWAP
19-Jul-2016 17:13:28 INFO com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport [getReportDetailsWAP] - Update query for downloadUPDATE WEAS_IB_DOWNLOAD SET NO_OF_DOWNLO
AD = 1 where TELCO_NAME = 'Vodafone' AND PRODUCT_TYPE = 'WAP'
19-Jul-2016 17:13:28 INFO com.kpn.common.properties.PropertiesHelper [getProperties] - getProperties called..
19-Jul-2016 17:13:28 ERROR com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport [executeQuery] - Error connecting to the database,
- com.kpn.common.report.ReportException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.getConnection(IBDownloadReport.java:849)
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.executeQuery(IBDownloadReport.java:808)
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.getReportDetailsWAP(IBDownloadReport.java:387)
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.getIBReport(IBDownloadReport.java:200)
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.<init>(IBDownloadReport.java:104)
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.<init>(IBDownloadReport.java:78)
at com.kpn.tie.gateway.ws.wes.action.WWIBDownloadAction.routeMessage(WWIBDownloadAction.java:102)
at sun.reflect.GeneratedMethodAccessor2908.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
19-07-2016 17:13:50 ERROR org.apache.catalina.core.StandardWrapperValve [invoke] Servlet.service() for servlet struts-action threw exception: java.lang.NullPointerExcep
tion
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.getIBReport(IBDownloadReport.java:124) [classes:]
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.<init>(IBDownloadReport.java:104) [classes:]
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.<init>(IBDownloadReport.java:78) [classes:]
at com.kpn.tie.gateway.ws.wes.action.WWIBDownloadAction.routeMessage(WWIBDownloadAction.java:102) [classes:]
at sun.reflect.GeneratedMethodAccessor2908.invoke(Unknown Source) [:1.7.0_51]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) [struts-1.2.9.jar:1.2.9]
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) [struts-1.2.9.jar:1.2.9]
at org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:150) [struts-1.2.9.jar:1.2.9]
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) [struts-1.2.9.jar:1.2.9]
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) [struts-1.2.9.jar:1.2.9]
at com.kpn.tie.gateway.action.GatewayRequestProcessor.process(GatewayRequestProcessor.java:80) [classes:]
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) [struts-1.2.9.jar:1.2.9]
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) [struts-1.2.9.jar:1.2.9]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) [displaytag-1.2.jar:]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:505) [jbossweb-7.0.13.Final.jar:]
at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:445) [jbossweb-7.0.13.Final.jar:]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
19-07-2016 17:13:59 ERROR org.apache.catalina.core.StandardWrapperValve [invoke] Servlet.service() for servlet struts-action threw exception: java.lang.NullPointerExcep
tion
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.getIBReport(IBDownloadReport.java:124) [classes:]
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.<init>(IBDownloadReport.java:104) [classes:]
at com.kpn.tie.gateway.ws.wes.reports.IBDownloadReport.<init>(IBDownloadReport.java:78) [classes:]
at com.kpn.tie.gateway.ws.wes.action.WWIBDownloadAction.routeMessage(WWIBDownloadAction.java:102) [classes:]
at sun.reflect.GeneratedMethodAccessor2908.invoke(Unknown Source) [:1.7.0_51]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) [struts-1.2.9.jar:1.2.9]
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) [struts-1.2.9.jar:1.2.9]
at org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:150) [struts-1.2.9.jar:1.2.9]
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) [struts-1.2.9.jar:1.2.9]
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) [struts-1.2.9.jar:1.2.9]
at com.kpn.tie.gateway.action.GatewayRequestProcessor.process(GatewayRequestProcessor.java:80) [classes:]
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) [struts-1.2.9.jar:1.2.9]
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) [struts-1.2.9.jar:1.2.9]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) [displaytag-1.2.jar:]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:505) [jbossweb-7.0.13.Final.jar:]
at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:445) [jbossweb-7.0.13.Final.jar:]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
Ejb log
19-07-2016 17:18:58 INFO com.kpn.tie.ejbs.objects.troubleticketmdf.TroubleTicketMdfBean [ejbFindWithClearedStatusB2b] Error finding trouble tickets with updatable stat
- us. javax.resource.ResourceException: IJ000460: Error checking for a transaction: com.kpn.common.dao.DAOException: javax.resource.ResourceException: IJ000460: Error che
cking for a transaction
at com.kpn.common.dao.oracle.OracleDatabase.getOomConnection(OracleDatabase.java:162) [tie-jars-common-13.0.0.jar:13.0.0]
at com.kpn.tie.ejbs.dao.oracle.TroubleTicketMdfOracleDAO.findWithClearedStatusB2b(TroubleTicketMdfOracleDAO.java:1610) [tie-ejb-jar-13.0.0.jar:]
at com.kpn.tie.ejbs.objects.troubleticketmdf.TroubleTicketMdfBean.ejbFindWithClearedStatusB2b(TroubleTicketMdfBean.java:1971) [tie-ejb-jar-13.0.0.jar:]
at sun.reflect.GeneratedMethodAccessor1092.invoke(Unknown Source) [:1.7.0_51]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFacto
- ry.java:72) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at org.jboss.as.ejb3.component.entity.interceptors.EntityBeanSynchronizationInterceptor.processInvocation(EntityBeanSynchronizationInterceptor.java:68) [jboss-a
s-ejb3-7.1.1.Final.jar:7.1.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
------------------------------------------------------------------------------------------
19-07-2016 17:14:17 WARN com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection
for java:jboss/jdbc/tie/OomDB
19-07-2016 17:14:17 WARN com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection
for java:jboss/jdbc/tie/OomDB
19-07-2016 17:14:17 WARN com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection
for java:jboss/jdbc/tie/OomDB
19-07-2016 17:14:17 WARN com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection
for java:jboss/jdbc/tie/OomDB
19-07-2016 17:14:17 WARN com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection
for java:jboss/jdbc/tie/OomDB
19-07-2016 17:14:17 WARN com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Trying to solve an invalid connection.
19-07-2016 17:14:17 WARN com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Trying to solve an invalid connection.
19-07-2016 17:14:17 WARN com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection
for java:jboss/jdbc/tie/OomDB