-
Title
"service=DatabaseUpgrade java.util.NoSuchElementException" reported when attempting to start FMS -
Description
V5.5.8 FMS does not start up when pointed at restored V5.5.8 SQL Server 2005 repository. The following error message is reported:
2012-05-07 12:12:22.177 WARN [main] org.jboss.system.ServiceController - Problem starting service com.quest.nitro:service=DatabaseUpgrade
java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken(StringTokenizer.java:332)
at com.quest.nitro.upgrade.Version.<init>(Version.java:43)
at com.quest.nitro.upgrade.db.DatabaseVersionHelper.getCurrentVersion(DatabaseVersionHelper.java:66)
at com.quest.nitro.service.upgrade.db.DatabaseUpgradeService.startService(DatabaseUpgradeService.java:150)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at com.quest.nitro.service.NitrogenService.jbossInternalStart(NitrogenService.java:89)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
We verified the following, and everything looks good but the FMS won't start.
* The "foglight" database is the default database for the foglight DB user and the foglight DB user had DBA permissions on the foglight database.
* The DB user is a SQL Server user.
* We can connect from the FMS host to the restored SQL Server repository (also on the FMS host) as the "foglight" user, using an ODBC connection and a command line connection.
* Ran the following keyman command to check that the encrypted DB user password in the foglight.config file is correct.
%Foglight_home%\bin\keyman.bat encpwd <your password> foglight.defaultkey
* There is no firewall between the FMS host and the repository host.
-
Cause
The version string (1) returned from the following select statement was not in the proper format (5.x.x.x) for a Sql Server 2005 instance.
SELECT dbv_version FROM database_version
Running the following SQL returned the following output:
use foglight;
SELECT dbv_version FROM database_version;
dbv_version
------------------------------
1
5.5.5.7
5.5.6.1
5.5.6.10
5.5.6.11
...
-
Resolution
Run the following SQL statements from the SQL Server repository:
use <database name>;
SELECT dbv_version FROM database_version;
If the version reported in one of the lines is not in the correct format for the SQL Server version delete the row in the database_version table that contains the incorrect version.