Recieves 81002 error after new client install

mczern · Post by **mczern** » Thu Mar 30, 2006 10:29 am

Yesterday I have moved to a new laptop, which was recently upgraded from XP Home to XP Pro SP2 and then installed the DataStage 7.51a client.
Now, when I attempt to save or compile a job, I receive an 81002 error (See below).
Some other points to note:
Occurs for any datastage userid used on the laptop.
Occurs on all existing jobs within the project created from other client machines.
Jobs created from scratch on this laptop save and compile correctly. And, can be modified, and saved by other users and then re-opened by me using my laptop again.
I can log into a different project containing previously created jobs and can edit, save and compile with no issues.
So it seems to be an issue between the laptop and 1 specific project.

Uninstalling and re-installing the 7.51a client does not fix the issue.

Below are the errors displayed on Save and Exit from the job:
Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project DWH_DEV
(The connection is broken (81002))

Error calling subroutine: *DataStage*DSR.ADMIN (Action=10); check DataStage is set up correctly in project DWH_DEV
(The connection is broken (81002))

Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project DWH_DEV
(The connection is broken (81002))

Error calling subroutine: *DataStage*DSR.ADMIN (Action=10); check DataStage is set up correctly in project DWH_DEV
(The connection is broken (81002))

Error calling subroutine: *DataStage*DSR.ADMIN (Action=10); check DataStage is set up correctly in project DWH_DEV
(The connection is broken (81002))

Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project DWH_DEV
(The connection is broken (81002))

Error calling subroutine: *DataStage*DSR.ADMIN (Action=10); check DataStage is set up correctly in project DWH_DEV
(The connection is broken (81002))

Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project DWH_DEV
(The connection is broken (81002))

-- when I then close without save I recieve the following:

Error calling subroutine: DSR_JOB (Action=4); check DataStage is set up correctly in project DWH_DEV
(The connection is broken (81002))

DSguru2B · Post by **DSguru2B** » Thu Mar 30, 2006 11:20 am

Does your laptop have a VPN ?
How are you connecting to the Datastage server?

mczern · Post by **mczern** » Thu Mar 30, 2006 12:30 pm

DSguru2B wrote:Does your laptop have a VPN ?
How are you connecting to the Datastage server?

Yes. My laptop has VPN. However, I'm behind the firewall and connecting directly to Project. Hosted on a Linux server.
I can open the jobs fine. But I can not save or compile any existing job.
If I create a new parallel job it works fine.

Thoughts?

ray.wurlod · Post by **ray.wurlod** » Thu Mar 30, 2006 1:52 pm

Do you have the Ascential DataStage XP SP2 patch installed?

mczern · Post by **mczern** » Tue Apr 04, 2006 8:46 am

ray.wurlod wrote:Do you have the Ascential DataStage XP SP2 patch installed?

I have installed a client side patch provided by IBM.
It updates the following dlls:
jobseqpages-<rel>.dll - client patch component (7.5.1)
jobseqframe-<rel>.dll - client support dll
dsguictrls-<rel>.dll - client support dll
dsjsjobgen-<rel>.dll - client support dll
dsdesign-<rel>.exe - client support dll
vmdsedit-<rel>.dll - client support dll
vmdsobj-<rel>.dll - client support dll
vmdsrpos-<rel>.dll - client support dll
vmdstool-<rel>.dll - client support dll

Is there another patch?

Uninstalled. Rebooted. Installed patch. Did not work!
I have installed the patch. Rebooted. Did not work!
Re-registered the dlls above manually. Rebooted. Did not work!

mczern · Post by **mczern** » Tue Apr 04, 2006 11:17 am

mczern wrote:
ray.wurlod wrote:Do you have the Ascential DataStage XP SP2 patch installed?
I have installed a client side patch provided by IBM.
It updates the following dlls:
jobseqpages-<rel>.dll - client patch component (7.5.1)
jobseqframe-<rel>.dll - client support dll
dsguictrls-<rel>.dll - client support dll
dsjsjobgen-<rel>.dll - client support dll
dsdesign-<rel>.exe - client support dll
vmdsedit-<rel>.dll - client support dll
vmdsobj-<rel>.dll - client support dll
vmdsrpos-<rel>.dll - client support dll
vmdstool-<rel>.dll - client support dll

Is there another patch?

Uninstalled. Rebooted. Installed patch. Did not work!
I have installed the patch. Rebooted. Did not work!
Re-registered the dlls above manually. Rebooted. Did not work!

OK.... Here's the twist!!!

I am working from my home office through VPN (actually Check Point VPN-1 Secure Remote) and it's working!!!!!

Anyone have any ideas why being behind the firewall running 100 MB doesn't work and running through VPN at DSL speed does?

ray.wurlod · Post by **ray.wurlod** » Tue Apr 04, 2006 3:00 pm

Are you correctly identifying the host name when trying to connect from work? Try using the IP address rather than the machine name, to eliminate the possibility that gethostbyname() is the culprit.

mczern · Post by **mczern** » Wed Apr 05, 2006 10:48 am

ray.wurlod wrote:Are you correctly identifying the host name when trying to connect from work? Try using the IP address rather than the machine name, to eliminate the possibility that gethostbyname() is the culprit.

Tried connecting using only IP address.
Same result. Breaks connection when attempting to save or compile job.

mczern · Post by **mczern** » Fri Apr 07, 2006 7:41 am

mczern wrote:
ray.wurlod wrote:Are you correctly identifying the host name when trying to connect from work? Try using the IP address rather than the machine name, to eliminate the possibility that gethostbyname() is the culprit.
Tried connecting using only IP address.
Same result. Breaks connection when attempting to save or compile job.

Finally a solution...
After countless hours of frustration, I have solved the problem.

From my home office, I went into the Device Manager, Network adapters section in the Computer Management console and deleted the network driver for my internal NIC card. I used my wireless connection to download the latest NIC driver for my laptop. Installed the driver and reconnected using the hardwire. I tested the DataStage client app through VPN and it worked. I went to the my client site the next day and it worked there as well.

The only thing I can think of is that the VPN software somehow got entangled in the driver and created this issue.

Hope this helps if someone ever gets the same strange issue.

:D

ray.wurlod · Post by **ray.wurlod** » Fri Apr 07, 2006 3:42 pm

Thanks for posting the solution. I use a very similar configuration, but have never seen this problem.