Description:
This Late Breaking News (LBN) applies only to systems being upgraded to version 4.0.

To identify if this LBN is applicable to your environment, run the following SQL
against the BPM database:

SELECT COUNT(*) FROM ec_event_trigger;

If the count returned is greater than zero, do the following:

1. Install the TIBCO ActiveMatrix BPM 4.0 software as outlined in the TIBCO ActiveMatrix
   BPM Installation and Configuration guide.

2. When upgrading, run the following SQL, depending on your database.

   IMPORTANT NOTE: You must run the SQL after the "Remote Machine: Upgrading the ActiveMatrix
   Host Instance" step and before you run the "Upgrade TIBCO ActiveMatrix BPM Instance" wizard,
   in the "Primary Machine: Upgrading ActiveMatrix BPM" step. Failing to do so will cause upgrade
   to fail.

Oracle
------
    CREATE TABLE ec_event_trigger_old AS
      SELECT *
      FROM ec_event_trigger;
      
    DELETE FROM ec_event_trigger;

    COMMIT;

Microsoft SQL
-----
    SELECT * INTO [amxbpm].[ec_event_trigger_old] FROM [amxbpm].[ec_event_trigger];
      
    DELETE FROM [amxbpm].[ec_event_trigger];

DB2
---
    CREATE TABLE ec_event_trigger_old LIKE ec_event_trigger;
    INSERT INTO ec_event_trigger_old (SELECT * FROM ec_event_trigger);
    DELETE FROM ec_event_trigger;
    COMMIT;

3. After the SQL scripts execute successfully, extract the attached migration.zip file into
   the <TIBCO_HOME>/bpm/4.0/scripts folder. If asked to overwrite existing files, select Yes.
    
4. Continue with the post-install tasks as outlined in the TIBCO ActiveMatrix
   BPM Installation and Configuration guide.

Upgrade to TIBCO ActiveMatrix BPM version 4.0 fails if rows are present in the ec_event_trigger table

migration.zip