Jobs appear in director after deleting in designer
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 11
- Joined: Tue May 10, 2011 2:39 am
- Location: Bangalore
Jobs appear in director after deleting in designer
I tried deleted some jobs and sequences from designer.But they appear in director.When I delete the job from director>it gives error telling that the Job cannot be found in repository. How do I delete jobs in director and designer both ( I need to synchronize both director and designer).
Let's start with the simple things first. Have you closed out and then re-opened the Director since you deleted the jobs in the Designer? Just wanted to ensure the Director had a chance to properly 'refresh' its list. It should happen automatically without needing that step, but still needs to be asked.
I'd also be curious if you had any issues deleting the jobs, any out of the ordinary messages when you did?
I'd also be curious if you had any issues deleting the jobs, any out of the ordinary messages when you did?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 11
- Joined: Tue May 10, 2011 2:39 am
- Location: Bangalore
I have refreshed the director and also have opened the new director connection to see the remainder jobs.But no luck.Still the deleted jobs appear in the director.
When I try deleting it from designer I get error
Unable to delete the items .Delete object for \$Job_path\$Jobname failed Error calling Subroutine DSR_JOB(Action=3) Check Datastage is set up correctly for the $Project_name.
The Job however disappears from designer but remains in director.
Another workaround that I tried is got the job number from ds_jobs and then deleted RT_CONFIG,RT_LOG,RT_BP.O,RT_BP,DS_TEMP,RT_SC,RT_STATUS for that job number and also deleted the job from DS_JOBS using command line in admin client.This worked out well.Job got deleted from designer as well as director.
I have to delete huge number of jobs so it is very tedious to do this manually for all jobs.Is there a way where i can synchronize both director and designer?
When I try deleting it from designer I get error
Unable to delete the items .Delete object for \$Job_path\$Jobname failed Error calling Subroutine DSR_JOB(Action=3) Check Datastage is set up correctly for the $Project_name.
The Job however disappears from designer but remains in director.
Another workaround that I tried is got the job number from ds_jobs and then deleted RT_CONFIG,RT_LOG,RT_BP.O,RT_BP,DS_TEMP,RT_SC,RT_STATUS for that job number and also deleted the job from DS_JOBS using command line in admin client.This worked out well.Job got deleted from designer as well as director.
I have to delete huge number of jobs so it is very tedious to do this manually for all jobs.Is there a way where i can synchronize both director and designer?
You do not want to be in there manually deleting anything from the old repository. I sincerely doubt it will "work out well" if you continue down that path. I strongly suggest you stop doing that.
What exact 8.x version do you have? Are you current on your fixpacks? In the 8.x world there are two repositories now, the one you're used to plus the relational XMETA repository. When (for whatever reason) they get out of sync you'll see issues like this. You really should be contacting your official support provider and letting them know you are having issues. They'll provide for you the proper mechanism to get things back in sync... and figure out why things are broken at the moment.
What exact 8.x version do you have? Are you current on your fixpacks? In the 8.x world there are two repositories now, the one you're used to plus the relational XMETA repository. When (for whatever reason) they get out of sync you'll see issues like this. You really should be contacting your official support provider and letting them know you are having issues. They'll provide for you the proper mechanism to get things back in sync... and figure out why things are broken at the moment.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 11
- Joined: Tue May 10, 2011 2:39 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It might be worth re-indexing your repository using the DS.REINDEX ALL command. Search DSXchange for details of how to use this command. In particular make very sure that you have exclusive access to the project.
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: 35
- Joined: Wed Oct 06, 2010 11:24 am
Re: Jobs appear in director after deleting in designer
I also faced this problem long back. But that got resolved I have to recall how? I think all the users have to restart there director.
Pacific
-
- Premium Member
- Posts: 11
- Joined: Tue May 10, 2011 2:39 am
- Location: Bangalore
We did the REINDEXING for that project.But no luck .ray.wurlod wrote:It might be worth re-indexing your repository using the DS.REINDEX ALL command. Search DSXchange for details of how to use this command. In particular make very sure that you have exclusive access to the project.
However have raised PMR with IBM.