Upload Replication Task stuck in "ca_link_dis_hw_user" table in Oracle database

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

The Upload Replication Task is hanging on "ca_link_dis_hw_user" table:

Environment

Client Automation - All Version

Oracle database

Resolution

Reviewing Engine logs, the following error can be seen:

|ERROR  | cReplicationJob::DoTableUpdateInsertRow failed to execture db command pointer
290523-13:24:30.1220802L|005840|000016d4|Replicatio|amLog           |                    |000000|ERROR  | GetActionOnError: Oracle dbErrCat=-22, dbDetailedError=-1, errorInfo=ORA-01653: unable to extend table MDBADMIN.CA_LINK_OBJECT_OWNER by 128 in tablespace MDB_DATA
ORA-06512: at "MDBADMIN.OLS_SP_SETOBJECTOWNER", line 28
ORA-06512: at "MDBADMIN.PROC_I_NEW_SO_OBJECT", line 27
ORA-06512: at "MDBADMIN.RULE_I_NEW_SO_COMPUTER_USER", line 2
ORA-04088: error during execution of trigger 'MDBADMIN.RULE_I_NEW_SO_COMPUTER_USER'

|ERROR  | SetIntermediateStatus1: Upload: Connection to Enterprise Database lost - Job aborted

|ERROR  | SetIntermediateStatus1: Upload: Replication failed during updating stage

|ERROR  | DoTableUpdate - Chunk processed failed - tablename=ca_link_dis_hw_user, count=3, inserted=1, failed=1
|ERROR  | SetIntermediateStatus1: Upload: A database error was encountered

This is a database issue that the DBA needs to solve on his side (ORA-01653). As guidance, this link explains more details about how to increase the size of the tablespace of the involved database:

http://www.dba-oracle.com/t_ora_01653_unable_to_extend_table_string_string_by_string_in_tablespace_string.htm