8.1 Problem with Oracle Connector GUI (properties panel)

andresfe · Post by **andresfe** » Tue May 29, 2012 1:45 pm

Hello, right now I need to use the Oracle Connector stage (DataStage 8.1) but when I'm going to configure it's properties it almost always show me a slightly useless GUI, a few times other panel is shown (the right one) but I don't know how to do it (I haven't found a pattern, Job and other properties are always the same)

Example: (Yellow is the one that I need)
https://docs.google.com/open?id=0B9Axwd ... E1HWkNNWUk

Thanks for your help.

chulett · Post by **chulett** » Tue May 29, 2012 5:53 pm

That looks like the old 'Grid View' that (for other stages) was available via one of the right-click options. Sometimes we've seen that due to a lack of memory on the client, if you close everything out and perhaps even reboot your PC does the problem go away?

Do others have this same issue or just you?

ray.wurlod · Post by **ray.wurlod** » Wed May 30, 2012 12:47 am

Click on the appropriate part of the picture in the top left hand corner of the Connector stage editor. This will select either the stage properties or one of the link properties, which will be highlighted in yellow. Once you've done that, the properties grid applies to that stage/link.

andresfe · Post by **andresfe** » Wed May 30, 2012 8:24 am

chulett wrote:That looks like the old 'Grid View' that (for other stages) was available via one of the right-click options...

Yes, this happens with others too, no matter if the only thing running is DataStage (even after rebooting). We are accessing through a VPN to a server (where DataStage is running).

ray.wurlod wrote:Click on the appropriate part of the picture in the top left hand corner of the Connector stage editor. This will select either the stage properties or one of the link properties, which will be highl ...

I can't see your full answer (I think), as I can see, your suggestion is to see the Output label in the old 'Grid View', but this label doesn't have all the options like the one that let me write my own SQL statement

Output Label
https://docs.google.com/open?id=0B9Axwd ... XpzUHRkQ3M

I've just tried with other database Connectors and the same happens with all of them.

ray.wurlod · Post by **ray.wurlod** » Wed May 30, 2012 4:31 pm

How much real memory (RAM) does your client machine have?

andresfe · Post by **andresfe** » Wed May 30, 2012 4:38 pm

RAM = 1,93 GB

chulett · Post by **chulett** » Wed May 30, 2012 7:11 pm

So I'm assuming that means 2GB of physical RAM? If that's the case, you really should have twice that.

andresfe · Post by **andresfe** » Thu May 31, 2012 7:49 am

We've already tried with another machine with 8GB... our guess is that it's it is because of the application that connects to the server, we asked those who work locally and they don't have that problem.

We use CITRIX Access Gateway (Maybe it puts limits to the resources used by DataStage)

Thank you for your attention and quick responses.

chulett · Post by **chulett** » Thu May 31, 2012 9:47 am

8GB... what operating system are you running the client on?

andresfe · Post by **andresfe** » Thu May 31, 2012 3:42 pm

(2 GB Ram) -> Win XP, Vista, 7
(8 GB Ram) -> Win 7

eph · Post by **eph** » Fri Jun 01, 2012 3:43 am

Hi,

I got the exact same problem on 2 distant servers (RDP) which are xp and server 2003. They have 6GB and 12GB of ram on each.
Another 2003 server with 6GB of ram is displaying well my stage properties. Clients are installed with the same version.

Eric

chulett · Post by **chulett** » Fri Jun 01, 2012 5:56 am

One question in my mind: is the 8.1 client officially supported on any operating system other than XP? Also, if this is some kind of bug in the GUI, I would imagine by now there would be a patch / fix pack available for it - did either of you check with your official support provider?

Obiwon666 · Post by **Obiwon666** » Thu Jun 07, 2012 11:38 am

I've got the same pb recently, it was a conflict with dll called "ExGrid.dll".

In my case.
The software HP Quality Center load his own version of this libray and so DataStage Client use it and show a weird pane.

bashbal · Post by **bashbal** » Thu Jun 21, 2012 3:58 pm

I also was experiencing the same problem with 8.5 FP2. I resolved the issue with the following IBM tech note: http://www-01.ibm.com/support/docview.w ... wg21450055

I only did options 3a & 3b because my client machine is XP and not Vista or Win 7.