81002 - Connection is down (UniData)
Posted: Sat Apr 12, 2008 5:07 am
This one is new to me. We upgraded DS from 6.0 to 7.5.2 on Windows 2000 Server SP4, running all Server jobs. Before the upgrade, all jobs ran fine in 6.0. However, after installing 7.5.2, I'm now having an issue with one job. The source is UniData (Infolease) and the target is Oracle. This job does a select criteria on 20 million rows in a UniData file and grabs around 3 million or so. It appears that when the select is finished and ready to read the rows into DataStage, these error messages appear in the Director log:
ds_udtopen() Unable to execute file SELECT - 81002 - Connection is down
DSD.UDTOpen GCI $DS.UDTOpen error 24
Again, we have over a hundred other Unidata-source jobs and they ran fine after the upgrade. Another factor is that this job takes over an hour to do the select. I have the timeout set to 86000 seconds in Administrator. Thanks in advance.
ds_udtopen() Unable to execute file SELECT - 81002 - Connection is down
DSD.UDTOpen GCI $DS.UDTOpen error 24
Again, we have over a hundred other Unidata-source jobs and they ran fine after the upgrade. Another factor is that this job takes over an hour to do the select. I have the timeout set to 86000 seconds in Administrator. Thanks in advance.