3337143 - SQL Error: Error converting data type nvarchar to bigint.

• Some order business processes are getting stuck and found an error spike for the class: de.hybris.platform.processengine.process.ProcessengineTaskRunner.
• Identified the below error in logs from BackgroundProcessing POD:
  Error executing ActionNode with ID [createSchedulerAppointment]: SQL search error - Error converting data type nvarchar to bigint. 
  query = 'SELECT item_t0.PK FROM products item_t0 JOIN catalogversions item_t1 ON item_t0.p_catalogversion = item_t1.PK JOIN catalogs item_t2 ON item_t2.PK = item_t1.p_catalog WHERE ( item_t1.p_version =? and item_t2.p_id =? and item_t0.p_code IN (?)) AND ((item_t0.TypePkString=? AND item_t1.TypePkString IN (?,?) AND item_t2.TypePkString IN (?,?,?) ))', values = [Online, customProductCatalog, 12345678, 000754, 000234, 000674, 000482, 000250, 000906]
• DefaultTaskService.process throwing exception "de.hybris.platform.task.RetryLaterException"

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP Commerce Cloud

SQL error, converting data type, DefaultTaskService , KBA , CEC-SCC-PLA-PL , Platform , Problem