Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI, restoring version in Test Repository - Missing Reference

632157Jun 5 2009 — edited Jun 5 2009
Hi all,

In my Development repository I removed a column from a table, to do that I was forced to remove any mapping to that column in my interfaces. After that I created a new version of my Models and Project folder. I restore the newest version (Model and Project) into my Test Repository and I saw that the Interfaces that use the table I have changed had the exclamation mark, this means that I have missing references. The problem is that I don't have the column on the source/target tables in any of them and in the table neither.

It's weird, I went to see the ODI Work Rep metadata and saw that in the SNP_OBJ_TRACE my table is listed with the tag "Excluded Table" in ERR_MESS column. I saw the SNP_MISSING_REF and the field that I removed from the table are listed there.

But after that, I ran the Interface's Scenario and it's all ok!

Anyone knows why this happens?

Thank you,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2009
Added on Jun 5 2009
9 comments
997 views