Forum Stats

  • 3,815,780 Users
  • 2,259,079 Discussions
  • 7,893,227 Comments

Discussions

Categories

Data Rule Validation Error VLD-0202

661455
661455 Member Posts: 25
edited Oct 24, 2008 11:00AM in Warehouse Builder
Hi all:
I have 5 tables with rules on my data profile. I have many FK
CUENTA FK IMPUESTO
CUENTA FK EXENTO
CUENTA FK CONTRATO
IMPUESTO FK TIPO_IMPUESTO
When create data correction in step 4 (Data Rule Validation), show error:
VLD-0202: duplicate foreign keys detected bettween FK_64 and FK71
VLD-0202: duplicate foreign keys detected bettween FK_65 and FK72
VLD-0202: duplicate foreign keys detected bettween FK_66 and FK73
But I dont have any FK whit this name, because I rename the FK with another name more representative of the word.
How do FK corresponds to that error?
I delete all FK of the profile and went back to generate data correction, but the error continue...
Thanks for your help!
Tagged:
· Share on TwitterShare on Facebook

Best Answer

Answers

  • 558993
    558993 Member Posts: 625
    u might have changed it at the database level but did u re-import the table into OWB?????that may be ur problem...

    Regards
    Bharath
    558993
    · Share on TwitterShare on Facebook
  • 661455
    661455 Member Posts: 25
    I only add CONTRATO table and add rules re-create the data correction again.
    How can I do to update the fields changed from a table of the database?
    · Share on TwitterShare on Facebook
  • Darthvader-647181
    Darthvader-647181 Member Posts: 960
    Answer ✓
    can you not re-import the table?
    · Share on TwitterShare on Facebook
  • 661455
    661455 Member Posts: 25
    edited Oct 24, 2008 10:41AM
    I can re-import the table. I had re-create all rules on the profile and the problem was solved.
    Anyway I would like to know how you could have resolved the problem without having to reload the table in the profile and load each of the rules ... as they were quite ....
    Thank you

    Edited by: user6367764 on 24/10/2008 07:37

    Edited by: user6367764 on 24/10/2008 07:39
    · Share on TwitterShare on Facebook
  • Darthvader-647181
    Darthvader-647181 Member Posts: 960
    edited Oct 24, 2008 11:00AM
    user6367764 wrote:


    I can re-import the table. I had re-create all rules on the profile and the problem was solved.

    Anyway I would like to know how you could have resolved the problem without having to reload the table in the profile and load each of the rules ... as they were quite ....

    Thank you



    Edited by: user6367764 on 24/10/2008 07:37



    Edited by: user6367764 on 24/10/2008 07:39







    The only other way would have been by using OMB scripts.



    [http://www.comp.dit.ie/btierney/Oracle11gDoc/owb.111/b31279/omb_2others.htm#insertedID60]



    Anyways i am glad that your problem ahs been resolved. :)
    Edited by: Darthvader-647181 on Oct 24, 2008 7:59 AM
    · Share on TwitterShare on Facebook
This discussion has been closed.