'ODI-20161: Standard reverse-engineering failed... already exist' Signaled when Standard Reverse Engineering Fails in ODI 11.1.1.5 when Datastores Include Underscores in the Name of the Table
(Doc ID 1382802.1)
Last updated on JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 11.1.1.5.0 to 11.1.1.5.0 [Release 11gR1]Information in this document applies to any platform.
Symptoms
When attempting to reverse engineer a group of Datastores within the same Model with table names that differ only by one specific character - an underscore "_", the Standard Reverse - Selective Reverse fails with following message :
ODI-20161: Standard reverse-engineering failed.
com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Reverse table TEST_DESCRIPTIONS for model MODEL_NAME already exists.
com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Reverse table TEST_DESCRIPTIONS for model MODEL_NAME already exists.
As an example the group of Datastores could have the following names:
TEST_DESCRIPTIONS
TEST_DESCRIPTION_
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |