AutoSys Upgrade Failure: Database Upgrade Error (CAUAJM_E_116408)

Products

• Autosys Workload Automation

Issue/Introduction

AutoSys upgrade failed during the database upgrade phase, resulting in the error "CAUAJM_E_116408: An error occurred while creating or upgrading the <Instance-Name> database."

 

Review the cawa_installer.log file for detailed error messages. The log indicates that the error occurred during an attempt to drop a constraint or index on the ujo_comm_recv_seq table, which is being used by the CDC (Change Data Capture)  feature.

2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - IF exists (SELECT 1 FROM sys.objects WHERE name = 'xpkujo_comm_recv_seq') BEGIN
2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - ALTER TABLE ujo_comm_recv_seq DROP CONSTRAINT xpkujo_comm_recv_seq
2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - END
2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - IF exists (SELECT 1 FROM sys.indexes WHERE name = 'xpkujo_comm_recv_seq') BEGIN
2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - DROP INDEX ujo_comm_recv_seq.xpkujo_comm_recv_seq
2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - END
2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - 
2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - Msg 22979, Level 16, State 1, Server <hostname>.<example>.<com>, Procedure sys.sp_cdc_ddl_event_internal, Line 170
2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - The unique index 'xpkujo_comm_recv_seq' on table '[dbo].[ujo_comm_recv_seq]' is used by Change Data Capture. The constraint using this index cannot be dropped or disabled.
2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - Msg 3609, Level 16, State 2, Server <hostname>.<example>.<com>, Line 2
2025-05-08 09:58:02,962 [Thread-65942] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - The transaction ended in the trigger. The batch has been aborted. 

Environment

AutoSys Workload Automation using SQL Server database

Cause

The error is caused by an attempt to modify any AutoSys table that is being used by the Change Data Capture (CDC) feature on the SQL Server database. The CDC feature prevents the modification of the table, leading to the upgrade failure.

Resolution

1. Restore the database and software back to the original state.
2. Get the DBA to disable the CDC feature on the database front.
3. Then re-run the upgrade again.