collect-fees-api-error.2026-04-22.0.log 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199
  1. 2026-04-22 09:39:55.315 [XNIO-1 task-1] ERROR c.t.f.c.e.FeesErrorResponseHandler - **未知错误**
  2. org.springframework.jdbc.BadSqlGrammarException:
  3. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "CC"."NBSYJE": 标识符无效
  4. ### The error may exist in file [D:\work\tf\山东莱阳水司\莱阳智慧水务JAVA营销\20260403\lywebmis\collect_fees_ly_api\fees-ly-api\target\classes\mapper\sfgl\YyQfmxMapper.xml]
  5. ### The error may involve defaultParameterMap
  6. ### The error occurred while setting parameters
  7. ### SQL: SELECT COUNT(*) AS total FROM (SELECT yhbh, sum(ysje) qfje FROM yy_qfmx a WHERE sfbz = 0 GROUP BY yhbh) aa LEFT JOIN yh_khjbxx bb ON aa.yhbh = bb.yhbh WHERE qfje > 0 AND cc.nbsyje < aa.qfje AND length(bb.lxdh) = 11 AND bb.sscbb IN (SELECT cbbbm FROM yh_sjqx WHERE user_id = ?)
  8. ### Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "CC"."NBSYJE": 标识符无效
  9. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "CC"."NBSYJE": 标识符无效
  10. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
  11. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  12. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
  13. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  14. at com.sun.proxy.$Proxy172.selectList(Unknown Source)
  15. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  16. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:121)
  17. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:85)
  18. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
  19. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
  20. at com.sun.proxy.$Proxy203.getSumQfmx(Unknown Source)
  21. at com.tofly.feesapi.sfgl.service.impl.YyQfmxServiceImpl.getQfmxSumSelect(YyQfmxServiceImpl.java:4531)
  22. at com.tofly.feesapi.sfgl.service.impl.YyQfmxServiceImpl$$FastClassBySpringCGLIB$$b2860d92.invoke(<generated>)
  23. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  24. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687)
  25. at com.tofly.feesapi.sfgl.service.impl.YyQfmxServiceImpl$$EnhancerBySpringCGLIB$$6bce6ec6.getQfmxSumSelect(<generated>)
  26. at com.tofly.feesapi.sfgl.controller.YyQfmxController.getListPage(YyQfmxController.java:235)
  27. at com.tofly.feesapi.sfgl.controller.YyQfmxController$$FastClassBySpringCGLIB$$3fe5c8dc.invoke(<generated>)
  28. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  29. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
  30. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  31. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  32. at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)
  33. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  34. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  35. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  36. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  37. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  38. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
  39. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  40. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  41. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
  42. at com.tofly.feesapi.sfgl.controller.YyQfmxController$$EnhancerBySpringCGLIB$$3a83a838.getListPage(<generated>)
  43. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  44. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  45. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  46. at java.lang.reflect.Method.invoke(Method.java:498)
  47. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  48. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  49. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  50. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
  51. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
  52. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  53. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  54. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  55. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  56. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  57. at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
  58. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  59. at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
  60. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  61. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  62. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
  63. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
  64. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
  65. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  66. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)
  67. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  68. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  69. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  70. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  71. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  72. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158)
  73. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  74. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  75. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  76. at org.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:176)
  77. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  78. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  79. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  80. at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92)
  81. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77)
  82. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  83. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  84. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  85. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  86. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  87. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  88. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  89. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
  90. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
  91. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
  92. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
  93. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
  94. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  95. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  96. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  97. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
  98. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  99. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  100. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  101. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
  102. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  103. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:109)
  104. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  105. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
  106. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  107. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  108. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  109. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
  110. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  111. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  112. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  113. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  114. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  115. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  116. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
  117. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  118. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  119. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  120. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  121. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  122. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  123. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  124. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  125. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  126. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
  127. at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
  128. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
  129. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
  130. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  131. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  132. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
  133. at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
  134. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
  135. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
  136. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
  137. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  138. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  139. at java.lang.Thread.run(Thread.java:748)
  140. Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "CC"."NBSYJE": 标识符无效
  141. at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:629)
  142. at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:563)
  143. at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1150)
  144. at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:770)
  145. at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
  146. at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:497)
  147. at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:151)
  148. at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:936)
  149. at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1171)
  150. at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1100)
  151. at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1425)
  152. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1308)
  153. at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3745)
  154. at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3940)
  155. at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1009)
  156. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3462)
  157. at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434)
  158. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3460)
  159. at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:158)
  160. at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483)
  161. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  162. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  163. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  164. at java.lang.reflect.Method.invoke(Method.java:498)
  165. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  166. at com.sun.proxy.$Proxy463.execute(Unknown Source)
  167. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  168. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  169. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  170. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  171. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  172. at java.lang.reflect.Method.invoke(Method.java:498)
  173. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
  174. at com.sun.proxy.$Proxy461.query(Unknown Source)
  175. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  176. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  177. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  178. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  179. at com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor.willDoQuery(PaginationInnerInterceptor.java:135)
  180. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:75)
  181. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  182. at com.sun.proxy.$Proxy460.query(Unknown Source)
  183. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  184. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  185. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  186. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  187. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  188. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  189. at java.lang.reflect.Method.invoke(Method.java:498)
  190. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  191. ... 126 common frames omitted
  192. Caused by: oracle.jdbc.OracleDatabaseException: ORA-00904: "CC"."NBSYJE": 标识符无效
  193. at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:636)
  194. ... 175 common frames omitted