Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# Removing All User-defined Constraints (or Triggers), Indexes, and Statistics from the iProcess Engine Schema Tables

## Status

If you are... | This task is...
Installing a new iProcess Engine Version 11.8.0 | N/A
Upgrading from an iProcess Engine Version 11.0 or later | Possibly required

## Database

Oracle, DB2

## Description

For an existing iProcess Engine, you have created constraints (or triggers), indexes, and statistics in the iProcess Engine schema tables. As part of an upgrade, the installer needs to modify certain columns in the iProcess Engine schema tables, then recreate constraints (or triggers), indexes, and statistics after the necessary columns have been changed in the upgrade process.

To successfully upgrade an existing iProcess Engine, you need to remove any user-defined constraints (or triggers), indexes, and statistics from the iProcess Engine schema tables manually before running the upgrade installer, because the installer cannot automatically remove them, you need to remove during the upgrade.

## Procedure

Using an appropriate SQL utility, remove all user-defined constraints (or triggers), indexes, or statistics that you have added to iProcess Engine schema tables.

You can manually recreate them after completing the upgrade. See Recreating All User-defined Constraints (Or Triggers), Indexes, and Statistics on the iProcess Engine Schema Tables for more information.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.