+13
I want to import data into a custom logical unit using Excel Data Migration but one of the fields is a Referenced fields?
Data sample to import.
Custom object to import into.
Referenced object
Migration Job.
Error when I try to execute.
integrity constraint (IFSAPP.ARE_WATER_JET_PART_GRP1_CRK) violated - parent key not found
Can this be done? How should I setup? I think I need to get the OBJKEY for the referenced field?
Need help.
Thank you,
Best answer by Technical Outlaws
View original
+11
Correct, you have pretty much answered your own question. If you manually entered a record in your custom logical unit, you will see by inspecting the table ARE_WATER_JET_PART_GRP_CLT that the column CF$_PROG_GRP actually holds the OBJKEY of the referenced field and not the data value.
So from a data migration point of view, it is the OBJKEY that you need to feed into the CF$_PROG_GRP_DB column.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.