DRS Stage Hangs
Moderators: chulett, rschirm, roy
DRS Stage Hangs
Hi
when I am trying to open DRS Stage , job just hangs.we can run the jobs and view the stage from the designer . This happens only from one machine
does anyone have any idea ?
Thanks
when I am trying to open DRS Stage , job just hangs.we can run the jobs and view the stage from the designer . This happens only from one machine
does anyone have any idea ?
Thanks
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Does your DRS Stage have a very big complex Join or a view which has a very Complex Join?
If so then it will definitely hang.
Can you post the SQL Query you have in the DRS Stage?
If so then it will definitely hang.
Can you post the SQL Query you have in the DRS Stage?
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
How much is the memory (RAM) on this particular machine? And what is the difference with other machinces?
If there is no difference then try to cut out some programs that are running in the background to release some memory.
If there is no difference then try to cut out some programs that are running in the background to release some memory.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DRS Stage Hangs
Hi Ray,ray.wurlod wrote:Is your client running Windows XP sp2? If so, do you have the DataStage patch installed?
Even i am facing the same error, i installed the patch for XP sp2 but nothing works out. If i try opening a DRS Stage then Datastage client just freezes and i have to end the DS client from task manager. Any help is highly appreciated. I am using DS 7.5.1 on a windows client with UNIX server having solaris OS 9.
The SP2 patch is for problems with Sequence jobs, not the DRS stage. Are you the only one having this problem? If so, I'd suggest you completely uninstall the DataStage client and then re-install it. And by 'completely', I mean with extreme prejudice:
1) Uninstall.
2) Remove any leftover Directories.
3) Use (Run...) 'regedit' to remove all traces of any 'Ascential' keywords.
4) Reboot.
5) Re-install.
Be careful with #3, if you've never used 'regedit' before you can get yourself in a World of Hurt if you use it improperly.
1) Uninstall.
2) Remove any leftover Directories.
3) Use (Run...) 'regedit' to remove all traces of any 'Ascential' keywords.
4) Reboot.
5) Re-install.
Be careful with #3, if you've never used 'regedit' before you can get yourself in a World of Hurt if you use it improperly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: