Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# Enable Case Data Normalization

Configuration Options Menu

## Description

To determine whether case data normalization is enabled.

## Database

Oracle, DB2

## Value

Installation Type | New Installation | Upgrade Installation
Value | `Y`, if case data normalization is enabled. `N`, if case data normalization is disabled. | The current setting, as defined by the value of the `NORMALISE_CASE_DATA` process attribute. If this setting is `Y`, you cannot change it. If it is `N`, you can change it to `Y` if you want.
Default Value | `Y`

## Notes

Case data normalization is a feature used to make case data searching more efficient, and therefore faster. It uses the `field_value_N` column in the `case_data` table in the iProcess Engine database. This column provides a normalized value of the value in the `field_value` column, allowing the database to do simple string comparisons, instead of having to do type conversions.

Warning | If you intend to use iProcess Objects to perform case data searches, TIBCO strongly recommends that you enable case data normalization. If you do not do this, you will be able to view and start procedures, but you will not be able to view the cases until you normalize the data. You can either enable case data normalization as part of the installation, or upgrade process by setting this menu item. Or, you can do so afterwards by using the `Case Data Normalization Utility`. See the "Administering Case Data Normalization" section in TIBCO iProcess Engine Administrator's Guid e for more information about this utility.

For the Oracle database, if you are upgrading, note that creating the data for the `field_value_N` column can significantly increase the time taken to perform the upgrade if the system has a large number of cases. See How Long Will an Upgrade Take for more information.

For the DB2 database, if you are upgrading, before choosing to enable case data normalization, note that the installer will need to populate the `field_value_N` column for every row in the `case_data` table, using the values from the `field_value` column. This can significantly impact the duration of the upgrade process if there are large numbers of cases on the system. See How Long Will an Upgrade Take for more information.

## Control File Keyword

IPEF_ENABLECDN

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-2025. Cloud Software Group, Inc. All Rights Reserved.