DSXchange

Hi,

Can someone help me in explaining what this following warning stands for

LoadROLine..OcROLine.SLROLineInsert: DSP.Close Error -2 in $DSP.Close.

My job also throwing n number of constraint key violations while trying to insert to oracle table. Is the above warning some way realted to this.

It could be related with your Ora stage or constraint key violations (but it shouldn't), because the DSP.Close is the routine in a plug-in that is called to close it and the ORA plugin seems to be closed by this routine. Did you try recreating the stage?

I'm not sure what "Error -2" means, maybe you should contact your support provider.

Dude,

I Agree with Author ml,

Once i have seen this warning "DSP.Close Error -2 in $DSP.Close".

1. There was a case of ORA-0001: unique constraint ( Schema.table) violated

2. I found that there is a lock on table (i.e problem with OCI stage). I was looking from a table and trying to update the same table.

finally, solution could be array size and transaction size to minimum number(1).

Cheers,