No longer see Tabs: Properties and Columns on any ODBC Stage

robinlg33 · Post by **robinlg33** » Tue Aug 20, 2013 1:50 pm

I can no longer see the Properties and Columns tabs on any of my ODBC Stages for DB2 or Sql Server. I can logon to another machine and view them. I had issues with some other software and they had to refresh some ACTIVEX information (I know nothing about ACTIVEX) and I don't know if that messed it up or if it was even happening before then. Do you have any ideas on how this can be fixed?

I have my help desk investigating but I thought I would give you all a shot.

Thank You,

Robin Gangler

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Aug 20, 2013 1:57 pm

To be specific, when you say "logon to another machine" do you mean login using a different PC, or connect to a different server from the same PC?

robinlg33 · Post by **robinlg33** » Tue Aug 20, 2013 3:31 pm

I went to another employee's PC (not my own) and logged into DataStage Dev as myself and I was able to view the tabs.

Do you think it may be something to do with the Client that is messed up? Do you think reinstalling DataStage to my machine would fix the problem?

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Aug 20, 2013 4:15 pm

Yes, and Yes. It is probably faster to uninstall and reinstall the client than it is to try to diagnose the problem.

My only concern is the other application you were mentioning. If fixing that application "broke" DataStage, then fixing DataStage may re-break that application. Though it is rare, it is can be caused by a library or pathing conflict. You should take a snap-shot of your environment variables before you do anything, that way if the other application breaks, you might be able to identify what changed in the library or command paths.

I'd recommend uninstalling the client using the uninstaller (default is C:/IBM/InformationServer/_uninstall/uninstall.exe), then removing the InformationServer directory after the uninstall completes. If you have multiple versions installed make sure to delete the correct one!

PaulVL · Post by **PaulVL** » Tue Aug 20, 2013 4:20 pm

Perhaps you didn't get a patch pushed to your box. Validate your Version.xml with your buddys box.

SURA · Post by **SURA** » Tue Aug 20, 2013 6:02 pm

robinlg33 wrote:I went to another employee's PC (not my own) and logged into DataStage Dev as myself and I was able to view the tabs.

I had something similar before!! I was not able to see the Partition icons and stat in the Designer and that too for me. If i connected to some other machine i can!!

Then a fix provided by IBM fixed it.

So re installation(Proper, including reg) could help, but no warranty or guaranty for how long the re-installation will work!

Do reinstall, but at the same time launch a PMR and get the fix.

robinlg33 · Post by **robinlg33** » Wed Aug 21, 2013 6:20 am

Thank you all. I posed the solutions to the help desk and we'll see what they decide.
Robin

priyadarshikunal · Post by **priyadarshikunal** » Wed Aug 21, 2013 7:14 am

Also you can make sure the registry entries are gone. I have seen such issues due to registry and also due to dll conflict. However my bets are on the registry.

priyadarshikunal · Post by **priyadarshikunal** » Wed Aug 21, 2013 7:17 am

and by registry I mean entries related to datastage.

robinlg33 · Post by **robinlg33** » Wed Aug 21, 2013 10:40 am

Ok Thank You! I will let them know.

rameshrr3 · Post by **rameshrr3** » Wed Aug 21, 2013 1:31 pm

If you havent uninstalled your client , can you try right clicking on your stage and selecting 'Properties' - > it may open up .

robinlg33 · Post by **robinlg33** » Thu Aug 22, 2013 5:22 am

I can open it but there is no longer a columns tab or a properties tab. I have hard coded SQL associated with the ODBC stages but can't get at it. If I run the job it runs as if the SQL is there.

I haven't heard from my help desk so not sure what solution they are going to come up with.

gulabi · Post by **gulabi** » Thu Aug 22, 2013 10:22 am

I have the same problem on my machine...
IBMs pages recognise this as a bug and suggest installing a patch to resolve the problem.. (Sorry I didnt keep track of the patch numbers etc..)

but, to temporarily resolve the problem, I run the following command, with admin rights:

Code: Select all

regsvr32 C:\IBM\InformationServer\Clients\Classic\ExGrid.dll

(also suggested as a temporary fix by IBM)
Can you try this and let us know if it resolves the problem?

robinlg33 · Post by **robinlg33** » Thu Aug 22, 2013 11:44 am

Ok I'll pass this info on and see if the help desk will run. I will let you know if this works.

Thanks!

gulabi · Post by **gulabi** » Thu Aug 22, 2013 1:00 pm

On the contrary, I was hoping you`ll be able to run this on your machine (the same machine having the problem)... and see if it helps resolve the problem temporarily.

Whatever solution you might find, I guess that will just be applied on your machine - since this is not an issue affecting the whole Datastage server.

if you dont have admin rights on your machine, you`ll still have to request your Help Desk to either run this command or find the right patch and install.. or completely uninstall the client and re-install.

Hope this helps.