When upgrading the Foglight Management Server (FMS), it fails with the error below:
A Database Upgrade Error Occurred
---------------------------------
The following upgrade error occurred:
Please use the following option to start the server : -Dfoglight.database.upgrade=true
YYYY-MM-DD HH:MM:SS.SSS INFO Current database schema version: 5.5.6.12
YYYY-MM-DD HH:MM:SS.SSS FATAL The Oracle database user has not been assigned the CREATE PROCEDURE privilege.
YYYY-MM-DD HH:MM:SS.SSS ERROR Upgrade failed: com.quest.nitro.upgrade.UpgradeException: Pre-upgrade validation failed.log4j:WARN No appenders could be found for logger (org.springframework.context.support.ClassPathXmlApplicationContext).
log4j:WARN Please initialize the log4j system properly.
--- DatabaseUpgrade_YYYY-MM-DD_HHMMSS_001
YYYY-MM-DD HH:MM:SS.SSS ERROR [main] com.quest.nitro.upgrade.db.DatabaseUpgradeLauncher - Upgrade failed: java.lang.RuntimeException: java.sql.SQLException: Login failed for user 'DOMAIN\user'.