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
You can use this view to check how many
item types are completed and how many are pending.
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 |
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.
- 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.