Page 1 of 1
Cannot open executable job file RT_CONFIG623
Posted: Mon Apr 17, 2006 5:46 am
by Sandhya.Arumugam
Hi,
whenever I open data stage director,I got one error for one job.I am unable to understand this problem.the error is
Can not open the executable file RT_CONFIG623
Thans in advance,
Sandhya
Posted: Mon Apr 17, 2006 7:17 am
by kcbland
Use DS.TOOLS to repair the repository. Search the forum to learn how to access it.
Posted: Mon Apr 17, 2006 8:00 am
by DSguru2B
Also try exporting and importing the job again.
Posted: Mon Apr 17, 2006 9:44 am
by mahi_mahi
DSguru2B wrote:Also try exporting and importing the job again.
But how do we know RT_LOGnnn belongs to which job?
Where can we find the information?
Posted: Mon Apr 17, 2006 9:46 am
by kcbland
To find out a jobs internal number, you must look at internal file DS_JOBS. Search for help on that.
Posted: Mon Apr 17, 2006 9:47 am
by kcbland
Of course, once you're already there to find out the jobs number, you could just run DS.TOOLS and be finished.
Posted: Mon Apr 17, 2006 1:56 pm
by DSguru2B
mahi_mahi wrote:But how do we know RT_LOGnnn belongs to which job?
Where can we find the information?
It can be found out by using Kcbland's way, moreover I think it would be obvious that the job which is giving the problem is showing up its RT_CONFIG.
Posted: Mon Apr 17, 2006 3:17 pm
by ray.wurlod
This is unrelated to RT_LOG623 and is unlikely to be corrected by anything in DS.TOOLS.
Search the forum for this particular error message (leave off the particular job number). It has been fully explained in the past. You have a corrupted RT_CONFIG623 hashed file here.
Posted: Mon Apr 17, 2006 3:51 pm
by kcbland
Methought there was a repair repository files under the DS.TOOLS repair indices processing? Was I drinking heavily at the time?
Posted: Mon Apr 17, 2006 4:28 pm
by kommven
Can you re-create the same error?
Try developing a similar job and try to get similar error.
This is the way to get solution....
made a mistake, do it again here get the cause and never do it again...
Posted: Mon Apr 17, 2006 4:32 pm
by chulett
kcbland wrote:Methought there was a repair repository files under the DS.TOOLS repair indices processing? Was I drinking heavily at the time?
Possibly, but that's a story for another day.
Posted: Mon Apr 17, 2006 9:43 pm
by ray.wurlod
kcbland wrote:Methought there was a repair repository files under the DS.TOOLS repair indices processing? Was I drinking heavily at the time?
DS.REINDEX is separate from DS.TOOLS. Without access to DataStage at the moment I can't recall if there is an option under DS.TOOLS to repair indices. Certainly they removed the option to search out orphaned job components, though the verb remains.
Nonetheless, this is almost certainly NOT a problem with indexes. Even if its indexes are corrupt, you can open a hashed file.
Further, none of the RT_... hashed files is indexed. Only the DS_... hashed files are indexed.
Posted: Mon Apr 17, 2006 10:29 pm
by kcbland
ray.wurlod wrote:Certainly they removed the option to search out orphaned job components, though the verb remains.
That must have been my repressed memory, but it's gone now under 7.5. I wonder why it's gone, because log, config, and status corruption seems to be so common. Sometimes importing the job again doesn't work because of a lock on one of the files, or the file is in a state that it can't be deleted and bombs the import when it tries to delete the job. I've manually cleaned out a jobs files when this happens.