Job exists in Director but not in Designer repository
Moderators: chulett, rschirm, roy
Job exists in Director but not in Designer repository
I have 2 jobs which I see in a category in the Director but I don't see them in the Designer. I remember deleting these jobs while the Director was open.
Could this be the reason? I cannot delete them from the Director. I get the message: "The following objects do not exist and cannot be used as a source"
Could this be the reason? I cannot delete them from the Director. I get the message: "The following objects do not exist and cannot be used as a source"
Hello,
It seems that the Index might be corrupted. You will have to run "DS.REINDEXALL" command on the project. You can run this command from DS Administrator or form Unix, But make sure that you are logged in as dsadm.Also while running this command, make sure that no user in logged onto the specific project. After the command is executed, Log on to your Director and check if the problem is resolved.
It seems that the Index might be corrupted. You will have to run "DS.REINDEXALL" command on the project. You can run this command from DS Administrator or form Unix, But make sure that you are logged in as dsadm.Also while running this command, make sure that no user in logged onto the specific project. After the command is executed, Log on to your Director and check if the problem is resolved.
"DS.REINDEX ALL" would work better.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 291
- Joined: Wed Sep 26, 2007 11:23 am
- Location: Madrid, Spain
I answer here because this user has the problem exaclty in the same condition as me (version 8 in UNIX)ArndW wrote:"DS.REINDEX ALL" would work better.
I just copy what I said in a very similar post:
I am having the same problem!!!
I did the following query:
Code: Select all
SELECT * FROM DS_JOBS WHERE NAME='JB_Extract_S_ACT_CONTACT'
I dont dare to do DELETE FROM DS_JOBS from command, as I am not sure this is deleting either in Universe and DB2 (or alternative) repository
Reindexing the project did not help neither
Any idea on the solution to this???
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you are on version 8, FORGET about using the local Repository tables alone.
Somewhere in the Information Server common repository there are additional references to these objects.
No-one has yet provided any ideas, scripts, tools, etc., for scanning that.
Somewhere in the Information Server common repository there are additional references to these objects.
No-one has yet provided any ideas, scripts, tools, etc., for scanning that.
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.
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
In which schema do we have the DS_JOB table.ray.wurlod wrote:If you are on version 8, FORGET about using the local Repository tables alone.
Somewhere in the Information Server common repository there are additional references to these objects.
No-one has yet provided any ideas, scripts, tools, etc., for scanning that.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
Probably "XMETA" - check which name you used during the installation.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>