DRS Error

ramudwhelp · Post by **ramudwhelp** » Wed Jul 08, 2009 3:07 am

Hi ,

We are getting the following error while loading the data into DB2 table using DRS stage.In the same project other jobs are running fine only few jobs are throwing the following error.

Error messages:
DSP.Open GCI $DSP.Open error -100.

Additional Info:
1. DB connection is good.
2. I have renamed the link
3. create copy of job and run the copy job
4 export and reimport the job
We did all the thing tough its not worked....

If i remove the link and create the new link and map the columns to target stage then its working. But i feel there should be better way.

Can any body have an idea...

Thanks in advance.

chulett · Post by **chulett** » Wed Jul 08, 2009 6:32 am

When the job aborts and you Reset it, do you get a 'From previous run...' message generated into the log? If so, post it.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Jul 08, 2009 7:07 am

Have you provided any default connection details in the stage ?

ramudwhelp · Post by **ramudwhelp** » Thu Jul 09, 2009 12:10 am

Hi Sainath,

We are not providing any default values...

ramudwhelp · Post by **ramudwhelp** » Thu Jul 09, 2009 12:12 am

Chulett- every time we are recompiling...same error is incurring in all the runs

chulett · Post by **chulett** » Thu Jul 09, 2009 5:27 am

Well then, stop recompiling and Reset the dang job instead. Also post whatever other errors you see with that one, it by itself is fairly meaningless.