spring 将字符串转换为hotfolder中的仓库对象

wqlqzqxt 于 2024-01-05 发布在 Spring

关注(0)|答案(1)|浏览(141)

我们目前在组织外部收到一个CSV。这是为了更新表StockLevel。当我们收到CSV时，而不是实际的仓库代码，我们在第二列中收到一个经销商代码。我所做的是创建一个翻译器，它应该Map经销商代码并将其转换为正确的仓库。问题是我得到错误。当我删除第二个翻译器时，它正在工作，所以我猜原因是翻译的位置。你知道我如何才能做我需要做的正确使用翻译吗？
Impex：
第一个月
错误：

INFO  [AzureIntegrationTaskExecutorThread-master-1] (000099CE) [QwentaniumStockImportDealerTranslator] Number of sellers during SFTP job: 3
INFO  [AzureIntegrationTaskExecutorThread-master-1] (000099CE) [QwentaniumStockImportDealerTranslator] Dealer number in SFTP job: 133180 matches with seller: 10814-Goliath
ERROR [AzureIntegrationTaskExecutorThread-master-1] (000099CE) [FlexibleSearch] line 3 at main script: Flexible search error occured...
WARN  [AzureIntegrationTaskExecutorThread-master-1] (000099CE) [ImpExImportReader] line 3 at main script: dumped unresolved line ValueLine[unresolvable:SQL search error - enable the property 'flexible.search.exception.show.query.details' for more details,line 3 at main script,null,HeaderDescriptor[line 2 at main script, insert_update, StockLevel, {}, [productCode, warehouse, available] ],{1=ValueEntry('00440-3007'=00440-3007,unresolved=false,ignore=false), 2=ValueEntry('133180'=WH_STORE02-Goliath,unresolved=false,ignore=false), 3=ValueEntry('1'=null,unresolved=null,ignore=false)}]
ERROR [AzureIntegrationTaskExecutorThread-master-1] (000099CE) [CronJobErrorHandler] line 3 at main script: Exception ocurred, will ignore: de.hybris.platform.impex.jalo.ImpExException: SQL search error - enable the property 'flexible.search.exception.show.query.details' for more details[HY--1]
de.hybris.platform.impex.jalo.ImpExException: SQL search error - enable the property 'flexible.search.exception.show.query.details' for more details```