We are going to be upgrading to 9.1 this fall, so are working on our sandbox to test the procedure. We see that we will have to run "ActualsOutOfSyncCorrectionScript.sql" to correct some information on time sheets.
Can we run this while people are on the system? What would happen if someone updates a time sheet or a project task durring this script?
We are trying to shorten the amount of downtime that weekend and would love to run some validation issues early.
When we do an upgrade like this, we first start up the application in RESTRICTED mode. This allows us to look everything over and complete any remaining steps before allowing users to log in. When everything is done, we switch back to NORMAL mode.
I was not thinking. To run the script I must drop the application. So, if I want to do it the week before I would have 2 outages (run this script then a week later upgrade) and run the risk of someone causing bad data.
I found it ran pretty quickly, but there were other data-fix scripts I had to run as well and they all wanted a reboot & restart upgrade in between. I had cloned PROD to test the upgrade, so I knew ahead of time all the fix scripts I needed and I just ran them all at once (in sequence) before even starting the upgrade script on the real PROD.
It will probably depend on how much TM data you have out there, and thus how many orphaned time sheet lines & bad data.