We're trying to determine why we see these messages in our Foglight Management Server (FMS) logs:
An error occurred while truncating table obs_metric_scalar_0108: java.lang.RuntimeException: java.sql.SQLException: ORA-04098: trigger 'SYS.XDB_PI_TRIG' is invalid and failed re-validation"
This issue is due to the Oracle setup. Foglight is just trying to truncate one of its own tables and the Oracle DDL triggers are interfering.
Suggested resolution was to remove the Foglight installation and perform the correct steps to initialize/populate the back-end database. Some of the configuration can be saved by exporting before removing the FMS installation, then importing this information into the new installation.
One can export any custom dashboards, rules, registry variables before performing the uninstall, then reimport the exported text files. Exporting custom dashboards SOL39370
Below is an example procedure where I modified step 5 for a uninstall/reinstall. The CAVEAT about Catalyst rules doesn't apply since you will be importing into essentially the same hostname FMS.
See SOL46240
