DSTAGE-DRS-0123`:`Row Rejected

[prabudsx]

Hi,
I am using DRS stage for target Oracle database.
When im trying to insert data, getting the below error.
No constraints has been set.
Please assist.

DSTAGE-DRS-0123`:`Row Rejected

Thanks,
Prabu

[vinothkumar]

Add a reject link to Oracle stage and try to get the reason code. See if you can find anything from that.

[prabudsx]

We received the issue in Production region. In Development im getting the right result.
Please advise any significant for the error code.DRS-0123.

Thanks

[chulett]

Post the actual, unedited error from your job's log. There should be an Oracle in there somewhere as well, me thinks...

[prabudsx]

Post the actual, unedited error from your job's log. There should be an Oracle in there somewhere as well, me thinks...

Please find the log below... I am clueless

Item #: 109
Event ID: 2009
Timestamp: 2011-03-14 10:52:49
Type: Info
User Name: dsdsx
Message Id: DSTAGE-DRS-0105
Message: E0302_PXR..Trgt_PXR: INSERT INTO IMS.IM_PXR(CODE, IT_DATE, AMT, SEQ_NO, ST_DATE, TR, SW, CONF_REF, CUR, UNIT_AMT, NO_UNITS, AMT, STATUS, CDATE, ID) VALUES(TRANSLATE(:1 USING NCHAR_CS), TO_DATE(:2, 'YYYY-MM-DD HH24:MI:SS'), :3, :4, TO_DATE(:5, 'YYYY-MM-DD HH24:MI:SS'), :6, :7, :8, :9, :10, :11, :12, :13, TO_DATE(:14, 'YYYY-MM-DD HH24:MI:SS'), TRANSLATE(:15 USING NCHAR_CS))

Item #: 110
Event ID: 2010
Timestamp: 2011-03-14 10:52:50
Type: Warning
User Name: dsdsx
Message Id: -2
Message: E0302_IFast_To_IM_PXR..X_IM_PXR: At row 2, link "Lnk_Tgt_IM_PXR"
DSTAGE-DRS-0123`:`Row Rejected
Item #: 111
Event ID: 2011
Timestamp: 2011-03-14 10:52:50
Type: Info
User Name: dsdsx
Message Id: DSTAGE_RUN_I_0173 Message: E0302_IFast_To_IM_PXR..X_IM_PXR: Stage statistics
2 rows read from Lnk_X_IM_PXR
2 rows read from LnkTrgt1
2 rows read from Lnk_Lkp_H_IM_PXR
2 rows written to Lnk_RecordControlTrgt
1 rows written to Lnk_Tgt_IM_PXR
0.080 CPU seconds used, 1.000 seconds elapsed.