1 Reply Latest reply on Aug 4, 2016 6:37 AM by Wolfgang Mayer

    I am getting ORA-12519, TNS:no appropriate service handler found

    Saurabh Gadariya Newbie

      Hi 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,

      1. 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

      1. 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

      1. 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