How to resolve "Can't open DS_JOBOBJECTS" error

ray.wurlod · Post by **ray.wurlod** » Fri Apr 03, 2009 1:26 pm

If the links are lost (possibly from running fixtool twice in succession) the file may be - probably is - irreperable.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 04, 2009 11:26 pm

These D_* entries are all just files, and can safely be copied (without overwriting any existing ones) with operating system cp command (UNIX) or COPY command (Windows).

Not sure why RT_CONFIG3613 is read-only - start by checking operating system permissions.

dspxguy · Post by **dspxguy** » Sun Apr 05, 2009 11:56 am

Hi,

The permissions on Project is

Code: Select all

drwxrwsr-x and group is dstage ( all developers have dstage as thier secondary group)

permissions on one of the RT_CONFIG file

Code: Select all

drwxrwsr-x

I have not copied the missing D_* files from other project , I will do that and will post results. Are the permissions okay on the project and RT files?

dspxguy · Post by **dspxguy** » Sun Apr 05, 2009 3:34 pm

Hi,

I copied thozse files from another PRoject, ran the reindex, bounced DataStage and was able to create, save and compile new jobs.

Also ran these commands from TCL

Code: Select all




>LIST.DICT RT_STATUS3616
 
$<50>DICT RT_STATUS3616    04:31:18pm  05 Apr 2009  Page    1
 
               Type &
Field......... Field. Field........ Conversion.. Column......... Output Depth &
Name.......... Number Definition... Code........ Heading........ Format Assoc..
 
@ID            D    0                            RT_STATUS       10L    S
 
1 records listed.

Code: Select all

>COUNT RT_CONFIG3616
 
4 records counted.

I still could not copy these files to the affected project, can you help me copy these to the other project

Code: Select all

D_&COMO&               
D_&SAVEDLISTS&

And what are these files?

Code: Select all

D_DS_JOB 
D_SDKSequences

I did not copy these and want to make sure if it is okay to copy them to the project?
Pleazse advise.

I have one more issue when importing metadata
"Empty DSN: list returned from host xyz"

dspxguy · Post by **dspxguy** » Sun Apr 05, 2009 4:02 pm

ok i resolved the last issue, empty dsn one.. the uvodbc.config was missing from project directory. I tested few jobs and they are running fine, Is there anything else I need to check to make sure everything is working properly?

Appreciate your help.

ray.wurlod · Post by **ray.wurlod** » Sun Apr 05, 2009 6:48 pm

The files with ampersands in their names have to be hard quoted or have the ampersands escaped in the cp command, for example D_\&COMO\& or 'D_&COMO&' (in single quotes). The is because ampersand is a shell metacharacter that instructs the shell to start a background process.

D_SDKSequences contains metadata (key only) of the hashed file that supports the SDK Key Management routines. You also need SDKSequences in the project, or neither.

D_DS_JOBS contains the metadata for DS_JOBS. It is the contents of this hashed file that you see when you LIST.DICT DS_JOBS.

dspxguy · Post by **dspxguy** » Wed Apr 08, 2009 1:32 pm

Ray, Thanks alot for your help.