Loading

EPC Job receives "List has no rows for assignment to sObject" error.

Дата публикации: Jul 17, 2026
Описание
EPCProductAttribJSONBatchJob we are getting the Error "List has no rows for assignment to SObject"
Решение
The root cause of the issue is that orphan ObjectTypeId does exist in the environment and the Id is on the Product2 record cause either by a deployment or a manually deleting of the ObjectType__c record.

Due to this, Getting the error "List has no rows for assignment to SObject" when running EPCProductAttribJSONBatchJob

Please - execute this query to validate the products that are causing the issue:

SELECT id, name , vlocity_cmt__ObjectTypeId__c , vlocity_cmt__ObjectTypeId__r.Name
FROM Product2 WHERE vlocity_cmt__ObjectTypeId__r.Name = null and vlocity_cmt__ObjectTypeId__c !=null

From the above output of SOQL Query, if you can try to open an id from field vlocity_cmt__ObjectTypeId__c, you can notice that that does not exist, so all the records from this field vlocity_cmt__ObjectTypeId__c are orphan and there is no such object reference exist on your org.
Номер статьи базы знаний

000396149

 
Загрузка
Salesforce Help | Article