unable to connect to host: error code 39125

[sunayan_pal]

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))

how to restore the project

[ray.wurlod]

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.

[sunayan_pal]

thanks Ray,

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

[ray.wurlod]

Can you get into any other project? If so check the system tables from there.

Code: Select all

SELECT * FROM UV_TABLES;
SET-FILE UV UV.ACCOUNT UV.ACCOUNT
SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT;

Don't be concerned if the SET-FILE command informs you that UV.ACCOUNT already exists in the VOC file.

[sunayan_pal]

Hi Ray,
i checked with the UV_TABLES , the project name is there.
i cannot get the last few words . is it the following

SET-FILE UV UV.ACCOUNT
UV.ACCOUNT
SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT

or

SET-FILE UV UV.ACCOUNT
SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT


what will this piece of code do?
Will if affect the rest of the project ?

[ray.wurlod]

Code: Select all

SET-FILE UV UV.ACCOUNT UV.ACCOUNT

creates a pointer to the UV.ACCOUNT table, which pointer does not exist in your project by default.

[sunayan_pal]

Code: Select all

SET-FILE UV UV.ACCOUNT UV.ACCOUNT

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 )

[ray.wurlod]

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.

[sunayan_pal]

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 ar ...

Hi ray,
do i need to excute the whole query at a time or in separate.

SELECT * FROM UV_TABLES; SET-FILE UV UV.ACCOUNT UV.ACCOUNT SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT

because on execution of this i did not get the required result
the problem still exist.

and if i execute
SET-FILE UV UV.ACCOUNT UV.ACCOUNT SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT
it is asking for the ACCOUNT

please suggest

[sunayan_pal]

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 ar ...

Hi ray,
do i need to excute the whole query at a time or in separate.

SELECT * FROM UV_TABLES; SET-FILE UV UV.ACCOUNT UV.ACCOUNT SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT

because on execution of this i did not get the required result
the problem still exist.

and if i execute
SET-FILE UV UV.ACCOUNT UV.ACCOUNT SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT
it is asking for the ACCOUNT

please suggest

[ray.wurlod]

Separate commands.

[sunayan_pal]

Separate commands. ...

Hi Ray,

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.

[ray.wurlod]

Separate commands.

Code: Select all

SET-FILE UV UV.ACCOUNT UV.ACCOUNT

SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT  ;

[sunayan_pal]

Separate commands.

Code: Select all

SET-FILE UV UV.ACCOUNT UV.ACCOUNT

SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT  ;

...

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.

please suggest

[ray.wurlod]

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

Code: Select all

DS.REINDEX ALL

Let us know if that solves your problem.