DSP.Close Error

[ryoung011]

DSP.Close Error -100 in $DSP.Close

Any ideas on this error message?

Server job that writes to an OCI 9i stage. Array size is 50, commit interval is 10,000.

The other interesting thing to note is that each input record is assigned a unique/primary key value (surrogate key) using @INROWNUM. This is an initial load of a Type 2 SCD, so we're just using @INROWNUM. What is strange is that the last record is failing on unique key constraint violation. It seems as though the Job is assigning the same number to the last row as the previous.

Any suggestions?

Thanks,

Rick

[davidnemirovsky]

If you are not fussed about sequential surrogate keys try using @OUTROWNUM.

If you are fussed about sequential surrogate keys just store the MAX_ID in a hashed file for each table and then use @INROWNUM/@OUTROWNUM to add to the MAX_ID.