PROBLEM DESCRIPTION


Exception while performing Ingestion with Infoworks ADE:


[INFO] 2018-10-22 21:19:19,081 [pool-6-thread-1] infoworks.discovery.incremental.LogMinerThread:257 :: Creating Index:CREATE INDEX "HDPBATCH".IWINDEX_temp_1 ON "HDPBATCH".LOG_7976460f9ebce4ad678a0cea_1(query_order,seg_owner, table_name,scn,split_column)[INFO] 2018-10-22 21:19:19,081 [pool-6-thread-1] infoworks.tools.utils.IWUtil:2014 :: executing query CREATE INDEX "HDPBATCH".IWINDEX_temp_1 ON "HDPBATCH".LOG_7976460f9ebce4ad678a0cea_1(query_order,seg_owner, table_name,scn,split_column)[INFO] 2018-10-22 21:19:19,092 [pool-6-thread-1] infoworks.discovery.incremental.LogMinerThread:327 :: SQLEXception error code : 955[INFO] 2018-10-22 21:19:19,093 [pool-6-thread-1] infoworks.discovery.incremental.LogMinerThread:328 :: EXception error message : ORA-00955: name is already used by an existing object [ERROR] 2018-10-22 21:19:19,218 [main] infoworks.discovery.incremental.LogBasedCDCUtil:225 :: infoworks.tools.ExceptionHandling.IWException: Error while getting status from temp table creation


POTENTIAL CAUSE


This issue might occur if ingestion jobs from multiple sources running at the same time are trying to create indexes with the same name on the temp table at the same time.


SOLUTION/ WORKAROUND


I request you to perform below mentioned steps:


Set the below configuration at the Source > Advanced Configuration level so that the indexes will be prefixed with the value that you provide. The value that you provide will be added as a prefix to index name.


key: temp_table_index_name_one       

Value: <Provide the source name or anything that differentiates the indexes created for one source with the other>.


Once you do this the new index name will be prefixed with the name you provided as value in key-value pair and the discrepancy in index names will be resolved.


AFFECTED VERSIONS


Versions released after Infoworks ADE v2.5.3