SAP Knowledge Base Article - Preview

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


SAP Commerce Cloud 1905 ; SAP Commerce Cloud 2211


SQL error, converting data type, DefaultTaskService , KBA , CEC-SCC-PLA-PL , Platform , 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.