Project Corrupted

[DS_SUPPORT]

we are not able to connect to our development project, When we tried to connect to the Project we are getting Error like

Code: Select all

"Failed to Connect to Host HOSTNAME, project : PROJECTNAME
( The directory you are connecting to either is not a UV account or doesnot exist (39125) )

By searching other posts, it was suggested the project directory would have been deleted at OS level.

But I am able to see my project directory, but i am not seeing any directories related to my jobs , I am able to see only main folders like
" &PH& , DS.GETINFO.DEFAULTS , DS_AUDIT, DS_CONTAINERS, DS_DATATYPES, DS_JOBOBJECTS, DS_JOBS, DS_METADATA, DS_RESENU, DS_ROUTINES, DS_STAGETYPES, DS_TRANSFORMS, and some I_**** folders" and only 3 files "D_DS_JOBS, developer.adm, VOC"

All the users are having read only rights to the project folder, So i dont think the users would have deleted the Jobs, what could be the other reasons for this type of corruption and is there any way to get our existing project back?

[nick.bond]

Check the permissions on the project directory and the group your user is in.

[ray.wurlod]

Your project directory seems to be present. However, it is incomplete, which suggests that creation of the project may have been interrupted. You should also see a file called VOCLIB and a whole lot of other files whose names begin with D_ (one for each of the DS_... folders, one for VOC, one for VOCLIB, one for &SAVEDLISTS&).

The message suggests that there is no entry for your project in one of the system tables; that is, in UV.ACCOUNT or UV_SCHEMA.

However this isn't really the issue. Your project has either only partially been created or has been partially deleted. In either case the remedy would seem to be to delete what's there, to fix up the system tables if there are any entries in them (use DELETE for UV.ACCOUNT and VERIFY.SQL for UV_SCHEMA), and re-create the project.

[DS_SUPPORT]

we are having 5 projects in the server, only in 3 projects we are getting this error and in another 2 projects we are able to connect normally. So i think it may not be problem with permissions.

[ray.wurlod]

Read my first paragraph again carefully.

Did you report an incomplete list of files and folders?

[DS_SUPPORT]

Ray

I replied to Nick and I didnt see the reply from you( check the posted time) , Anyhow i created an case with my admin team, And as of now we are creating a new project as we have a backup of old project.

I just want to know , is there any way of getting back the corrupted project.

[ray.wurlod]

Probably, at least from those parts that have not been deleted as part of a partial deletion of the project.

But there's no generic answer - it has to be done by a specialist.

[somesh999]

Hi,

If the datastage is installed on windows server then you can find the project directory in the following path

c:\Ascential\Datastage\Projects

In the specified path ifyou can see the project folder then the project exist other wise the project has been deleted.

we are not able to connect to our development project, When we tried to connect to the Project we are getting Error like

Code: Select all

"Failed to Connect to Host HOSTNAME, project : PROJECTNAME
( The directory you are connecting to either is not a UV account or doesnot exist (39125) )

By searching other posts, it was suggested the project directory would have been deleted at OS level.

But I am able to see my project directory, but i am not seeing any directories related to my jobs , I am able to see only main folders like
" &PH& , DS.GETINFO.DEFAULTS , DS_AUDIT, DS_CONTAINERS, DS_DATATYPES, DS_JOBOBJECTS, DS_JOBS, DS_METADATA, DS_RESENU, DS_ROUTINES, DS_STAGETYPES, DS_TRANSFORMS, and some I_**** folders" and only 3 files "D_DS_JOBS, developer.adm, VOC"

All the users are having read only rights to the project folder, So i dont think the users would have deleted the Jobs, what could be the other reasons for this type of corruption and is there any way to get our existing project back?

[ray.wurlod]

Welcome aboard. :D

The situation here appears to be that some of the project is present, and some is missing.

Your absolute assertion is misguided and misguiding.

Etiquette Note
Incidentally, there's no need to quote the previous post - it only wastes valuable space on the server.

[RAI ROUSES]

The same problem had occurred with our project (with DS7 in HP-UX), there is any way to check what file or directory is missing and how we can recovery it?

Rai