OraFAQ Forum: Replication » ORA-02291: integrity constrain voilated

Home » Server Options » Replication » ORA-02291: integrity constrain voilated (Oracle Golden Gate,11.1.0,Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-02291: integrity constrain voilated [message #620672]

Tue, 05 August 2014 03:58

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

hi,

i am facing below error in golden gate replication i have drop the table from replicated database and refresh
the table but same error again. In target db all the constraints are enabled cant understand why constraint
is violated in replicated database?

[Code]

OGG-00869 OCI Error ORA-02291: integrity constrain
t (ETIS.FK_ABP_BILLINGPERIODID_LOG) violated - parent key not found
Database error 2291 (OCI Error ORA-02291: i
ntegrity constraint (ETIS_ABP_BILLINGPERIODID_LOG) violated - parent
key not found (status = 2291), SQL <INSERT INTO "ETIS"."SM_TBLACCOUNTBIL
LINGPERIODLOG" ("ABP_BILLINGPERIODID","BPS_OLDSTATEID","BPS_NEWSTATEID","ABP_LOG
DATE","AC_ACCOUNTNO") VALUES (:a0,:a1,:a2,:a3,:a4)>).

[Code]

[Updated on: Tue, 05 August 2014 03:59]

Report message to a moderator

Re: ORA-02291: integrity constrain voilated [message #620680 is a reply to message #620672]

Tue, 05 August 2014 05:57

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Because, as the error says, parent key is not found. You are trying to insert a record into a detail table, but foreign key constraint was violated as parent key doesn't exist. Compare parent tables in both databases.

Report message to a moderator

Re: ORA-02291: integrity constrain voilated [message #620793 is a reply to message #620680]

Wed, 06 August 2014 04:10

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

Thanks for the reply issue solved.

Also can u send me any training material regarding oracle golden gate exam.

Thanks.

Report message to a moderator

Re: ORA-02291: integrity constrain voilated [message #620799 is a reply to message #620793]

Wed, 06 August 2014 04:23

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't have any training material. Please, post that question in our Training & Certification forum (scroll down to the bottom of the forum's list).

Report message to a moderator

Re: ORA-02291: integrity constrain voilated [message #634742 is a reply to message #620799]

Sat, 14 March 2015 08:15

thomosgee1
Messages: 1
Registered: March 2015

Junior Member

copied the generated keys to text file and saved the file as ENCKEYS in the same directory i.e. goldengate installation directory
(In my first attempt I did not gave extension to file)GSCI (win-srv001) 2> dblogin sourcedb testdsn, userid gg_admin, password gg_admin
2014-08-01 12:23:29 INFO OGG-03036 Database character set identified as windows-1252. Locale: en_US.2014-08-01 12:23:29 INFO OGG-03037 Session character set identified as windows-1252.

_______________________________
seew

Report message to a moderator

Re: ORA-02291: integrity constrain voilated [message #634758 is a reply to message #634742]

Sun, 15 March 2015 01:48

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How is this message related to the question posted by the original poster?

Is your message actually a question? Doesn't look like one (as there's no question mark anywhere in this message).

So, what is the purpose of posting it? If you really have a problem (which is different from ORA-02291), moderators can split your message from this discussion and put it into a separate topic - just say so.

Report message to a moderator

Previous Topic:	BLOB replication
Next Topic:	Oracle golden gate 12.1.2.1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 02:55:53 CST 2024