This content has been marked as final. Show 3 replies
Unfortunately my upgrade experience to 8.1 is all 7.5. However, as a general rule for something like this I would write SQL to do the migration, send it to Oracle and ask them to review it and add it to the upgrade non standard change request for free.
Thanks for the reply!
I heard from Oracle today that the upgrade scripts have been fixed in 8.2.2 so I've effectively asked what you've suggested: that they send me the SQL scripts, along with authorisation to use them.
I've been messing around all day with this, trying to develop a fix. However, 'Data Validation' is all specialized class, so I can't use scripting or anything to fix the data - Validation Rule Sets have to be 'Revised' and 'Activated' in order to change the underlying rules and there's no supported mechanism to do this. I also believe that the 'EIM' suggestion in the Oracle SR is just a lazy excuse to say 'Solution Offered' - there is no way to use EIM to fix the underlying relationship issue between Rules and Messages. Waste of time even putting it in as I've had to go down this path (and waste hours) to find a dead end.
I agree EIM is not an alternative. ADM or export/import would be, however for that you would still have to set up correct data validation rules in your dev upgrade environment and remember to manage any changes made in production go into dev upgrade and exported so that they can be imported post upgrade. Depending on extent of use this could be impractical. Simpler to resolve with the NSCR.