Parent child relationship in DTS stage.

[vik1979]

Hello All,

I have a scenario where I need to maintain parent child relationship through DTS stage.

Link 1: TABLE A (KEYA1,..)
Link 2: TABLE B (KEYB1,..)
Link 3: TABLE C(KEYC1,KEYA1,KEYB1,..)

I have generated the KEYA1,KEYB1 using SCD stages before DTS stage. But when I am loading them into DTS I am getting below error.

Error message: ORA-02291: integrity constraint (XXX) violated - parent key not found.

Distributed_Transaction_522,0: [Input link 3] The connector is not able to resume the write operation because multiple arrays of data were written to the database on one or more input links under the transaction that was active at the time of failover.

I am hashing, sorting on key columns before sending it to DTS and also DTS stage is running sequentially.

Could you please help me resolve this error.

Thanks.

[vik1979]

I am still looking for a solution, did anyone face this issue?