Venio Installation: Upgrade fails from version 7.X to 8.X

Problem

Project upgrade fails from 7.X to 8.X

Resolution

Note: Please take backup of tbl_pj_ProjectSetup table before starting the steps below. Following script assumes you are upgrading from v7.30.0.0. If not please replace '7.30.0.0' with proper version number to match yours.

1. Run following in VenioPCD. This is to fake as if projects are already in v8.0.

update tbl_pj_ProjectSetup 
set ProjectUpdatedVersion = '8.0.0.0' where ProjectUpdatedVersion = '7.30.0.0'

2. Launch "C:\Program Files\Venio\Venio Database\VenioDatabaseSetup.exe"

3. On the 1st screen click 'Next'. 

4. You should now see all the projects with 'Current Version' set to '8.0.0.0'. Leave the upgrade tool running.

5. Run following script in VenioPCD . This is to reset the version of project database to the correct one.

update tbl_pj_ProjectSetup 
set ProjectUpdatedVersion = '7.30.0.0' where ProjectUpdatedVersion = '8.0.0.0' 

6. Now go back to the database upgrade utility you left running at step (4); select projects you'd want to upgrade and click 'Upgrade Selected'.