[步骤]

qryFbaVirtualInventoryByAgeLimit请求异常

feign.FeignException$InternalServerError: [500 ] during [POST] to [http://zhcxkj-center-warehouse/list/qryFbaVirtualInventoryByAgeLimit] [IAmzFbaVirtualInventoryOpenApi#qryFbaVirtualInventoryByAgeLimit(AmzFbaVirtualInventoryByAgeLimitQry)]: [{"success":false,"errCode":"10000500","errMessage":"\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to ... (1327 bytes)]
        at feign.FeignException.serverErrorStatus(FeignException.java:250)
        at feign.FeignException.errorStatus(FeignException.java:197)
        at feign.FeignException.errorStatus(FeignException.java:185)
        at feign.codec.ErrorDecoder$Default.decode(ErrorDecoder.java:92)
        at feign.AsyncResponseHandler.handleResponse(AsyncResponseHandler.java:98)
        at feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:141)
        at feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:91)
        at feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:100)
        at org.springframework.cloud.openfeign.FeignCachingInvocationHandlerFactory$1.proceed(FeignCachingInvocationHandlerFactory.java:66)
        at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:54)
        at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:351)
        at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:64)
        at org.springframework.cloud.openfeign.FeignCachingInvocationHandlerFactory.lambda$create$1(FeignCachingInvocationHandlerFactory.java:53)
        at jdk.proxy2/jdk.proxy2.$Proxy164.qryFbaVirtualInventoryByAgeLimit(Unknown Source)
        at com.zhcxkj.application.strategy.application.executor.strategy.InitStrategyTemplateCmdExe.FBATemplateCompare(InitStrategyTemplateCmdExe.java:407)
        at com.zhcxkj.application.strategy.application.executor.strategy.InitStrategyTemplateCmdExe.executor(InitStrategyTemplateCmdExe.java:182)
        at com.zhcxkj.application.strategy.adapter.consumer.strategy.InitStrategyTemplateEventConsumer$1.handler(InitStrategyTemplateEventConsumer.java:30)
        at com.zhcxkj.application.strategy.adapter.consumer.strategy.InitStrategyTemplateEventConsumer$1.handler(InitStrategyTemplateEventConsumer.java:27)
        at com.zhcxkj.common.rabbitmq.handler.BaseRabbitMqHandler.onMessage(BaseRabbitMqHandler.java:85)
        at com.zhcxkj.common.rabbitmq.handler.BaseRabbitMqHandler.onMessage(BaseRabbitMqHandler.java:62)
        at com.zhcxkj.application.strategy.adapter.consumer.strategy.InitStrategyTemplateEventConsumer.consumer(InitStrategyTemplateEventConsumer.java:27)
        at jdk.internal.reflect.GeneratedMethodAccessor424.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.springframework.messaging.handler.invocation.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:169)
        at org.springframework.messaging.handler.invocation.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:119)
        at org.springframework.amqp.rabbit.listener.adapter.HandlerAdapter.invoke(HandlerAdapter.java:75)
        at org.springframework.amqp.rabbit.listener.adapter.MessagingMessageListenerAdapter.invokeHandler(MessagingMessageListenerAdapter.java:262)
        at org.springframework.amqp.rabbit.listener.adapter.MessagingMessageListenerAdapter.invokeHandlerAndProcessResult(MessagingMessageListenerAdapter.java:208)
        at org.springframework.amqp.rabbit.listener.adapter.MessagingMessageListenerAdapter.onMessage(MessagingMessageListenerAdapter.java:147)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:1670)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.actualInvokeListener(AbstractMessageListenerContainer.java:1589)
        at jdk.internal.reflect.GeneratedMethodAccessor423.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at org.springframework.retry.interceptor.RetryOperationsInterceptor$1.doWithRetry(RetryOperationsInterceptor.java:97)
        at org.springframework.retry.support.RetryTemplate.doExecute(RetryTemplate.java:329)
        at org.springframework.retry.support.RetryTemplate.execute(RetryTemplate.java:225)
        at org.springframework.retry.interceptor.RetryOperationsInterceptor.invoke(RetryOperationsInterceptor.java:122)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
        at org.springframework.amqp.rabbit.listener.$Proxy422.invokeListener(Unknown Source)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:1577)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:1568)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.executeListener(AbstractMessageListenerContainer.java:1512)
        at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.doReceiveAndExecute(SimpleMessageListenerContainer.java:993)

[结果]

[期望]