Loading

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

Julkaisupäivä: Jul 17, 2026
Kuvaus
EPCProductAttribJSONBatchJob we are getting the Error "List has no rows for assignment to SObject"
Ratkaisu
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.
Knowledge-artikkelin numero

000396149

 
Ladataan
Salesforce Help | Article