Products | Versions |
---|---|
TIBCO BPM Enterprise (formerly TIBCO ActiveMatrix BPM) | - |
Not Applicable | - |
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.