# \[apm\]The java-agent only provides the request information to the apm-service, and the dependency is empty **URL:** \ **Category:** APM\ **Tags:** java, server\ **Created:** [January 4, 2023, 9:23am UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440 "2023-01-04T09:23:46Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![ntmxglrtayl03](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ntmxglrtayl03/32/115075_2.png) [@ntmxglrtayl03](https://discuss.elastic.co/u/ntmxglrtayl03)\ **Post date:** [January 4, 2023, 9:23am UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/1 "2023-01-04T09:23:46Z")
**Kibana version** : 7.17.8 **Elasticsearch version** : 7.17.8 **APM Server version** : 7.17.8 **APM Agent language and version** : java 1.35.0 **What can I do to make them show?** ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/b/bbf8bd96d47fcce57c0b94db233abb2b1560f382.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/2/c2ebcede24b5e9147dcd6999e780d24753663d62.png) ---
**Author:** ![ntmxglrtayl03](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ntmxglrtayl03/32/115075_2.png) [@ntmxglrtayl03](https://discuss.elastic.co/u/ntmxglrtayl03)\ **Post date:** [January 4, 2023, 9:28am UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/2 "2023-01-04T09:28:13Z")
I have at least used mysql in this java project, can I show the dependency of mysql as in this python project ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/6/c68dc4f7784741171c6a5ec9f3ba7f90c4bd7f50.png) ---
**Author:** ![Eyal\_Koren](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eyal_koren/32/36830_2.png) [@Eyal\_Koren](https://discuss.elastic.co/u/Eyal_Koren)\ **Post date:** [January 4, 2023, 2:01pm UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/3 "2023-01-04T14:01:02Z")
This is not enough info. When you look into your traces, do you see those MySQL queries? For example, in the following trace, there is a H2 span: ![Screen Shot 2023-01-04 at 15.53.10](https://us1.discourse-cdn.com/elastic/original/3X/b/d/bd552ed92b996adb6827de657050aafbd08a61fd.png) If you see such MySQL spans within your traces, then click on the SQL span and it will open a flyout: ![Screen Shot 2023-01-04 at 15.55.58](https://us1.discourse-cdn.com/elastic/original/3X/8/0/809a1941eaa6f71eeadba94a1aadc4bfbe87675f.jpeg) Then use the "View span in Discover" link to get the span document and share it. If you don't see any DB span, verify that your are using [supported technologies](https://www.elastic.co/guide/en/apm/agent/java/current/supported-technologies-details.html) and if you are, look in your agent log and see if there's anything interesting there. ---
**Author:** ![ntmxglrtayl03](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ntmxglrtayl03/32/115075_2.png) [@ntmxglrtayl03](https://discuss.elastic.co/u/ntmxglrtayl03)\ **Post date:** [January 4, 2023, 2:13pm UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/4 "2023-01-04T14:13:02Z")
- I used spring boot 2.3.2 - Here's more information ```json {"_index":"apm-7.17.8-span-000001","_type":"_doc","_id":"7s7ze4UBKiGt3V2iwzz1","_version":1,"_score":1,"_source":{"parent":{"id":"1f4c9dab7e88ba6a"},"agent":{"name":"java","ephemeral_id":"7c2364d3-3e06-486b-85a0-46fe2fa17937","version":"1.35.0"},"destination":{"address":"125.124.53.188","port":3306,"ip":"125.124.53.188"},"processor":{"name":"transaction","event":"span"},"observer":{"hostname":"ojbsdkv8j9zc9tq9","id":"71d67c43-e453-4d00-a046-346ddd733593","type":"apm-server","ephemeral_id":"d03c5254-8f3a-4b88-a4ad-e01d86ab7bdc","version":"7.17.8","version_major":7},"trace":{"id":"0a5ebb0832a43877979e033af382dd62"},"@timestamp":"2023-01-04T08:44:22.620Z","ecs":{"version":"1.12.0"},"service":{"environment":"production","name":"wetech_admin_server"},"event":{"outcome":"success"},"transaction":{"id":"1f4c9dab7e88ba6a"},"span":{"duration":{"us":46307},"stacktrace":[{"library_frame":true,"exclude_from_grouping":false,"filename":"HikariProxyPreparedStatement.java","classname":"com.zaxxer.hikari.pool.HikariProxyPreparedStatement","line":{"number":-1},"module":"com.zaxxer.hikari.pool","function":"execute"},{"library_frame":true,"exclude_from_grouping":false,"filename":"PreparedStatementLogger.java","classname":"org.apache.ibatis.logging.jdbc.PreparedStatementLogger","line":{"number":59},"function":"invoke","module":"org.apache.ibatis.logging.jdbc"},{"library_frame":true,"exclude_from_grouping":false,"filename":"PreparedStatementHandler.java","classname":"org.apache.ibatis.executor.statement.PreparedStatementHandler","line":{"number":64},"module":"org.apache.ibatis.executor.statement","function":"query"},{"library_frame":true,"exclude_from_grouping":false,"filename":"RoutingStatementHandler.java","classname":"org.apache.ibatis.executor.statement.RoutingStatementHandler","line":{"number":79},"module":"org.apache.ibatis.executor.statement","function":"query"},{"exclude_from_grouping":false,"library_frame":true,"filename":"SimpleExecutor.java","classname":"org.apache.ibatis.executor.SimpleExecutor","line":{"number":63},"module":"org.apache.ibatis.executor","function":"doQuery"},{"library_frame":true,"exclude_from_grouping":false,"filename":"BaseExecutor.java","classname":"org.apache.ibatis.executor.BaseExecutor","line":{"number":325},"module":"org.apache.ibatis.executor","function":"queryFromDatabase"},{"exclude_from_grouping":false,"library_frame":true,"filename":"BaseExecutor.java","classname":"org.apache.ibatis.executor.BaseExecutor","line":{"number":156},"module":"org.apache.ibatis.executor","function":"query"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CachingExecutor.java","classname":"org.apache.ibatis.executor.CachingExecutor","line":{"number":109},"module":"org.apache.ibatis.executor","function":"query"},{"library_frame":true,"exclude_from_grouping":false,"filename":"PagingExecutor.java","classname":"tech.wetech.mybatis.PagingExecutor","line":{"number":114},"module":"tech.wetech.mybatis","function":"query"},{"library_frame":true,"exclude_from_grouping":false,"filename":"PagingExecutor.java","classname":"tech.wetech.mybatis.PagingExecutor","line":{"number":125},"function":"query","module":"tech.wetech.mybatis"},{"library_frame":true,"exclude_from_grouping":false,"filename":"DefaultSqlSession.java","classname":"org.apache.ibatis.session.defaults.DefaultSqlSession","line":{"number":147},"function":"selectList","module":"org.apache.ibatis.session.defaults"},{"exclude_from_grouping":false,"library_frame":true,"filename":"DefaultSqlSession.java","classname":"org.apache.ibatis.session.defaults.DefaultSqlSession","line":{"number":140},"module":"org.apache.ibatis.session.defaults","function":"selectList"},{"library_frame":true,"exclude_from_grouping":false,"filename":"SqlSessionTemplate.java","classname":"org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor","line":{"number":426},"module":"org.mybatis.spring","function":"invoke"},{"exclude_from_grouping":false,"library_frame":true,"filename":"SqlSessionTemplate.java","classname":"org.mybatis.spring.SqlSessionTemplate","line":{"number":223},"module":"org.mybatis.spring","function":"selectList"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MapperMethod.java","classname":"org.apache.ibatis.binding.MapperMethod","line":{"number":147},"module":"org.apache.ibatis.binding","function":"executeForMany"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MapperMethod.java","classname":"org.apache.ibatis.binding.MapperMethod","line":{"number":80},"module":"org.apache.ibatis.binding","function":"execute"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MapperProxy.java","classname":"org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker","line":{"number":152},"module":"org.apache.ibatis.binding","function":"invoke"},{"exclude_from_grouping":false,"library_frame":true,"filename":"MapperProxy.java","classname":"org.apache.ibatis.binding.MapperProxy","line":{"number":85},"module":"org.apache.ibatis.binding","function":"invoke"},{"exclude_from_grouping":false,"library_frame":true,"filename":"UserServiceImpl.java","classname":"tech.wetech.admin.service.impl.UserServiceImpl","line":{"number":109},"module":"tech.wetech.admin.service.impl","function":"lambda$queryUserPage$0"},{"library_frame":true,"exclude_from_grouping":false,"filename":"Page.java","classname":"tech.wetech.mybatis.domain.Page","line":{"number":79},"function":"list","module":"tech.wetech.mybatis.domain"},{"library_frame":true,"exclude_from_grouping":false,"filename":"UserServiceImpl.java","classname":"tech.wetech.admin.service.impl.UserServiceImpl","line":{"number":109},"module":"tech.wetech.admin.service.impl","function":"queryUserPage"},{"library_frame":true,"exclude_from_grouping":false,"filename":"UserController.java","classname":"tech.wetech.admin.controller.UserController","line":{"number":34},"module":"tech.wetech.admin.controller","function":"queryUserList"},{"exclude_from_grouping":false,"library_frame":true,"filename":"","classname":"tech.wetech.admin.controller.UserController$$FastClassBySpringCGLIB$$26210f68","line":{"number":-1},"module":"tech.wetech.admin.controller","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MethodProxy.java","classname":"org.springframework.cglib.proxy.MethodProxy","line":{"number":218},"module":"org.springframework.cglib.proxy","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":771},"module":"org.springframework.aop.framework","function":"invokeJoinpoint"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ReflectiveMethodInvocation.java","classname":"org.springframework.aop.framework.ReflectiveMethodInvocation","line":{"number":163},"function":"proceed","module":"org.springframework.aop.framework"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":749},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MethodInvocationProceedingJoinPoint.java","classname":"org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint","line":{"number":88},"module":"org.springframework.aop.aspectj","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ControllerLogAspect.java","classname":"tech.wetech.admin.aspect.ControllerLogAspect","line":{"number":32},"module":"tech.wetech.admin.aspect","function":"aroundMethod"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AbstractAspectJAdvice.java","classname":"org.springframework.aop.aspectj.AbstractAspectJAdvice","line":{"number":644},"module":"org.springframework.aop.aspectj","function":"invokeAdviceMethodWithGivenArgs"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AbstractAspectJAdvice.java","classname":"org.springframework.aop.aspectj.AbstractAspectJAdvice","line":{"number":633},"module":"org.springframework.aop.aspectj","function":"invokeAdviceMethod"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AspectJAroundAdvice.java","classname":"org.springframework.aop.aspectj.AspectJAroundAdvice","line":{"number":70},"module":"org.springframework.aop.aspectj","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ReflectiveMethodInvocation.java","classname":"org.springframework.aop.framework.ReflectiveMethodInvocation","line":{"number":175},"function":"proceed","module":"org.springframework.aop.framework"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":749},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AopAllianceAnnotationsAuthorizingMethodInterceptor.java","classname":"org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor$1","line":{"number":82},"module":"org.apache.shiro.spring.security.interceptor","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AuthorizingMethodInterceptor.java","classname":"org.apache.shiro.authz.aop.AuthorizingMethodInterceptor","line":{"number":39},"module":"org.apache.shiro.authz.aop","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"AopAllianceAnnotationsAuthorizingMethodInterceptor.java","classname":"org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor","line":{"number":115},"module":"org.apache.shiro.spring.security.interceptor","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ReflectiveMethodInvocation.java","classname":"org.springframework.aop.framework.ReflectiveMethodInvocation","line":{"number":186},"function":"proceed","module":"org.springframework.aop.framework"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":749},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ExposeInvocationInterceptor.java","classname":"org.springframework.aop.interceptor.ExposeInvocationInterceptor","line":{"number":95},"module":"org.springframework.aop.interceptor","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ReflectiveMethodInvocation.java","classname":"org.springframework.aop.framework.ReflectiveMethodInvocation","line":{"number":186},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":749},"module":"org.springframework.aop.framework","function":"proceed"},{"exclude_from_grouping":false,"library_frame":true,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor","line":{"number":691},"module":"org.springframework.aop.framework","function":"intercept"},{"library_frame":true,"exclude_from_grouping":false,"filename":"","classname":"tech.wetech.admin.controller.UserController$$EnhancerBySpringCGLIB$$49dd1cdf","line":{"number":-1},"module":"tech.wetech.admin.controller","function":"queryUserList"},{"library_frame":true,"exclude_from_grouping":false,"filename":"","classname":"tech.wetech.admin.controller.UserController$$FastClassBySpringCGLIB$$26210f68","line":{"number":-1},"module":"tech.wetech.admin.controller","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MethodProxy.java","classname":"org.springframework.cglib.proxy.MethodProxy","line":{"number":218},"module":"org.springframework.cglib.proxy","function":"invoke"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":771},"module":"org.springframework.aop.framework","function":"invokeJoinpoint"},{"library_frame":true,"exclude_from_grouping":false,"filename":"ReflectiveMethodInvocation.java","classname":"org.springframework.aop.framework.ReflectiveMethodInvocation","line":{"number":163},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"CglibAopProxy.java","classname":"org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","line":{"number":749},"module":"org.springframework.aop.framework","function":"proceed"},{"library_frame":true,"exclude_from_grouping":false,"filename":"MethodValidationInterceptor.java","classname":"org.springframework.validation.beanvalidation.MethodValidationInterceptor","line":{"number":119},"module":"org.springframework.validation.beanvalidation","function":"invoke"}],"subtype":"mysql","destination":{"service":{"resource":"mysql/wetech_admin"}},"name":"SELECT","action":"query","id":"c2dde0a30c20e2ea","type":"db","db":{"instance":"wetech_admin","statement":"SELECTCOUNT(*)FROM(selectid,username,password,salt,role_ids,lockedfromsys_userorderbyidDESC)tmp_count","type":"sql","user":{"name":"root@219.140.150.207"}}},"timestamp":{"us":1672821862620260}},"fields":{"span.stacktrace.line.number":[-1,59,64,79,63,325,156,109,114,125,147,140,426,223,147,80,152,85,109,79,109,34,-1,218,771,163,749,88,32,644,633,70,175,749,82,39,115,186,749,95,186,749,691,-1,-1,218,771,163,749,119],"span.name":["SELECT"],"span.action":["query"],"destination.port":[3306],"span.db.user.name":["root@219.140.150.207"],"transaction.id":["1f4c9dab7e88ba6a"],"trace.id":["0a5ebb0832a43877979e033af382dd62"],"span.duration.us":[46307],"span.stacktrace.classname":["com.zaxxer.hikari.pool.HikariProxyPreparedStatement","org.apache.ibatis.logging.jdbc.PreparedStatementLogger","org.apache.ibatis.executor.statement.PreparedStatementHandler","org.apache.ibatis.executor.statement.RoutingStatementHandler","org.apache.ibatis.executor.SimpleExecutor","org.apache.ibatis.executor.BaseExecutor","org.apache.ibatis.executor.BaseExecutor","org.apache.ibatis.executor.CachingExecutor","tech.wetech.mybatis.PagingExecutor","tech.wetech.mybatis.PagingExecutor","org.apache.ibatis.session.defaults.DefaultSqlSession","org.apache.ibatis.session.defaults.DefaultSqlSession","org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor","org.mybatis.spring.SqlSessionTemplate","org.apache.ibatis.binding.MapperMethod","org.apache.ibatis.binding.MapperMethod","org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker","org.apache.ibatis.binding.MapperProxy","tech.wetech.admin.service.impl.UserServiceImpl","tech.wetech.mybatis.domain.Page","tech.wetech.admin.service.impl.UserServiceImpl","tech.wetech.admin.controller.UserController","tech.wetech.admin.controller.UserController$$FastClassBySpringCGLIB$$26210f68","org.springframework.cglib.proxy.MethodProxy","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.aop.framework.ReflectiveMethodInvocation","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint","tech.wetech.admin.aspect.ControllerLogAspect","org.springframework.aop.aspectj.AbstractAspectJAdvice","org.springframework.aop.aspectj.AbstractAspectJAdvice","org.springframework.aop.aspectj.AspectJAroundAdvice","org.springframework.aop.framework.ReflectiveMethodInvocation","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor$1","org.apache.shiro.authz.aop.AuthorizingMethodInterceptor","org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor","org.springframework.aop.framework.ReflectiveMethodInvocation","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.aop.interceptor.ExposeInvocationInterceptor","org.springframework.aop.framework.ReflectiveMethodInvocation","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor","tech.wetech.admin.controller.UserController$$EnhancerBySpringCGLIB$$49dd1cdf","tech.wetech.admin.controller.UserController$$FastClassBySpringCGLIB$$26210f68","org.springframework.cglib.proxy.MethodProxy","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.aop.framework.ReflectiveMethodInvocation","org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation","org.springframework.validation.beanvalidation.MethodValidationInterceptor"],"span.db.statement":["SELECTCOUNT(*)FROM(selectid,username,password,salt,role_ids,lockedfromsys_userorderbyidDESC)tmp_count"],"processor.event":["span"],"agent.name":["java"],"destination.address":["125.124.53.188"],"event.outcome":["success"],"service.environment":["production"],"span.stacktrace.exclude_from_grouping":[false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false],"service.name":["wetech_admin_server"],"span.stacktrace.filename":["HikariProxyPreparedStatement.java","PreparedStatementLogger.java","PreparedStatementHandler.java","RoutingStatementHandler.java","SimpleExecutor.java","BaseExecutor.java","BaseExecutor.java","CachingExecutor.java","PagingExecutor.java","PagingExecutor.java","DefaultSqlSession.java","DefaultSqlSession.java","SqlSessionTemplate.java","SqlSessionTemplate.java","MapperMethod.java","MapperMethod.java","MapperProxy.java","MapperProxy.java","UserServiceImpl.java","Page.java","UserServiceImpl.java","UserController.java","","MethodProxy.java","CglibAopProxy.java","ReflectiveMethodInvocation.java","CglibAopProxy.java","MethodInvocationProceedingJoinPoint.java","ControllerLogAspect.java","AbstractAspectJAdvice.java","AbstractAspectJAdvice.java","AspectJAroundAdvice.java","ReflectiveMethodInvocation.java","CglibAopProxy.java","AopAllianceAnnotationsAuthorizingMethodInterceptor.java","AuthorizingMethodInterceptor.java","AopAllianceAnnotationsAuthorizingMethodInterceptor.java","ReflectiveMethodInvocation.java","CglibAopProxy.java","ExposeInvocationInterceptor.java","ReflectiveMethodInvocation.java","CglibAopProxy.java","CglibAopProxy.java","","","MethodProxy.java","CglibAopProxy.java","ReflectiveMethodInvocation.java","CglibAopProxy.java","MethodValidationInterceptor.java"],"processor.name":["transaction"],"span.stacktrace.function":["execute","invoke","query","query","doQuery","queryFromDatabase","query","query","query","query","selectList","selectList","invoke","selectList","executeForMany","execute","invoke","invoke","lambda$queryUserPage$0","list","queryUserPage","queryUserList","invoke","invoke","invokeJoinpoint","proceed","proceed","proceed","aroundMethod","invokeAdviceMethodWithGivenArgs","invokeAdviceMethod","invoke","proceed","proceed","proceed","invoke","invoke","proceed","proceed","invoke","proceed","proceed","intercept","queryUserList","invoke","invoke","invokeJoinpoint","proceed","proceed","invoke"],"span.subtype":["mysql"],"span.id":["c2dde0a30c20e2ea"],"observer.version_major":[7],"span.stacktrace.library_frame":[true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true],"span.stacktrace.module":["com.zaxxer.hikari.pool","org.apache.ibatis.logging.jdbc","org.apache.ibatis.executor.statement","org.apache.ibatis.executor.statement","org.apache.ibatis.executor","org.apache.ibatis.executor","org.apache.ibatis.executor","org.apache.ibatis.executor","tech.wetech.mybatis","tech.wetech.mybatis","org.apache.ibatis.session.defaults","org.apache.ibatis.session.defaults","org.mybatis.spring","org.mybatis.spring","org.apache.ibatis.binding","org.apache.ibatis.binding","org.apache.ibatis.binding","org.apache.ibatis.binding","tech.wetech.admin.service.impl","tech.wetech.mybatis.domain","tech.wetech.admin.service.impl","tech.wetech.admin.controller","tech.wetech.admin.controller","org.springframework.cglib.proxy","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.aop.aspectj","tech.wetech.admin.aspect","org.springframework.aop.aspectj","org.springframework.aop.aspectj","org.springframework.aop.aspectj","org.springframework.aop.framework","org.springframework.aop.framework","org.apache.shiro.spring.security.interceptor","org.apache.shiro.authz.aop","org.apache.shiro.spring.security.interceptor","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.aop.interceptor","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.aop.framework","tech.wetech.admin.controller","tech.wetech.admin.controller","org.springframework.cglib.proxy","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.aop.framework","org.springframework.validation.beanvalidation"],"destination.ip":["125.124.53.188"],"observer.hostname":["ojbsdkv8j9zc9tq9"],"span.type":["db"],"observer.id":["71d67c43-e453-4d00-a046-346ddd733593"],"timestamp.us":[1672821862620260],"@timestamp":["2023-01-04T08:44:22.620Z"],"span.db.type":["sql"],"observer.ephemeral_id":["d03c5254-8f3a-4b88-a4ad-e01d86ab7bdc"],"observer.version":["7.17.8"],"ecs.version":["1.12.0"],"observer.type":["apm-server"],"agent.ephemeral_id":["7c2364d3-3e06-486b-85a0-46fe2fa17937"],"parent.id":["1f4c9dab7e88ba6a"],"agent.version":["1.35.0"],"span.destination.service.resource":["mysql/wetech_admin"],"span.db.instance":["wetech_admin"]}} ``` ---
**Author:** ![Sylvain\_Juge](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sylvain_juge/32/55521_2.png) [@Sylvain\_Juge](https://discuss.elastic.co/u/Sylvain_Juge)\ **Post date:** [January 5, 2023, 11:04am UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/5 "2023-01-05T11:04:08Z")
Thanks for providing those details. From what I see in the provided document: - the `observer.version` is `7.17.8`, thus it means that the apm-server that wrote this document is consistent with the stack. - there is no `span.service.target.*` fields, which were added in `7.16.0` and should be inferred by apm-server when not sent by the agent - the `span.destination.service.resource` field is set to `mysql/wetech_admin`, so the apm-server should have properly inferred the values of `span.service.target.{type,name}`, it should have been the same when using an older agent that did not send those new fields. Are you using any custom ingest pipeline that could maybe interfere ? ---
**Author:** ![ntmxglrtayl03](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ntmxglrtayl03/32/115075_2.png) [@ntmxglrtayl03](https://discuss.elastic.co/u/ntmxglrtayl03)\ **Post date:** [January 6, 2023, 2:07am UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/6 "2023-01-06T02:07:41Z")
As far as I know use custom ingest pipeline need register the pipeline, I haven't done that I provided debug logs for apm-agent, Do you need more information? [apm-agent.log](https://ufile.io/m12gi9e7) ---
**Author:** ![ntmxglrtayl03](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ntmxglrtayl03/32/115075_2.png) [@ntmxglrtayl03](https://discuss.elastic.co/u/ntmxglrtayl03)\ **Post date:** [January 9, 2023, 5:49am UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/7 "2023-01-09T05:49:06Z")
This problem has been bothering me, and I am willing to provide more useful information to solve this problem @Sylvain_Juge ---
**Author:** ![Sylvain\_Juge](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sylvain_juge/32/55521_2.png) [@Sylvain\_Juge](https://discuss.elastic.co/u/Sylvain_Juge)\ **Post date:** [January 9, 2023, 11:01am UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/8 "2023-01-09T11:01:13Z")
Hi, After checking with the APM server team, I was wrong about the `span.service.target.*` fields that have been added only in `8.3.0` or `8.4.0`, and not in `7.16.0` as I initially wrote, sorry for this wrong analysis. So, going back to your issue description: - you can see the dependency in the service dependencies and the map. - the issue is that you have an "empty" view when opening this dependency. I am not familiar with how this view is built in Kibana, but it very probably relies on metrics that are computed from the agent data. The information captured by the agent (here a span) seems correct. I don't read chinese, what time frame did you picked for the last screenshot ? It may sound obvious but worth to check, do you have the same by using a large one like "the last 2 months" ? ---
**Author:** ![ntmxglrtayl03](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ntmxglrtayl03/32/115075_2.png) [@ntmxglrtayl03](https://discuss.elastic.co/u/ntmxglrtayl03)\ **Post date:** [January 9, 2023, 12:42pm UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/9 "2023-01-09T12:42:04Z")
The previous screenshots were from the last seven days Below are screenshots from the last 15 minutes and the last 2 months ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/6/765e473de8a08a9c2db44c15e47705d7c98a9b43.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/b/4bce9878a491f1851b68e5c62d96cc879a037e46.png) You can be sure that mysql services are visible throughout the span ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/8/986e5bc17b3989852be49f2917414056589a6fac.png) I'm using an open source [project](https://github.com/cjbi/wetech-admin) that you can find on github ---
**Author:** ![Sylvain\_Juge](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sylvain_juge/32/55521_2.png) [@Sylvain\_Juge](https://discuss.elastic.co/u/Sylvain_Juge)\ **Post date:** [January 10, 2023, 12:59pm UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/10 "2023-01-10T12:59:11Z")
Hi @ntmxglrtayl03 , I tried to reproduce locally with the provided application, but I did not manage to reproduce it. When using latest agent version (very close to 1.35, I had to use this one to enable the agent with `spring-boot:run` maven goal) and the same `7.17.8` stack version. Here is a screenshot of the service dependencies: ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/5/4572f43f4af718e3ca07ba04cec50412d630ca7d.png) It initially took a bit of time (a few seconds) for the data to be available and properly displayed in Kibana. ---
**Author:** ![ntmxglrtayl03](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ntmxglrtayl03/32/115075_2.png) [@ntmxglrtayl03](https://discuss.elastic.co/u/ntmxglrtayl03)\ **Post date:** [January 12, 2023, 1:27am UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/11 "2023-01-12T01:27:31Z")
Hi @Sylvain_Juge , Thank you very much for your help！ I from beginning to end not had dependency information ，But I'm running a different project from github， The dependency information arisened，It's probably related to some config, but I can't find it ---
**Author:** ![Sylvain\_Juge](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sylvain_juge/32/55521_2.png) [@Sylvain\_Juge](https://discuss.elastic.co/u/Sylvain_Juge)\ **Post date:** [January 16, 2023, 9:29am UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/12 "2023-01-16T09:29:48Z")
The dependencies are created from the spans, thus here as you seem to be able to see the database spans in the Trace view, you should have the corresponding dependencies visible in the service dependencies and the map. As I have checked with a different application (but that might be close to yours), it should work as expected. The only difference I could see here is your stack deployment. Is there anything specific for your deployment ? is it on-premises or cloud ? Maybe there is something missing or broken in your deployment that prevents the APM product to work as expected. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 6, 2023, 5:30am UTC](https://discuss.elastic.co/t/apm-the-java-agent-only-provides-the-request-information-to-the-apm-service-and-the-dependency-is-empty/322440/13 "2023-02-06T05:30:20Z")
This topic was automatically closed 20 days after the last reply. New replies are no longer allowed.