Database Schema Upgrade Failed with the following error:
Exception in thread "main" com.agiliance.com mon.ALException: code: 0 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) DROP TRIGGER IF EXISTS trig_agl_raproject_delete at com.agiliance.com mon.SQLScriptProcessor.executeScript_internal(SQLScriptProcessor.java:83) at com.agiliance.com mon.SQLScriptProcessor.executeScript(SQLScriptProcessor.java:55) at com.agiliance.admin.upgrade.SQLUpgradeTask.execute(SQLUpgradeTask.java:33) at com.agiliance.admin.upgrade.UpgradeProcessor.upgradeDatabase(UpgradeProcessor.java:630) at com.agiliance.admin.upgrade.UpgradeProcessor.upgradeDatabaseSchema(UpgradeProcessor.java:48) at com.agiliance.admin.upgrade.UpgradeProcessor.main(UpgradeProcessor.java:1276) database schema upgrade failed
To resolve the error:
Add the line log-bin-trust-function-creators=1 to my.ini, prior to upgrading. Then restart MySQL database and RiskVision services.