#3281 Wrong Key / FK Combination

closed
nobody
5
2005-12-13
2005-12-12
No

Either the Key in AD_System: AD_System_Key is wrong, or
the forein key created with: Create FK
ADSYSTEM_ADREGISTRATION
<<ERROR: ORA-02270: kein entsprechender Primär- o.
eindeutiger Schlüssel für diese Spaltenliste
- ALTER TABLE AD_REGISTRATION ADD CONSTRAINT
ADSYSTEM_ADREGISTRATION FOREIGN KEY (AD_SYSTEM_ID)
REFERENCES AD_SYSTEM (AD_SYSTEM_ID)>>
Create FK ADSYSTEM_ADREGISTRATION
<<ERROR: ORA-02270: kein entsprechender Primär- o.
eindeutiger Schlüssel für diese Spaltenliste
- ALTER TABLE AD_REGISTRATION ADD CONSTRAINT
ADSYSTEM_ADREGISTRATION FOREIGN KEY (AD_CLIENT_ID)
REFERENCES AD_SYSTEM (AD_CLIENT_ID)>>

in migration is wrong.

Should get corrected, since this makes no sense, as it
tries to create to different keys with the same name on
something which is not existing as a key.

Discussion

  • Jorg Janke

    Jorg Janke - 2005-12-13
    • status: open --> pending
     
  • Jorg Janke

    Jorg Janke - 2005-12-13

    Logged In: YES
    user_id=87038

    *** Status set to PENDING *** If the issue solved, please CLOSE
    this request - otherwise set the status back to OPEN (we only
    check OPEN items). If there is no reaction within a week, the
    system will automatically CLOSE it. To speed up response time,
    you may want to consider a support agreement.
    ***

     
  • Jorg Janke

    Jorg Janke - 2005-12-13

    Logged In: YES
    user_id=87038

    There are a few old "left over's" as the migration does not
    handle primary key changes correctly - See Partner Forum
    for details.
    Apart from that there is only one valid System and one
    valid registation record - all with the ID of 0.

     
  • Yves Sandfort

    Yves Sandfort - 2005-12-13
    • status: pending --> closed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks