Error upgrading Foglight Management Server (FMS) to 5.7.5:
FATAL [forge-startup] com.quest.nitro.service.upgrade.db.DatabaseUpgradeService - Fatal error connecting to database. Shutting down Foglight server... Check and make sure your database configuration is correct and the database server is up running.
java.lang.RuntimeException: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
Login to the repository database and run the following (replace tzname with actual time zone used by the FMS):
select tzname, tzabbrev from v$timezone_names where tzname='Antarctica/South_Pole';
If no rows are returned, contact your database administrator to resolve the missing time zone.