Jobs lost when updated in DS_JOBS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
Jobs lost when updated in DS_JOBS
Hi all,
There was requriment to add prefix job name
I updated DS_JOBS with that prefix
When i open first time from designer i got error with file name not in DS_JOBS
but all jobs got rename and i was able to open
but when i tried open jobs next time all jobs vanish
I was not able to create new jobs in that project
Then i rebuild repository indices
Now i able to create new job but not able to see old jobs in designer
when check jobs in DS_JOBS all jobs are there but rename jobs are not there
I tried to open jobs from designer there is no jobs in existing tab
but when i try with recent it is able to open that job (there is some old jobs in recent tab)
even i restared srevices
Can anybody try to help me out with this
Thanks,
Anupam
There was requriment to add prefix job name
I updated DS_JOBS with that prefix
When i open first time from designer i got error with file name not in DS_JOBS
but all jobs got rename and i was able to open
but when i tried open jobs next time all jobs vanish
I was not able to create new jobs in that project
Then i rebuild repository indices
Now i able to create new job but not able to see old jobs in designer
when check jobs in DS_JOBS all jobs are there but rename jobs are not there
I tried to open jobs from designer there is no jobs in existing tab
but when i try with recent it is able to open that job (there is some old jobs in recent tab)
even i restared srevices
Can anybody try to help me out with this
Thanks,
Anupam
Ouch... there's more than one place to change that, doing it only in DS_JOBS blew your RI in the project. First off, I'd suggest you undo that change to get everything back...
However, with all the other monkey shines like reindexing, I wonder if that is even possible anymore. I'm not sure what this means: "when check jobs in DS_JOBS all jobs are there but rename jobs are not there"... are your 'old' jobs still there or not?
Worst case, I hope you have a good backup or export to restore before you started this.
However, with all the other monkey shines like reindexing, I wonder if that is even possible anymore. I'm not sure what this means: "when check jobs in DS_JOBS all jobs are there but rename jobs are not there"... are your 'old' jobs still there or not?
Worst case, I hope you have a good backup or export to restore before you started this.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Anupam,
your post was a bit unclear about the current status.
1. How did you change the DS_JOBS hashed file (a program? TCL "update" command?)?
2. You need to make sure that all users are logged out when you do a reindex. Also, do your indices need rebuilding (do a LIST.INDEX DS_JOBS ALL and see if any are "required"). If any are required then you need to rebuild the indices before anything shows up in the director/manager/designer lists.
your post was a bit unclear about the current status.
1. How did you change the DS_JOBS hashed file (a program? TCL "update" command?)?
2. You need to make sure that all users are logged out when you do a reindex. Also, do your indices need rebuilding (do a LIST.INDEX DS_JOBS ALL and see if any are "required"). If any are required then you need to rebuild the indices before anything shows up in the director/manager/designer lists.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
yes .. Old jobs are still there in DS_JOBSchulett wrote:Ouch... there's more than one place to change that, doing it only in DS_JOBS blew your RI in the project. First off, I'd suggest you undo that change to get everything back...
However, with all the other monkey shines like reindexing, I wonder if that is even possible anymore. I'm not sure what this means: "when check jobs in DS_JOBS all jobs are there but rename jobs are not there"... are your 'old' jobs still there or not?
Worst case, I hope you have a good backup or export to restore before you started this.
Kumar - you cannot post links from your search results, they won't work for anyone else. See how it has a '&sid=' component? You need to link directly to the topic you found.kumar_s wrote:Have a (url=http://dsxchange.com/viewtopic.php?t=10 ... bd82f8e8da)look(/url) at this discussion regarding the renaming job.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
Rename jobs are not in DS_JOBS but Old jobs that are not rename are still in DS_JOBSkumar_s wrote:Do you mean to say, Old jobs, still exist along with new names
Can you provide the update statement used?
Have you reindexed only DS_JOBS or ALL after renaming DS_JOBS.
UPDATE DS_JOBS SET NAME = 'Prefix':NAME WHERE CATEGORY LIKE 'CategoryName'
this is statement i use to update DS_JOBS
I used ' redulid repository indices ' from DS.TOOLS
Thanks,
Anupam
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
A) What is the index status reported by "LIST.INDEX DS_JOBS ALL"
B) What happens when you try "RESIZE DS_JOBS * * *" or "FIX.FILE DS_JOBS"?
B) What happens when you try "RESIZE DS_JOBS * * *" or "FIX.FILE DS_JOBS"?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I searched. Went into the link. (Opened the post). Copied the available URL of the post directly and pasted. It still gives me those sid stuff.
Is there any otherway you provide the search results.
To topic of the post would be "RenameAllJobs - Easy ?"
Is there any otherway you provide the search results.
To topic of the post would be "RenameAllJobs - Easy ?"
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact: