Symptom
Files in Cloud hot folder not processed.
Threads HotfolderLeaderInitiator-master-1 in all BGP pods keep printing log:
| Flexible search error occured... |
No data in table applicationresourcelock.
No threads AzureIntegrationTaskExecutorThread-master-* and AzureIntegrationUnprocessedFileTaskExecutorThread-master-* in all BGP Pods.
Groovy script
| println spring.getBean("azureInboundChannelAdapter").isRunning() |
shows false in all BPG pods.
Groovy script
|
spring.getBean("configurationService").configuration.setProperty("flexible.search.exception.show.query.details", "true") def fss = spring.getBean("flexibleSearchService") |
outputs
| >>> de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: SQL search error - Operand type clash: datetime2 is incompatible with timestamp query = 'SELECT item_t0.PK FROM applicationresourcelock item_t0 WHERE ( item_t0.p_lockkey = ? AND item_t0.p_region = ? AND item_t0.p_timestamp < ?) AND (item_t0.TypePkString=? )', values = [7c67706a-d0d1-3e8a-b38e-1693a2906c22, yCloudHotfolders, Tue Jun 23 03:52:27 GMT 2026, 8796137062482] >>> de.hybris.platform.jalo.flexiblesearch.FlexibleSearchException: SQL search error - Operand type clash: datetime2 is incompatible with timestamp query = 'SELECT item_t0.PK FROM applicationresourcelock item_t0 WHERE ( item_t0.p_lockkey = ? AND item_t0.p_region = ? AND item_t0.p_timestamp < ?) AND (item_t0.TypePkString=? )', values = [7c67706a-d0d1-3e8a-b38e-1693a2906c22, yCloudHotfolders, Tue Jun 23 03:52:27 GMT 2026, 8796137062482] >>> com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: datetime2 is incompatible with timestamp |
Column p_timestamp in table ApplicationResourceLock is of type “timestamp”.
Read more...
Environment
SAP Commerce Cloud
Product
Keywords
cloud hot folder, azureInboundChannelAdapter, ApplicationResourceLock, timestamp, datetime2, leader election , KBA , CEC-SCC-CLA-ENV-CST , Cloud Storage , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview