+14I 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
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.
+11Correct, 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 E-mail address. We'll send you an e-mail with instructions to reset your password.