Home » Server Options » Replication » ORA-02291: integrity constrain voilated (Oracle Golden Gate,11.1.0,Linux)
ORA-02291: integrity constrain voilated [message #620672] Tue, 05 August 2014 03:58 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21439
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.
Re: ORA-02291: integrity constrain voilated [message #620793 is a reply to message #620680] Wed, 06 August 2014 04:10 Go to previous messageGo to next message
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.
Re: ORA-02291: integrity constrain voilated [message #620799 is a reply to message #620793] Wed, 06 August 2014 04:23 Go to previous messageGo to next message
Littlefoot
Messages: 21439
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).
Re: ORA-02291: integrity constrain voilated [message #634742 is a reply to message #620799] Sat, 14 March 2015 08:15 Go to previous messageGo to next message
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
Re: ORA-02291: integrity constrain voilated [message #634758 is a reply to message #634742] Sun, 15 March 2015 01:48 Go to previous message
Littlefoot
Messages: 21439
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.
Previous Topic: BLOB replication
Next Topic: Oracle golden gate 12.1.2.1
Goto Forum:
  


Current Time: Sat Oct 20 00:11:29 CDT 2018