Designer freezing when opening OCI stage

ecclesr · Post by **ecclesr** » Tue Jul 11, 2006 7:40 pm

With and existing job in designer, I am able to open all stages except the OCI stages.

When I open an OCI stage my designer window "freezes"

I am able to close the designer session via task manager, Then I am able to reopen the designer session for the job again, but the window will again freeze if I again try to open an OCI stage in th job. I have tried the same with other jobs with OCI stages and they also freeze if I try to open OCI stages

Has anyone had this problem before -what are the possibel reasons for this occuring

Thanking you all in advance

kcbland · Post by **kcbland** » Tue Jul 11, 2006 7:46 pm

Determine if it's server or client related. If other PC's have the same problem - it's server. If it's your PC only, determine if it's project related or global. Let us know which.

Now go and release all the job locks left on the jobs you had open.

ecclesr · Post by **ecclesr** » Tue Jul 11, 2006 8:46 pm

The freeze when opening OCI stages is only occurring for me - no other developers

I have tested jobs with OCI stages in two different jobs in different projects (on different servers) - both cases the designer window freezes once I open a OCI stage

Thanking you all in advance

chulett · Post by **chulett** » Tue Jul 11, 2006 9:36 pm

Reinstall your client software.

kcbland · Post by **kcbland** » Tue Jul 11, 2006 9:52 pm

chulett wrote:Reinstall your client software.

Yup.

ecclesr · Post by **ecclesr** » Tue Jul 11, 2006 10:50 pm

Client uninstalled and fresh install

Still having the same issue

Thanking you all in advance

chulett · Post by **chulett** » Tue Jul 11, 2006 11:11 pm

Well, that doesn't make a whole lotta no sense. If it only happens on your pc... and it doesn't matter what server project you connect to... then it's an issue with your pc.

Try reinstalling the client software without uninstalling it first. Reboot. Try again, let us know.

Worst case, reinstall Windows.

ecclesr · Post by **ecclesr** » Wed Jul 12, 2006 2:10 am

Status of testing is

1. If via designer I either double click to open an OCI stage
or right click properties the designer window freezes

2. I have tried different jobs in different projects and even on different
servers - I get the same result when opening an OCI stage

3. I have removed and reinstalled datastage client on my pc
I get the same result when opening an OCI stage

4. I have logged on to a second PC which has datastage
I get the same result when opening an OCI stage

5. While logged on to the second PC I had a another user login to
datastage on the pc - get the same result when opening an OCI stage

6. The other users have no issues if they log into either pc

7. What we have found is I can open an OCI stage via Grid style
but not via Properties

Thanking you all in advance

kumar_s · Post by **kumar_s** » Wed Jul 12, 2006 4:37 am

4. I have logged on to a second PC which has datastage
I get the same result when opening an OCI stage

5. While logged on to the second PC I had a another user login to
datastage on the pc - get the same result when opening an OCI stage

6. The other users have no issues if they log into either pc

Iam not sure about the 4th and 5th point that you have mentioned.
Do you mean to say, if you log into any PC, you cannot use it.
anyother user can access either PC.
If this is the case, check with the necessary permission of your user id in database connection. Can you able to run the job?
Can you login to the dabase using user userid?

chulett · Post by **chulett** » Wed Jul 12, 2006 6:14 am

kumar_s wrote:If this is the case, check with the necessary permission of your user id in database connection. Can you able to run the job? Can you login to the dabase using user userid?

What in the world would this have to do with not being able to open the stage in the Designer?

So ecclesr, it's all about your userid? If you logon to multiple machines, the OCI stage cannot be opened? However, other people can log on to your pc and it works fine?

Points 5 and 6 seem to contradict each other, but then it is early in the morning. 6 says it works fine for other users on any pc. 5 seems to say that another user got 'the same result' - I assume that means they couldn't open the OCI stage. Confusing.

In any case, time for you to call your Support provider. Ask them what in the heck is going on.

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Jul 12, 2006 8:59 am

your user id has been vodooed. you have any suspiscions?

jokes apart. really its nothing on which anyone can help you out because its strange.

ecclesr · Post by **ecclesr** » Wed Jul 12, 2006 8:36 pm

Problem was simplely solved by having my lan profile dropped an rebuilt

Thank you all for your attempts to resolve this problem - I hope the solution is of use to someone in the future

reddyla · Post by **reddyla** » Wed Sep 06, 2006 1:52 pm

We encountered this same problem. Confirmed there were no issues for other users. Logged in to the problem pc with a different network id, problem was corrected. So we dropped and recreated the network profile of the problem id and it worked just as you said. You guys saved us a good hour or so of troubleshooting. Thanks!