Project and Portfolio Management Practitioners Forum
Showing results for 
Search instead for 
Did you mean: 

Upgrading thru 8.0 to 9.1 question

Go to solution
Occasional Contributor

Upgrading thru 8.0 to 9.1 question

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.


Thank you all,


Jim Esler
Honored Contributor

Re: Upgrading thru 8.0 to 9.1 question

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.

Occasional Contributor

Re: Upgrading thru 8.0 to 9.1 question

We will start in restricted mode as well.


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.


We will just hope the script runs fast.


Thank you for your suggestion.



Regular Collector

Re: Upgrading thru 8.0 to 9.1 question

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. :smileyhappy:


It will probably depend on how much TM data you have out there, and thus how many orphaned time sheet lines & bad data.

//Add this to "OnDomLoad" event