Hi all, I'm working on data migration, and often run into validation error due to the processing order of the tables in the same package (Some tables have to be processed first for other tables to be processed). I know that there is a Processing Order field for the package and there is a Processing Order field for the fields inside the tables. However, there is no Processing Order fields for the tables in the same package.
I do not want to assign the tables to different packages and process them in different orders because I won't be the one doing the job for the client and the person who's doing that might mess up. Is there a way to specify the processing order of the tables in the same package so that I can just set it up and apply the package without error?
*This post is locked for comments
There is no direct way of setting up the order of the tables in the package, as they are imported by their Table ID. One option, as you correctly mentioned, is to move some table to a different package and process them separately. Another option is to run the package without validation, but I do not recommend that. Also, you can try to apply again the tables of already imported data which were processed with errors. If you have relation errors, you can open the package, find these tables and apply them again. It should give you the correct result in this case.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156