Information Store processing after you upgrade i2 Analyze

After you upgrade a deployment of some versions of i2® Analyze with an Information Store, extra processing of the data in the Information Store takes place. Analysts can continue to use the system during while the data is processed.

Upgrade processes

There are a number of different processes that can occur after you upgrade i2 Analyze. The processes that are started depend on the version that you are upgrading to or from. Each process places some restrictions on the system before they are completed.

The following processes are completed the first time that you upgrade a deployment with a SQL Server database to version 4.3.4 or later:
  • Update multi-line property columns data type from CLOB to VARCHAR
    • Blocks analysts from uploading to the Information Store
    • Blocks ingestion and deletion
The following processes are completed the first time that you upgrade to version 4.3.1 or later:
  • Update record identifiers for uploaded records
    • Blocks deletion-by-rule operations
    • Blocks analysts from uploading to the Information Store
  • Update record identifiers for ETL records
    • Blocks deletion-by-rule operations
    • Blocks analysts from uploading to the Information Store
The following processes are completed the first time that you upgrade to version 4.2.0 or later:
  • Update link end provenance
    • Blocks ingestion and deletion
  • Delete link provenance that has missing link ends
    • Blocks ingestion and deletion

Status and progress reports

The IS_Public.Upgrade_Status view in the Information Store database shows the list of processes that are complete and pending:
description status start_time end_time
Update record identifiers for uploaded records Complete 2019-08-13 15:27:06.76 2019-08-13 15:30:03.24
Update record identifiers for ETL records Pending 2019-08-13 15:30:04.49
Additionally, the IS_Public.Upgrade_Progress view shows the progress of each process by item type:
description schema_type_id display_name status start_time end_time
Update record identifiers for uploaded records ET5 Person Pending 2019-08-15 22:24:36.72
Update record identifiers for uploaded records ET1 Address Pending
Update record identifiers for ETL records ET5 Person Pending
Update record identifiers for ETL records ET1 Address Pending
You can use this view to check how many item types are completed and how many are pending. The IS_Public.Upgrade_Progress view is populated with the item type status only when the process is in the Pending state in the IS_Public.Upgrade_Status view.
The possible values for the status columns are:
Pending
The process is either not started or started but not completed.

If an online upgrade task fails, it will remain in the Pending state. If you notice a task in the Pending state for an extended period of time, check the messages.log file for any messages or stack traces related to online upgrade. If there are no messages, then it is likely that the process is not started or started but not complete yet. If there are messages, resolve the issues and restart the Liberty server.

Complete
The process is completed.
Note: If you stop i2 Analyze before all the processes are complete, the next time that you start i2 Analyze any pending processes continue.