AutoSys WebUI Upgrade Failure from v24.0.00 to later releases produces error CAUAJM_E_112644

Products

• Autosys Workload Automation
• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

When attempting to upgrade from AutoSys WebUI v24.0.00 to a later release (e.g., v24.0.01), installer will throw the following error :

[CAUAJM_E_112644] The indexes for the AutoSys "Web UI" database were created in the default tablespace during the v24.0.00 installation. Update the existing indexes to use the custom index tablespace specified for v24.0.00. For instructions, refer to the known issues section of the v24.0.00 documentation.

Environment

Autosys WebUI v24.0.0 with PostgreSQL database.

Cause

During the fresh installation of AutoSys v24.0.00 with a PostgreSQL database, the indexes were created in the default tablespace instead of the custom index tablespace specified during the installation process. 

Resolution

The indexes need to be updated to use the custom tablespace. This can be done by running the ALTER INDEX command for each of the affected index.

This script will help to move the indexes from the default tablespace to the custom tablespace. 
There are 2 scripts attached, one for Web UI tables and other one for Reporting tables.

Steps:
1. Replace 'wccschema' with your schema name in the scripts.
2. Replace 'wcc_index' with your custom index tablespace where you intend to create the indexes in the script.
3. Connect to Web UI database.
4. Execute the script 'reCreate-wcc-index-PostgreSQL.sql'.
5. Connect to Reporting database.
6. Execute the script 'reCreate-reporting-index-PostgreSQL.sql'.

Once you execute the attached scripts , you can proceed with the upgrade and it should be successful.