Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# Migrating Old Case Memo data

From TIBCO iProcess Engine 11.5, all the new memo data associated with the memo fields is saved in the `nmemo` and `pack_nmemo` tables and stored in the `BLOB` data type rather than the `LONG RAW` data type.

Note | This is only for SQL Server and Oracle databases.

To migrate old case memo data from the `memo` table to the `nmemo` table and from the `pack_memo` table to the `pack_nmemo` table if upgrading TIBCO iProcess Engine from version 11.4 or earlier, enter the following command:

`swutil MIGRATEMEMOS` `ALL_CASES|LIVE_CASES|``casenumrange``|[commitSize]`

where:

| • | `ALL_CASES` specifies all cases of a procedure.

| • | `LIVE_CASES` specifies all live cases of a procedure.

| • | `casenumrange` specifies a range of case numbers, for example, `case_num1``-``case_num2`.

| • | `commitSize` specifies the size of the batches in which memos will be migrated. The default value is set to 100 (preferred), and the user can specify it, if required.

The following example migrates the old memo data for all the cases:

`swutil MIGRATEMEMOS ALL_CASES`.

Note | You can also migrate old case memo data if upgrading TIBCO iProcess Engine from version prior to 11.5. See "Installing TIBCO iProcess Engine" in TIBCO iProcess Engine Installation for more information

Warning | ## IMPORTANT! While upgrading, migration is not required, as old and new memo data can co-exist. For large volumes of memos, it is recommended to delay migration until a high volume of the old memo cases have been purged. Migration can take a long time, so TIBCO recommends to run a pre-production test run with live volumes to ascertain the expected time.

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.