SAP Knowledge Base Article - Preview

3771307 - Files in Cloud hot folder not processed because of "Flexible search error occured..."

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")
  try {
      def query = new de.hybris.platform.servicelayer.search.FlexibleSearchQuery(
         "SELECT {pk} FROM {ApplicationResourceLock} WHERE {lockKey} = ?lockKey AND {region} = ?region AND {timestamp} < ?expiryDate"
      )
      query.addQueryParameter("lockKey", "7c67706a-d0d1-3e8a-b38e-1693a2906c22")
      query.addQueryParameter("region", "yCloudHotfolders")
      query.addQueryParameter("expiryDate", new java.util.Date())
      def result = fss.search(query)
      println "result count: " + result.result.size()
  } catch(e) {
      def sb = new StringBuilder()
      def t = e
      while (t != null) {
          sb.append(">>> " + t.class.name + ": " + t.message + "\n")
          t = t.cause
      }
      println sb.toString()
  }

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

SAP Commerce Cloud all versions

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.