Issues upgrading an Ektron Database that contains custom database triggers

  • Updated

You may experience issues upgrading your Ektron database if it contains custom database triggers.

To clarify, a database trigger is a database object that is attached to table similar to a stored procedure. These triggers are only fired when an INSERT, UPDATE or DELETE statement occurs. A database trigger can cause issues with the Ektron SiteSetup Utility, as it runs SQL calls to the database containing these statements which may fire off these elements that are not standard to an Ektron out-of-the-box database.

 

To resolve this issue

  1. Remove custom triggers applied to the database.
  2. Update the Ektron database using the SiteSetup Utility.
  3. Reapply the triggers to the database.

For more information on database triggers, click here.