sql server error 515,7215 ora error -02089,02291

unable to update table using procedure on sql server side.
Smruti1Asked:
Who is Participating?
 
Smruti1Author Commented:
Thanks to all,
we found that there was some data provider issue --> we need to use microsoft provider instead of oracle provider so changing provider resolved this issue.
Thanks to every body for help.
0
 
Smruti1Author Commented:
Our configuration Updates table on SQL server while pulling data from Oracle. It used to work before but it stopped  accessing data from oracle and updates tables in SQL Server.
0
 
johnsoneSenior Oracle DBACommented:
ORA-02291 is a constraint violation.  It would most likely mean you have a child with no parent.  The full text of the error message should give you more information.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Smruti1Author Commented:
Thanks johnsone.

Here is the full text message--

Oracle error 'ORA-02291: integrity constraint (DM.FK_ADDR_2_ADDR_GRP) violated - parent key not found ' [ ORA-06512: at "COM.COM_OFFICE_PKG", line 365 ORA-06512: at "COM.COM_OFFICE_PKG", line 322  ]{ ----- PL/SQL Call Stack -----   object      line  object   handle    number  name 0x1eea5d520       332  package body COM.COM_OFFICE_PKG 0x1f25988a0         1  anonymous block } , SQL Message = 'Could not execute statement on remote server 'DMLINK'.'
0
 
johnsoneSenior Oracle DBACommented:
Based solely on the constraint names, my guess is that you have an ADDRESS table and an ADDRESS_GROUP table.  You are missing the group record for the address.  That is what the message is telling you.

This would tell you the constraint that the table is on:

select owner, table_name from dba_constraints where constraint_name = 'FK_ADDR_2_ADDR_GRP' and owner = 'DM';

This would tell you the table that is referenced:

select owner, table_name from dba_constraints where (owner, constraint_name) = select r_owner, r_constraint_name from dba_constraints where constraint_name = 'FK_ADDR_2_ADDR_GRP' and owner = 'DM');

Once you fix the constraint violation, which I suspect is with the address group table, your procedure should run correctly.
0
 
Smruti1Author Commented:
Thanks to all, I will check it after long weekend and let you all know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.