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.
To resolve do the following:

1. This message occurs if the database to be upgraded is not running. Make sure that the database is 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.

2. 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

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

Note: Be sure that the FIMSNT ini file has the correct paths to the database in the database section of the ini file.

1. Open cmd.exe. being sure to run as an administrator
2. Type in the following and run all as separate commands:

set dlc=n:\dlc

%dlc%\bin\probkup n:\found\dbfiles\found n:\found\dbfiles\found-20180601.bkp  (this bkp file name is just an example name, you can name it what you like)

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.