Jobs lost when updated in DS_JOBS

sb_akarmarkar · Post by **sb_akarmarkar** » Tue Jun 20, 2006 6:19 am

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

kumar_s · Post by **kumar_s** » Tue Jun 20, 2006 6:28 am

Have you updated DS_JOBOBJECTS accordingly?
You reduilt indices for ALL or for DS_JOBS?

chulett · Post by **chulett** » Tue Jun 20, 2006 6:32 am

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.

ArndW · Post by **ArndW** » Tue Jun 20, 2006 6:34 am

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.

sb_akarmarkar · Post by **sb_akarmarkar** » Tue Jun 20, 2006 6:38 am

kumar_s wrote:Have you updated DS_JOBOBJECTS accordingly?
You reduilt indices for ALL or for DS_JOBS?

I updated DS_JOBS to rename jobs acording to CATEGORY column as i tried for only one category.

I reduilt indices for ALL

Thanks,
Anupam

sb_akarmarkar · Post by **sb_akarmarkar** » Tue Jun 20, 2006 6:41 am

chulett 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.

yes .. Old jobs are still there in DS_JOBS

kumar_s · Post by **kumar_s** » Tue Jun 20, 2006 6:42 am

DS_JOBOBJECTS also need to be updated.
Have a look at this discussion regarding the renaming job.

kumar_s · Post by **kumar_s** » Tue Jun 20, 2006 6:47 am

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.

chulett · Post by **chulett** » Tue Jun 20, 2006 6:51 am

kumar_s wrote:Have a (url=http://dsxchange.com/viewtopic.php?t=10 ... bd82f8e8da)look(/url) at this discussion regarding the renaming job.

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.

sb_akarmarkar · Post by **sb_akarmarkar** » Tue Jun 20, 2006 6:53 am

kumar_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.

Rename jobs are not in DS_JOBS but Old jobs that are not rename are still in 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

sb_akarmarkar · Post by **sb_akarmarkar** » Tue Jun 20, 2006 6:58 am

I tried to excute SELECT DISTINCT CATEGORY FROM DS_JOBS

i found last record with

Attempted WRITE with NULL record ID
Aborting!

Thanks,
Anupam

ArndW · Post by **ArndW** » Tue Jun 20, 2006 7:16 am

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"?

kumar_s · Post by **kumar_s** » Tue Jun 20, 2006 7:22 am

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 ?"

sb_akarmarkar · Post by **sb_akarmarkar** » Tue Jun 20, 2006 7:26 am

I deleted rename jobs CATEGORY from DS_JOBS...
now i able to view all old jobs from desginer but i lost old rename jobs...

Thanks,
Anupam

kumar_s · Post by **kumar_s** » Tue Jun 20, 2006 7:31 am

Arnd - May I know what is the intention of RESIZE DS_JOBS * * * Will it give out the integrity of the indecies. It seems it requires an Exclusive access to DS_JOBS, so I could not test it now.