Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# Using the Case Data Normalization Utility

The Case Data Normalization Utility allows you to normalize existing case data; either system-wide or on a per-procedure basis. For example, you may have disabled case data during an upgrade because of the large amount of case data involved. After the upgrade, you can use the Case Data Normalization Utility to convert the case data during off-peak hours.

Note: You can also disable or enable case data normalization on a per-procedure basis with the "Normalise Case Data" check box on the Status tab of the Procedure Properties dialog box.

Before using the Case Data Normalization Utility, ensure that the global process attribute NORMALISE_CASE_DATA is set to 1, using the `swadm` utility if necessary (see Using SWDIR\util\swadm to Administer Process Attributes). This enables case data normalization and allows you to use the Case Data Normalization Utility.

The Case Data Normalization Utility is located in the following directory:

    SWDIR\util

The command you enter to use the utility has the following format:

`swnormcd [/U] [/T` `nnn``] /``A` `|` `procedure_list` `|` `/``F` `control_file`

where:

| • | `/U` indicates that you want to disable case data normalization. Note that disabling case data normalization does not delete the data held in the `field_value_N` column in the `case_data` table. New cases of procedures will not use case data normalization and if you are using TIBCO iProcess Objects, new cases will not appear in case data searches.

| • | `/T` `nnn` specifies the number (nnn) of concurrent threads for case data normalization. The default is `10`. Use this parameter to improve performance when normalizing large amounts of data.

| • | `/A` indicates that existing case data should be normalized for all procedures. The `normalise_data` column on the `proc_index` table is set to `1` and new cases of procedures are normalized.

Warning: Normalizing large amounts of case data can take a significant amount of time.

| • | `procedure_list` is either the name of a procedure or a list of procedures separated by white space.

| • | `/``F control_file` specifies the name of a file that contains procedure names separated by white space.

## Examples

This command disables case data normalization for the hiring procedure. Any new cases of this procedure will not use case data normalization and will not appear in searches using TIBCO iProcess Objects.

    swnormcd /U hiring

This command enables case data normalization for all procedures and normalizes existing case data.

    swnormcd /A

This command enables case data normalization for the procedures listed in the file `proclist.txt` and converts any existing case data.

    swnormcd /F proclist.txt

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.