The pack_nmemo table stores memo data associated with memo fields in the
pack_data table after upgrading to iProcess Engine 11.6.
You can migrate case memo data in the pack_memo table to the
pack_nmemo table when upgrading to iProcess Engine 11.6 or migrate them by using the
swutil MIGRATEMEMOS command after the upgrades.
When a work item is sent out to a queue, memo data is copied from the nmemo table to the
pack_nmemo table. The client uses the memo data in the
pack_nmemo table to fill out the form correctly. When the form is kept any changed memo data is updated in the
pack_nmemo table. When a work item is released memo data is moved from the
pack_nmemo table to the
nmemo table.
The pack_nmemo table is structured as follows:
TABLE pack_nmemo (
reqid NUMERIC(20) NOT NULL,
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
casenum NUMERIC(20) NOT NULL,
memo_id INTEGER NOT NULL,
memo_index INTEGER NOT NULL,
memo_size INTEGER NOT NULL,
memo_data VARBINARY(MAX)NOT NULL,
array_idx INTEGER NOT NULL)
The pack_nmemo table contains one row for every assigned memo field that contains data (for example, that has a value other than
SW_NA) in every outstanding step on the system.