DSXchange

I am getting the following database error . It is a simple auto generated sql query for upset. This job has been succesfully running before but has been failing from last week onwards. Is there any perticular reason this might happen to an existing job???

My other concern is for some reason I dought that the orchestrate values are not being passed to the Oracle stage, if this is true is there any solution to this problem.

Oracle_Enterprise_81,1: Array execute failed for insert:
insert is: INSERT
INTO
FILE_VENUE
(FILE_CONTROL_ID, TIME_ID, VENUE_ID, STATUS_CD, RECORD_CNT)
VALUES
( :FILE_CONTROL_ID, :TIME_ID, :VENUE_ID, :STATUS_CD, :RECORD_CNT)
sqlcode is: -2291
esql complaint: ORA-02291: integrity constraint (USA.FK_FILE_VENUE_FILE_CONTROL) violated - parent key not found

ORA-02291 error relates to RI. A foreign key doesn'nt exist for the natural key that you are trying to add. Its not a datastage error but a database error and rightfully so. The database as active RI and hence not allowing you to insert the value.

Insert the data in the table where the primary key (Parent table) first and later try this job.

This job is working fine with the datastage version- 7.5.1X and is not working in the 7.5.1A version of datastage, both these versions are using the same database. I have checked the parent table and the key column exists in the parent table.

The error obtained is seems to be not much relevent to versions. Still try to insert the same set of records from command prompt (direct load).

Yes we did that and working fine.