Upgrade Fails to latest release

[seanmdit]

When going to upgrade from 8.5 to the latest build I receive the following error. Any ideas on how to correct this?

 

Error: Cannot find the object "PasswordLists" because it does not exist or you do not have permissions.

Stack Trace: at Passwordstate.Upgrade.Build_8537_Updates()

 

4/13/2020 10:44:22 AM - Passwordstate upgrade started.
4/13/2020 10:44:25 AM - Stopping of the Passwordstate Windows Service started.
4/13/2020 10:44:25 AM - Stopping of the Passwordstate Windows Service completed.
4/13/2020 10:44:25 AM - Compressing and backing up of web files started.
4/13/2020 10:45:27 AM - Compressing and backing up of web files completed.
4/13/2020 10:45:28 AM - Removing old backups started.
4/13/2020 10:45:28 AM - Removing old backups completed.
4/13/2020 10:45:28 AM - Downloading of file passwordstate_upgrade.zip started.
4/13/2020 10:46:35 AM - Downloading of file passwordstate_upgrade.zip completed.
4/13/2020 10:46:35 AM - Extracting of files in file passwordstate_upgrade.zip started.
4/13/2020 10:48:22 AM - Extracting of files in file passwordstate_upgrade.zip completed.
4/13/2020 10:48:22 AM - Copying of new files started.
4/13/2020 10:48:57 AM - Finished copying of new files.
4/13/2020 10:48:57 AM - Starting of the Passwordstate Windows Service started.
4/13/2020 10:48:58 AM - Starting of the Passwordstate Windows Service completed.
4/13/2020 10:48:58 AM - Finished starting the Passwordstate Windows Service.
4/13/2020 10:48:58 AM - Finished deleting the Passwordstate_Upgrade.zip file.
4/13/2020 10:49:07 AM - Finished deleting all temp files in the folder /upgrades/passwordstate.
4/13/2020 10:49:07 AM - Preparing for upgrade has completed successfully.
4/13/2020 10:51:30 AM - Build 8537 Upgrade Started.
4/13/2020 10:51:31 AM - Build Process 'Build_8537_Updates' failed with the following error - Cannot+find+the+object+%22PasswordLists%22+because+it+does+not+exist+or+you+do+not+have+permissions. ::: +++at+Passwordstate.Upgrade.Build_8537_Updates()
4/13/2020 10:52:22 AM - Build 8537 Upgrade Started.
4/13/2020 10:52:22 AM - Build Process 'Build_8537_Updates' failed with the following error - Cannot+find+the+object+%22PasswordLists%22+because+it+does+not+exist+or+you+do+not+have+permissions. ::: +++at+Passwordstate.Upgrade.Build_8537_Updates()
4/13/2020 10:57:18 AM - Build 8537 Upgrade Started.
4/13/2020 10:57:18 AM - Build Process 'Build_8537_Updates' failed with the following error - Cannot+find+the+object+%22PasswordLists%22+because+it+does+not+exist+or+you+do+not+have+permissions. ::: +++at+Passwordstate.Upgrade.Build_8537_Updates()
 

[support]

Hi Sean,

 

Sorry you're having some issues, but this is a very strange error. Basically we are trying to modify the PasswordLists table here with the standard SQL 'ALTER' command, and the error does not make much sense as the table should exist.

 

Can you tell us anything special about your SQL environment? Is it local SQL, or SQL in the cloud? What sort of account are you using for connectivity - by default, it should be a SQL Account called passwordstate_user, and it should have db_owner rights to the database.

Regards
Click Studios