Deleting a project......
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
Deleting a project......
Hi All,
I have an issue here, A project was created and the project has been corrupted so I tried deleting the project but I was not able to do so using Adminstrator, when tried to log on to the project I get the following error message
Failed to connect to host: <servername>, project: <projectname>
( The directory you are connecting to either is not a UV account or does not exist (39125))
All the DataStage files are available in the dsproject.
Could any one please let me know what and how are the ways to delete a project which has been created.
Thanks & Regards
Mahesh
I have an issue here, A project was created and the project has been corrupted so I tried deleting the project but I was not able to do so using Adminstrator, when tried to log on to the project I get the following error message
Failed to connect to host: <servername>, project: <projectname>
( The directory you are connecting to either is not a UV account or does not exist (39125))
All the DataStage files are available in the dsproject.
Could any one please let me know what and how are the ways to delete a project which has been created.
Thanks & Regards
Mahesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Much more important is why your Administrator client can't find the UV account. If this works you will be able to delete a project using this client.
The most usual cause is that someone has moved the DSEngine directory from where it was originally installed. If that has occurred have it put back; there are just too many dependencies on its location. At the very least there will be a hidden file (/.dshome) or an environment variable ($DSHOME) that describes its location. (On Windows it's in the Registry.)
What happens on the UNIX machine if you execute the command cat /.dshome ? It should contain the correct directory for the DataStage engine directory (also known as the UV project or UV account).
Let's eliminate that possiblity before possibly wasting time on downstream possibilities such as no UV entry in the UV.ACCOUNT table.
The most usual cause is that someone has moved the DSEngine directory from where it was originally installed. If that has occurred have it put back; there are just too many dependencies on its location. At the very least there will be a hidden file (/.dshome) or an environment variable ($DSHOME) that describes its location. (On Windows it's in the Registry.)
What happens on the UNIX machine if you execute the command cat /.dshome ? It should contain the correct directory for the DataStage engine directory (also known as the UV project or UV account).
Let's eliminate that possiblity before possibly wasting time on downstream possibilities such as no UV entry in the UV.ACCOUNT table.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
Hi Ray,
The Server is on HP Unix and There are multiple projects on the server which I am able to work on but when I try to open one particular project I get the following error,
When I use "cat /.dshome" it goes to the directory where DSEngine is available.
I get the following error message
Failed to connect to host: <servername>, project: <projectname>
( The directory you are connecting to either is not a UV account or does not exist (39125))
I went into the Projects Directory you have all the related Data Stage files.
Please advise.
Thanks & Regards
Mahesh
The Server is on HP Unix and There are multiple projects on the server which I am able to work on but when I try to open one particular project I get the following error,
When I use "cat /.dshome" it goes to the directory where DSEngine is available.
I get the following error message
Failed to connect to host: <servername>, project: <projectname>
( The directory you are connecting to either is not a UV account or does not exist (39125))
I went into the Projects Directory you have all the related Data Stage files.
Please advise.
Thanks & Regards
Mahesh
At this point, it would seem the SQL Catalog for that project is horked up. There are a few posts on the subject here, this is one of the ones that helped me when facing a similar problem.
Note the rather strong warnings Ray gives in this post about having a good backup. Executing any of these steps improperly could result in more damage to your installation!
Note the rather strong warnings Ray gives in this post about having a good backup. Executing any of these steps improperly could result in more damage to your installation!
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
Hi All,
Thanks to both of you'll , I followed the steps indicated and I was able to remove the project alone.
Thanks again, I was able to learn some of the Administrative part of DS as well.
Could you'll please let me know if I could by any chance get some more information (Tips and Tricks) about the Administrative part of Data Stage any wrtie up or document would highly be appreciated.
Many thanks in advance.
Thanks & Regards
Mahesh
Thanks to both of you'll , I followed the steps indicated and I was able to remove the project alone.
Thanks again, I was able to learn some of the Administrative part of DS as well.
Could you'll please let me know if I could by any chance get some more information (Tips and Tricks) about the Administrative part of Data Stage any wrtie up or document would highly be appreciated.
Many thanks in advance.
Thanks & Regards
Mahesh
Use this forum for tips and tricks. Do a search on what you want. If you can't find it then post your search as question you will be answered.
Thanks
Thanks
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This set me to wondering whether anyone has written anything on all the various cases/scenarios of maintaining an automobile, what are the possible cases (what are all the things that could go wrong) and solutions that could be done?
Or perhaps the same on medical care and maintenance of the human body.
It's a huge task, not one that I'm likely to undertake without significant recompense.
Or perhaps the same on medical care and maintenance of the human body.
It's a huge task, not one that I'm likely to undertake without significant recompense.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Another way you might acquire this knowledge would be to try, fail/succeed, try again and then document. Much the same as many of us have done. By doing this you are learning and will be adding to a living document that you can use with any customer.
Regards,
Regards,
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Get to the TCL prompt on the server in the DataStage Engine directory (also called the UV account). Execute the following commands and describe the outcome.
Beware that project names are case sensitive.
Code: Select all
SELECT @ID FMT '18L', PATH FMT '72T' FROM UV.ACCOUNT WHERE @ID = '<<Project>>';
SELECT SCHEMA_NAME, PATH FROM UV_SCHEMA WHERE SCHEMA_NAME = '<<Project>>';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.