Phantom Error

sumeet · Post by **sumeet** » Tue Mar 21, 2006 6:00 pm

Hi,

I have already searched around but couldnt get clue.

There is a job which has been running for last six months but in this month end load. It came up with couple of unique constraint errors.

Then gave this:

Trans_03.insert_in: DSP.Close Error -100 in $DSP.Close.

Any ideas are qwelcome .

And what does this error exactly means

Code: Select all

DSP.Close Error -100 in $DSP.Close.

Thanks
Sumeet

rasi · Post by **rasi** » Tue Mar 21, 2006 6:07 pm

Sumeet

first investigate why you got this unique constraint error now. Check the source data and see whether any duplicates are coming. Check your job to see whether you have logic to eliminate duplicate records.

Thanks