ORA-02291 Error in Oracle conector stage

Pravenai · Post by **Pravenai** » Tue Apr 30, 2013 4:17 am

Hi,

I am using an Oracle Connector stage to insert data in target table (datastage version 8.1). This table has a foreign key constraint on a parent table on State column. However this State column is a nullable column in my child table and I can see many records with Null values in State column in my child table.

The problem is when my job tries to insert a record in child table with Null value in State column this record is getting rejected with ORA-02291 error.

How can I insert records with Null value in State column via datastage jobs without this record getting rejected?

Thanks in advance.

Regards,
Praveen

ray.wurlod · Post by **ray.wurlod** » Tue Apr 30, 2013 5:44 am

What exactly does this error code mean?

Solve that, and you will solve your problem - don't do what is causing the error.

chulett · Post by **chulett** » Tue Apr 30, 2013 6:37 am

As expected, it's a referential integrity constraint violation. I'd double-check that you are in fact sending a NULL in the column in question.

kwwilliams · Post by **kwwilliams** » Tue Apr 30, 2013 10:08 am

Does the parent table allow null in the state column? If it does not allow null then you should not be attempting to insert a null into the child table else if allows a null and there is null present in the state table then you should not be getting this error.