SybaseOC stage not opening

anshumangupta1206 · Post by **anshumangupta1206** » Fri Aug 11, 2006 7:29 am

The problem is .. whenever I try to open the SybaseOC stage properties in the server job in any of the environments(dev,uat,prod), the screen gets hanged. I have tried reinstalling the Sybase client 12.5.1 and Datastage version 7.1 but still the problem persists.

(These are all old jobs and the system was working fine earlier).
I can open all othere stages, transformer, hash files etc. etc.

chulett · Post by **chulett** » Fri Aug 11, 2006 7:44 am

Does this problem only occur for you from your workstation, or is it a problem for everyone?

anshumangupta1206 · Post by **anshumangupta1206** » Fri Aug 11, 2006 8:00 am

chulett wrote:Does this problem only occur for you from your workstation, or is it a problem for everyone?

Yes it is happening only on my machine and all these jobs are working fine on other's machines.

chulett · Post by **chulett** » Fri Aug 11, 2006 8:42 am

Ok, then something specific to your installation. I'd suggest you completely uninstall the DataStage client. Make sure the directories it installed are completely removed and then reinstall the client.

See if that helps.

anshumangupta1206 · Post by **anshumangupta1206** » Fri Aug 11, 2006 10:48 am

chulett wrote:Ok, then something specific to your installation. I'd suggest you completely uninstall the DataStage client. Make sure the directories it installed are completely removed and then reinstall the client.

See if that helps.

chulett,
Thanks for ur suggestion

I uninstalled the client ( both Sybase and Datastage) , and again installed tehm but still the problem remains.
Please advise if there is anything else which can be done.

Regards

chulett · Post by **chulett** » Fri Aug 11, 2006 2:19 pm

I'm out of suggestions at this point other than to reimage your machine, but that sounds a little drastic. You should open a case with Ascential Support at this point and see what they have to say about the issue.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 11, 2006 10:50 pm

It might be worthwhile re-installing the SybaseOC plug-in stage using the Package Installer on your server.

Do you have Sybase client software installed on your DataStage server? This is absolutely required. As far as Sybase is concerned, a DataStage job is just another client application.

anshumangupta1206 · Post by **anshumangupta1206** » Tue Aug 15, 2006 4:55 am

ray.wurlod wrote:It might be worthwhile re-installing the SybaseOC plug-in stage using the Package Installer on your server.

Do you have Sybase client software installed on your DataStage server? This is absolutel ...

Hi all,
I could solve this problem, actually i cleared the registry entries form my machine for all the Ascential installations and then re-installed the client.
and it worket out

chulett · Post by **chulett** » Tue Aug 15, 2006 7:01 am

Technically, part of what I meant when I said to 'completely uninstall' the client - sorry, should have specifically mentioned that.