topic Cross-referencing RecordType table migrating Prod to Sandbox in Talend Studio

Cross-referencing RecordType table migrating Prod to Sandbox

Anonymous — Sat, 16 Nov 2024 02:27:54 GMT

My sandbox has different RecordType ID values for my custom object than in prod, so I created a lookup in the tMap to compare the "DeveloperName" and "SobjectType" fields and return the correct "ID", but Talend is giving me an INVALID_CROSS_REFERENCE_KEY error.

BTW, the table marked "row20" is the RecordType table from the sandbox, so the ID should be valid, FWIW...

I tried to do this via the Upsert mapping but can't add a user key to the RecordType object in SFDC.

Can someone help me understand how to make this work?

Re: Cross-referencing RecordType table migrating Prod to Sandbox

TRF — Tue, 12 May 2020 21:22:09 GMT

Based on the message in log.txt, it seems thé user profile is not authorized for this recordType.
Check this on salesforce side.

Re: Cross-referencing RecordType table migrating Prod to Sandbox

Anonymous — Tue, 12 May 2020 23:54:38 GMT

@TRF was correct...it took me a while but this link helped...if anyone runs into this issue.

https://dataloader.zendesk.com/hc/en-us/community/posts/209640028-How-do-I-Fix-this-error-SOURCE-RecordTypeId-DESTINATION-RecordTypeId-ERROR-Record-Type-ID-this-ID-value-isn-t-valid-for-the-user-