2023-04-10 10:16:47.134 DEBUG 1 --- [nio-9102-exec-9] c.w.d.r.I.getAmzFbaVirtualInventoryLevel : ==> Preparing: SELECT tafvi.id AS id, tafvi.p_id AS pId, tafvi.warehouse_type AS warehouseType, tafvi.warehouse_level AS warehouseLevel, tafvi.warehouse_name AS warehouseName, tafvi.source_id AS sourceId, tafvi.fulfillment_country AS fulfillmentCountry, tafvi.customer_id AS customerId, tafvi.seller_id AS sellerId, tafvi.fnsku AS fnsku, tafvi.asin AS asin, tafvi.msku AS msku, tafvi.fulfillable_quantity AS fulfillableQuantity, tafvi.inbound_working_quantity AS inboundWorkingQuantity, tafvi.inbound_shipped_quantity AS inboundShippedQuantity, tafvi.inbound_receiving_quantity AS inboundReceivingQuantity, tafvi.inbound_quantity AS inboundQuantity, tafvi.total_reserved_quantity AS totalReservedQuantity, tafvi.pending_customer_order_quantity AS pendingCustomerOrderQuantity, tafvi.pending_transshipment_quantity AS pendingTransshipmentQuantity, tafvi.fc_processing_quantity AS fcProcessingQuantity, tafvi.total_unfulfillable_quantity AS totalUnfulfillableQuantity, tafvi.inventory_age_0_to_30_days AS inventoryAge0To30Days, tafvi.inventory_age_31_to_60_days AS inventoryAge31To60Days, tafvi.inventory_age_61_to_90_days AS inventoryAge61To90Days, tafvi.inventory_age_91_to_180_days AS inventoryAge91To180Days, tafvi.inventory_age_181_to_270_days AS inventoryAge181To270Days, tafvi.inventory_age_271_to_365_days AS inventoryAge271To365Days, tafvi.inventory_age_365_plus_days AS inventoryAge365PlusDays, tafvi.days_of_supply AS daysOfSupply, tafvi.weeks_of_cover_t30 AS weeksOfCoverT30, tafvi.weeks_of_cover_t90 AS weeksOfCoverT90, tafvi.item_volume AS itemVolume, tafvi.volume_unit_measurement AS volumeUnitMeasurement, tafvi.storage_volume AS storageVolume, tafvi.sell_through AS sellThrough, tafvi.estimated_excess_quantity AS estimatedExcessQuantity, tafvi.sales_amount_1_days AS salesAmount1Days, tafvi.sales_amount_7_days AS salesAmount7Days, tafvi.sales_amount_14_days AS salesAmount14Days, tafvi.sales_amount_30_days AS salesAmount30Days, tafv
i.sales_amount_60_days AS salesAmount60Days, tafvi.sales_amount_90_days AS salesAmount90Days, tafvi.last_update_time AS lastUpdateTime, tafvi.remark AS remark, tafvi.is_narf AS isNarf, tafvi.is_pan_eu AS isPanEu, tafvi.is_efn AS isEfn, tafvi.item_name AS itemName, tafvi.product_name_cn AS productNameCn, tafvi.sku AS sku, tafvi.image_url AS imageUrl, tafvi.salesman_id AS salesmanId, tafvi.salesman_name AS salesmanName, tafvi.first_business_people_id AS firstBusinessPeopleId, tafvi.first_business_people_name AS firstBusinessPeopleName, tafvi.country_code AS countryCode, tafvi.currency_code AS currencyCode, tafvi.exist_child AS existChild, tafvi.seller_name AS sellerName, tafvi.qty_to_be_charged_ltsf_6_to_12_mo AS qtyToBeChargedLtsf6To12Mo, tafvi.qty_to_be_charged_ltsf_12_last_mo AS qtyToBeChargedLtsf12LastMo, tafvi.projected_to_be_charged_ltsf_6_to_12_mo AS projectedToBeChargedLtsf6To12Mo, tafvi.projected_to_be_charged_ltsf_12_last_mo AS projectedToBeChargedLtsf12LastMo, tafvi.estimated_storage_cost_next_month AS estimatedStorageCostNextMonth, tafvi.projected_to_be_charged_ltsf AS projectedToBeChargedLtsf, tafvi.transit_quantity AS transitQuantity, tafvi.pre_received_date AS preReceivedDate FROM t_amz_fba_virtual_inventory tafvi WHERE tafvi.customer_id = ? AND tafvi.is_deleted = 0 AND tafvi.warehouse_level = ? order by totalReservedQuantity desc,tafvi.id desc LIMIT ?
2023-04-10 10:16:47.136 DEBUG 1 --- [nio-9102-exec-9] c.w.d.r.I.getAmzFbaVirtualInventoryLevel : ==> Parameters: 1(Long), 1(Integer), 200(Integer)
2023-04-10 10:16:48.322 ERROR 1 --- [io-9102-exec-10] .c.e.DefaultGlobalExceptionHandlerAdvice : 系统异常:
org.springframework.http.converter.HttpMessageNotReadableException: JSON parse error: Cannot deserialize value of type `com.zhcxkj.center.warehouse.client.dto.AmzFbaStockInfoCmd` from Array value (token `JsonToken.START_ARRAY`); nested exception is com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot deserialize value of type `com.zhcxkj.center.warehouse.client.dto.AmzFbaStockInfoCmd` from Array value (token `JsonToken.START_ARRAY`)
at [Source: (org.springframework.util.StreamUtils$NonClosingInputStream); line: 1, column: 1]
at org.springframework.http.converter.json.AbstractJackson2HttpMessageConverter.readJavaType(AbstractJackson2HttpMessageConverter.java:391)
at org.springframework.http.converter.json.AbstractJackson2HttpMessageConverter.read(AbstractJackson2HttpMessageConverter.java:343)
at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodArgumentResolver.readWithMessageConverters(AbstractMessageConverterMethodArgumentResolver.java:185)
at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.readWithMessageConverters(RequestResponseBodyMethodProcessor.java:160)
at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.resolveArgument(RequestResponseBodyMethodProcessor.java:133)
at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:122)
at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:179)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:146)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1070)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot deserialize value of type `com.zhcxkj.center.warehouse.client.dto.AmzFbaStockInfoCmd` from Array value (token `JsonToken.START_ARRAY`)
at [Source: (org.springframework.util.StreamUtils$NonClosingInputStream); line: 1, column: 1]
at com.fasterxml.jackson.databind.exc.MismatchedInputException.from(MismatchedInputException.java:59)
at com.fasterxml.jackson.databind.DeserializationContext.reportInputMismatch(DeserializationContext.java:1741)
at com.fasterxml.jackson.databind.DeserializationContext.handleUnexpectedToken(DeserializationContext.java:1515)
at com.fasterxml.jackson.databind.DeserializationContext.handleUnexpectedToken(DeserializationContext.java:1462)
at com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeFromArray(BeanDeserializer.java:638)
at com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:210)
at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:186)
at com.fasterxml.jackson.databind.deser.DefaultDeserializationContext.readRootValue(DefaultDeserializationContext.java:323)
at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:4674)
at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3682)
at org.springframework.http.converter.json.AbstractJackson2HttpMessageConverter.readJavaType(AbstractJackson2HttpMessageConverter.java:380)
... 56 common frames omitted
重现步骤