Delete jobs
Moderators: chulett, rschirm, roy
Delete jobs
I got some jobs that show in the Designer and Manager but not in Director. I tried to delete it but it prompt
"Cannot open executable job file RT_CONFIG192"
Anyone knows?
"Cannot open executable job file RT_CONFIG192"
Anyone knows?
This happened to me today. Last night I was doing an import and the power went out. So I had some broken jobs. There are several hash files that get created in a project which are used to design, build and run jobs. Each job has a job number like 1,2,3 ... All of these associated files have job number as part of their name. If you delete one of these files or an import stops before it can create one of these files then that job will not run properly. You have to know a little bit about
Universe to fix this. Every hash file should have a dictionary side as well as a data side. The DICT or dictionary side stores field names. Fields in Universe intrepret the data. They do not enforce data integrity like in Oracle and other databases. You could put a date field in field 3 and the dictionary could try to display it out field 4 and not work properly. The hash files associated with a job use a shared DICT file because they all have the same fields. The DICT file starts with "D_". It ends with same name as the DATA side like D_DS_JOBS and DS_JOBS. The associated job files are:
DS_TEMPnnn
RT_BPnnn
RT_BPnnn.O
RT_CONFIGnnn
RT_LOGnnn
RT_STATUSnnn
You can pretty well guess what each of these do. The nnn represents the job number. So 192 is the job number of the job which has a bad RT_CONFIG file. You can fix this with:
CREATE.FILE DATA RT_CONDIF192 DYNAMIC
If you want to fix the DICT side you need to edit the VOC record.
ED VOC RT_CONFIG192
You will need to make line 3 have D_RT_CONFIG on it.
Universe to fix this. Every hash file should have a dictionary side as well as a data side. The DICT or dictionary side stores field names. Fields in Universe intrepret the data. They do not enforce data integrity like in Oracle and other databases. You could put a date field in field 3 and the dictionary could try to display it out field 4 and not work properly. The hash files associated with a job use a shared DICT file because they all have the same fields. The DICT file starts with "D_". It ends with same name as the DATA side like D_DS_JOBS and DS_JOBS. The associated job files are:
DS_TEMPnnn
RT_BPnnn
RT_BPnnn.O
RT_CONFIGnnn
RT_LOGnnn
RT_STATUSnnn
You can pretty well guess what each of these do. The nnn represents the job number. So 192 is the job number of the job which has a bad RT_CONFIG file. You can fix this with:
CREATE.FILE DATA RT_CONDIF192 DYNAMIC
If you want to fix the DICT side you need to edit the VOC record.
ED VOC RT_CONFIG192
You will need to make line 3 have D_RT_CONFIG on it.
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You bet.
Arlo Guthrie is touring (or has just toured) here at the moment. Brought back a few memories, even though he doesn't do "that song" any more. Also, I ride a motorcycle.
echo "$DEITY has called in sick."
Arlo Guthrie is touring (or has just toured) here at the moment. Brought back a few memories, even though he doesn't do "that song" any more. Also, I ride a motorcycle.
echo "$DEITY has called in sick."
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Wandering WAY off topic!
Man, I remember Woody Guthrie!kduke wrote:Arlo Guthrie? Are you a hippie? You aren't that old are you, Ray?
And Maynard G Krebs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The whole point is that you do not need to create the RT_CONFIG file. There is no such file.elavenil wrote:Hi Kduke,
I got the same issue. As you suggessted i had created RT_CONFIG file and can you pls let me know what entries need to be added in VOC file.
Thanks & Regards
Saravanan
Each job has a hashed file called RT_CONFIGnnn associated with it, where nnn is the job number. Being a hashed file, RT_CONFIGnnn is a directory containing three files, plus an associated VOC entry.
Even if you did create it there is no guarantee that you can recover the job; it's likely that some or all of the job's entries from DS_JOBS, DS_JOBOBJECTS and possibly other hashed files have already been deleted.
The Cleanup option from the Administrator client is what you need.
It will delete all these orphaned entries.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Now you're just jumping to conclusions.kduke wrote:Woody grew up in Okemah, OK where my dad grew up. "In them Oklahoma hills where I was born". You probably like Dylan, CSNY, Buffalo Springfield. How about Hank Williams?
![Wink :wink:](./images/smilies/icon_wink.gif)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Makes a lot of sense. My draft number was 120. They were already scaling back by then. My brother got a college deferment. He is a little older was the perfect age to be in the middle of all that. I still love the music of the 60s and 70s. CCR was my fav and Led Zep. I liked some folk rock like CSNY and Dylan. Bit much now days. I still play some of it. Beatles will always be the best.
Ray, why aren't you more mellow? Life is too short to live for work. Too many jerks running the show. Too many buzzwords and not enough real skill. Never seen so many projects out of control with no clue on how to solve it. I wish we had some good books by guys like you and Ken to teach these people how to do this stuff in an organized way.
Ray, why aren't you more mellow? Life is too short to live for work. Too many jerks running the show. Too many buzzwords and not enough real skill. Never seen so many projects out of control with no clue on how to solve it. I wish we had some good books by guys like you and Ken to teach these people how to do this stuff in an organized way.
Mamu Kim