while logging into datastage administrator there lies 5 project
only one project on clicking to that is prompting the below mentioned error.
the directory of that project is there in the server
Failed to connect to host: <server name>, project: <project name>
( The directory you are connecting to either is not a UV account or does not exist (39125))
The project may well be intact. It may be the system tables that refer to it that need verification. Search the forum; you are not the first to have encountered this particular symptom.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
i realize after posting the thread that it had already been raised.
The issue with the project is when i am trying to run the command prompt in the administrator its throwing the error. even i cant do the reindexing of it.
even i thought to export and import might solve the problem but i cant go into the project through manager
please suggest
creates a pointer to the UV.ACCOUNT table, which pointer does not exist in your project by default. ...
but in both of the tables UV_TABLES(schema) and UV.ACCOUNT ( acccount) have the entry for that project . then what is missing in this.
since i query on all the project available on that server will it affect other healthy project ( as i need to carry it in production )
This is the first time you have reported success from UV_SCHEMA and UV.ACCOUNT.
It was necessary to wait for that confirmation, and eliminate that possibility, before looking further.
Queries are read-only, and do not affect (change) anything, particularly not other projects.
You must now turn to the question of what might be the issue with the project to which you can not connect. Can you please execute a DS.REINDEX ALL command in that project from the Administrator client? (You must have exclusive access to the project.) This will identify or eliminate the possibility that it is the indexing that is the problem.
Also execute UVFIXFILE VOC command to see whether the VOC file is intact.
Report results here.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
i had try to run it in separate first run the command
SELECT * FROM UV_TABLES;
and then the command
SET-FILE UV UV.ACCOUNT UV.ACCOUNT SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT
but it is asking for Q
and then Account
what is that information and where can i get the info.
do i need to check any other UV tables like UV_VIEWS etc..
also UV_SCHEMA do not return any data.
i am executing in the following way
first execute the command " SET-FILE UV UV.ACCOUNT UV.ACCOUNT "
then execute it gave me a message
"UV.ACCOUNT is already in the VOC as type Q UV.ACCOUNT file in the UV home account
then while giving the command " SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT ;"
it list me all the projects
there i can see the project name for which i am getting the mentioned error.
Good. So the system tables (UV_SCHEMA and UV.ACCOUNT) are intact with respect to this project.
Have you been executing these commands from the Administrator client command window? If so, at least the Administrator client can connect to the project, which means that we have some progress on that score.
If not, please advise how you have been executing the commands I've requested.
Can users from other client machines connect, or do all client machines receive the same error message?
When you have exclusive access to the project, rebuild the repository indexes using the command