data_engine maintenance on Oracle may fail after 8.2 upgrade with ORA-20005 error in data_engine logs
Article ID: 34392
DX Infrastructure ManagementNIMSOFT PROBES
fter upgrading from any previous UIM version to UIM 8.2 where an Oracle backend is in use, some users may find that data_engine's overnight maintenance process is not completing, and old data is not being deleted and/or indexes are not being rebuilt.
The errors seen in the data_engine log will be similar to the following:
 de: Data Maintenance - RC: -1000 [ORA-20008: spn_de_DataMaint_DeleteOldData: Error: -20005 ORA-20005: spn_de_CreateBNTableIndex: Error: -1408 ORA-01408: such column list already indexed], Purge ? : RN_QOS_DATA_0021, Error , Raw Rows: ? ? ? ? ?0, Time used: ? ?204 ms ~= (0 seconds) (QOS_ORACLE_CHECK_DBALIVE)
To resolve this problem, deactivate data_engine and then run the following two Oracle scripts, which will rename the indexes causing this problem and allow maintenance to proceed.