Pre-upgrade to 10.2604.2

Attention: If you are upgrading from an earlier version to a higher or the latest version, ensure that you complete the pre-upgrade steps for each intermediate release that are listed on the Pre-upgrade tasks page. If a version is not listed on the page, it means there are no pre-upgrade steps required for that release.

Delete the Optimizer Elasticsearch indexes before upgrading to the new Optimizer version.

About this task

The following procedure applies only if the Optimizer service is enabled in your Sterling Intelligent Promising deployment. As part of database restructuring to improve performance, it is highly recommended to delete the Elasticsearch indexes listed in the following procedure. If you are unable to delete these indexes and need to retain the data, contact the support team for assistance with migrating the data before proceeding with the upgrade.

Important: Ensure that you take the necessary backup of your Elasticsearch data before deleting any indexes.

Procedure

Retrieve all Optimizer indexes and their aliases by calling the following API.
```
GET /_cat/aliases/otmz-*?h=alias,index,is_write_index&format=json
```
This API returns all Optimizer aliases, their corresponding index names, and whether the index is the write index, in JSON format.
Exclude the following aliases from the deletion process. Do not delete any indexes associated with these aliases.
```
otmz-promise-order
otmz-promise-shipment
otmz-appstat-info
```
Delete the remaining indexes that are not associated with the aliases that are listed in Step 2. Use the index names obtained from Step 1 and run the following API for each index to be deleted.
Replace <index_name> with the actual index name returned by the API.
```
DELETE /<index_name>
```