ORA-02291

pukars4u · Post by **pukars4u** » Mon Feb 06, 2006 2:51 pm

Hello, I am getting the below error

ORA-02291: integrity constraint (SFADM.STG2_R_127_FK) violated - parent key not found

what should i check the data type matching or any other

guide me through

sudheer05 · Post by **sudheer05** » Mon Feb 06, 2006 3:51 pm

That is not the datatype issue.
Some where you are missing the parent child relation.
Check for the constraints in the database.
A foreign key value has no matching primary key value.

jzparad · Post by **jzparad** » Mon Feb 06, 2006 3:54 pm

This is an error from the database which basically means that you are trying to insert a record that has no matching parent record.

Example
Trying to insert an order record where the customer ID does not exist in the customer table.

Code: Select all

ORA-02291 integrity constraint (string.string) violated - parent key not found

Cause: A foreign key value has no matching primary key value.

Action: Delete the foreign key or add a matching primary key.

ak77 · Post by **ak77** » Mon Feb 06, 2006 6:08 pm

Are you trying to insert or delete?
Anyways its a database error
The ones who have replied before have given you what might be the cause.
But you have not explained clearly. Just giving the error is not enough
You can get info if you do a google search

If you are deleting a record that is linked to another parent table, then it will not allow the delete. I believe you get the same error in this case also

Kishan

jzparad · Post by **jzparad** » Mon Feb 06, 2006 7:02 pm

If you were trying to delete or update, you would receive a ORA-02292 (child record found) error.

And as I said (fairly clearly I thought) ...

This is an error from the database which basically means that you are trying to insert a record that has no matching parent record.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 06, 2006 7:15 pm

On the server, at the operating system prompt, type this command.

Code: Select all

oerr ORA 02291

This will (a) prove to you that it's an Oracle error (not a DataStage error), (b) suggest what you can do about it.
Then you can modify your job design so that you do not violate a foreign key constraint - maybe by loading the dimension table ahead of the fact table.

pukars4u · Post by **pukars4u** » Thu Feb 09, 2006 3:01 pm

Thanks guys my problem is solved its not a datatype error its really is parent-child relation error

ray.wurlod · Post by **ray.wurlod** » Thu Feb 09, 2006 9:41 pm

Correct. You read this in the original error message.

Code: Select all

ORA-02291: integrity constraint (SFADM.STG2_R_127_FK) violated - parent key not found