Copying Project folders

subramanya · Post by **subramanya** » Thu Aug 18, 2005 9:06 am

Hi,

The server in which the project was residing has crashed. So I created a project with the same name on a different machine and copied the prevoius project folder to the current installation project folder. Now if I try to login into DS Manager, the following error message is coming "DSR.ADMIN: Cannot open file UV_USERS STATUS()= -2" and "ACCESS DENIED..Internal SQL Error. Failed to register this user for SQL".
What is the procedure to copy project folders..? or any other folders to copy..

regds
Subramanya

ArndW · Post by **ArndW** » Thu Aug 18, 2005 9:34 am

The SQL issue has been covered in this forum; in addition it is very important for you to do a DS.TOOLS and reindex; the secondary indices are linked to by absolute pathnames, so doing an OS level move of the files and indices will cause corruption that requires index rebuild.

chucksmith · Post by **chucksmith** » Thu Aug 18, 2005 9:37 am

It sounds like the DataStage HOME path is different than on the first server.

If this is the case, I can think of two work arounds.

1) Back up any other projects on the second server, then reinstall DataStage using the same dshome path as the first server, then restore your projects.

2) THIS IS DANGEROUS! Edit any file paths in the VOC file that may point to the old dshome changing them to point to the new dshome. There could still be other issues.

Good luck.

subramanya · Post by **subramanya** » Fri Aug 19, 2005 8:42 am

ArndW wrote:The SQL issue has been covered in this forum; in addition it is very important for you to do a DS.TOOLS and reindex; the secondary indices are linked to by absolute pathnames, so doing an OS level move of the files and indices will cause corruption that requires index rebuild.

If I use DS.TOOLS or DS.REINDEX ALL commands, the following error message is displayed "Unable to open Sys.Message File"

Subramanya

ArndW · Post by **ArndW** » Fri Aug 19, 2005 8:43 am

I only have one word - reinstall

sorry...

ray.wurlod · Post by **ray.wurlod** » Fri Aug 19, 2005 5:06 pm

Copying folders won't help.

You might try logging in to the server as a user with DBA privilege and granting CONNECT privilege to the user in question, doing manually what DataStage seems unable to have done.

Ultimately, however, you need to have the integrity of your Engine and SQL Catalog databases checked.