DSP.Close Error
Posted: Wed Jan 05, 2005 1:22 pm
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
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