You have Selected a Database which is not in the List of Databases to be Upgraded. Please Try Again. when Upgrading FIMS Using the Setup.exe

When upgrading FIMS using the setup.exe the message 'You have Selected a Database which is not in the List of Databases to be Upgraded. Please Try Again ' occurs.
This message occurs if the database to be upgraded is not running. The upgrade process builds a list of all databases from the ini that can be successfully connected to. If the database is not running, the upgrade will not detect the database and the message will occur.

This can also occur is there is an issue with the database that causes the upgrader to not be able to see it. To determine if the upgrader identified an issue with the database, review the following logs that the upgrader creates. They are located in npo\found\fims:

upgrade-database-issues
upgrade-database-list
upgrade-database-skip


If you have reviewed the logs above and see no issues as to why the database was skipped, then to resolve this issue, do the following:

1. Open cmd.exe. being sure to run as an administrator
2. Type in the following: (note, change the ini to something that does work with proper n: paths in the database section) and run all as separate commands:

set dlc=n:\dlc

%dlc%\bin\probkup n:\found\dbfiles\found n:\found\dbfiles\found-20180601.bkp

cd /d n:\found\fims

%DLC%\bin\prowin32.exe -p tools\FimsInstallCompile.p -assemblies ..\assemblies -ini ..\configfiles\FIMSNT.INI -s 2560 -inp 32000 -param nodbbackup


Note that the new files that were installed during the 1st portion of the upgrade which is the FIMS application upgrade will still be there, so there is no need to re-run the upgrade from the beginning for this issue. These commands are finishing the 2nd part of the upgrade, which is to upgrade the database itself.

 

Environment

 FIMS

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.