WARNING - The following Ostendo Database triggers (rules) were found to be turned off - Message when Logging into Ostendo

WARNING - The following Ostendo Database triggers (rules) were found to be turned off - Message when Logging into Ostendo

This message is displayed to the user upon logging into Ostendo when one or more database triggers have been detected as turned off.




By default, all triggers in an Ostendo database should always be turned 'On'.

Using Ostendo when Triggers have been detected as 'Turned Off' will potentially corrupt and damage the integrity of the database beyond repair. Therefore if this message is displayed upon logging into Ostendo the following action must be taken immediately.
  1. Advise all users to exit Ostendo immediately
  2. Advise the Consulting Partner for the site immediately for them to take action.
  3. Log into Ostendo and Press OK to acknowledge the Warning Message
  4. Go to File -> Active Connections and press the Get Connections button to ensure you are the only user logged onto Ostendo
  5. Download the Attached Command Script and Run it (File -> System Configuration _>Run Command Script)
  6. Log out of Ostendo
  7. Log into Ostendo and check to ensure you are not presented with this Warning Message again


What Causes this Message?

Typically this is caused when a user is in the process of performing a Global Name Change or a Data Merge. These processes initially turn off all database triggers and then update the necessary data. Then at the end of the routine, all Triggers are turned back on.

If in the coarse of this process, the connection to the database is interrupted eg: power failure, network problem or the user terminating Ostendo via Task Manager, this will result in some if not all triggers being left Inactive (turned off).

As a precautionary measure, ensure any users who run these routines are aware of this to ensure the database remains stable.




    • Related Articles

    • Screen Logging

      File->System Settings->Environment Settings (tab)->Activate Screen Logging Ostendo allows you to trap user activity and habits enabling you to design Workflows and other tools to assist users in areas they are repetitively accessing within Ostendo. ...

    • Audit Logging

      File->System Configuration->Audit Logging If Audit Logging is employed, you should remember that this will create records in the AUDITLOGGING Table Current records can be displayed via General->Inquiries->Inquiry - Audit Logging Audit Logging allows ...

    • Can't format message 13:180

      This message might appear when trying to access the Demo or Default databases after performing an installation of Ostendo on a server with no errors during the installation dmSecurity.LicenceDB: Can't format message 13:180 -- message file C:\Program ...

    • Database Sweep Interval Setting To Improve Performance

      Amending the Database Sweep Interval Setting Overview: On some large databases, performance issues maybe experienced due to the database Sweep Interval setting being set at a higher level than need be. By default the Sweep Interval setting is set to ...

    • Ostendo Demo Database (Update 211)

      New Ostendo Update 211 Demo Database: http://ostendo.info/downloads/ostendo/OSTENDO211-DEMODatabase.zip