+ Start a Discussion
Ayyagari RameshAyyagari Ramesh 

field_integrity_exception, product hierarchy: id value of incorrect type: a041h00000lj99fqas: [product_node_id__c]

Hi All,  
there is a integration happening into salesforce from SAP end and when the load happens the records created in custom object Product staging and from there using trigger the new record gets created in standard object product..Now the records are not getting created from source file when load is happening. when tried out through manual load by taking one records using workbench and set the debug logs and exception error got captured as below:
field_integrity_exception, product hierarchy: id value of incorrect type: a041h00000lj99fqas: [product_node_id__c]

note - product_node_id__c is a lookup field.
AbhishekAbhishek (Salesforce Developers) 
If you are receiving the Salesforce Error "ID Value of Incorrect Type" this means that an ID being sent to Salesforce is not the correct type that Salesforce is expecting.

For example, some fields in Salesforce can only accept certain ID types (e.g., Contact ID, Account ID, etc.).  If you map value for an ID of a different type, you will see this error.  Additionally, if you are mapping an ID twice within your connector, you might see this error as well.

Try the solution as mentioned in this article (https://help.formassembly.com/help/salesforce-error-id-value-of-incorrect-type).

For further reference, you can check this developer blog too (https://salesforce.stackexchange.com/questions/66105/field-integrity-exception-related-to-id-allow-activity-label-exception-change).

I hope you find the above information is helpful. If it does, please mark as Best Answer to help others too.

Thanks.