Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1167
  • Last Modified:

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

unable to update table using procedure on sql server side.
0
Smruti1
Asked:
Smruti1
  • 4
  • 2
1 Solution
 
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
 
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

 
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
 
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
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now