DX Application Performance Management

  • 1.  Error while loading Geo data to the database

    Posted Nov 24, 2017 10:33 AM

    I I'm getting this error when we starting EM:

     

    [ERROR] [SimpleAsyncTaskExecutor-1] [Manager.AppMap.GeoLocation] Error while loading Geo data to the database
    11/24/17 12:17:36.294 PM ART [ERROR] [SimpleAsyncTaskExecutor-1] [Manager.AppMap.GeoLocation] Not able to close the connection for Geo data import
    java.sql.SQLException: Already closed.
            at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)
            at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)
            at com.wily.introscope.appmap.em.model.dao.impl.GeoLocationUpdateDaoImpl.loadData(GeoLocationUpdateDaoImpl.java:394)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:498)
            at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
            at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
            at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
            at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
            at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
            at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
            at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
            at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
            at com.sun.proxy.$Proxy159.loadData(Unknown Source)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:498)
            at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
            at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
            at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
            at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
            at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
            at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
            at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
            at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
            at com.sun.proxy.$Proxy160.loadData(Unknown Source)
            at com.wily.introscope.appmap.geo.CsvFileLoader.loadCsvToDb(CsvFileLoader.java:119)
            at com.wily.introscope.appmap.geo.CsvFileLoader.loadCsvsToDb(CsvFileLoader.java:60)
            at com.wily.introscope.appmap.geo.GeoDirWatchService.watchDirectory(GeoDirWatchService.java:141)
            at com.wily.introscope.appmap.geo.GeoDirWatchService$$FastClassBySpringCGLIB$$4188d58e.invoke(<generated>)
            at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
            at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:718)
            at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
            at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110)
            at java.util.concurrent.FutureTask.run(FutureTask.java:266)



  • 2.  Re: Error while loading Geo data to the database

    Broadcom Employee
    Posted Nov 27, 2017 09:34 AM

    Dear Osvaldo:

       Have you made any progress on this issue? If you do not hear an answer by the time you read this, please consider opening a case. If a resolution is found, please post so others can avoid this scenario

     

    Thanks

    Hal German



  • 3.  Re: Error while loading Geo data to the database
    Best Answer

    Posted Nov 27, 2017 12:33 PM

    Hi Hallet,

     

    Actually we couldn't. It was upgrading EM versión, so we made a fresh install to solve this problema.

     

    Regards.-