Page 1 of 1
Job exists in Director but not in Designer repository
Posted: Thu Feb 28, 2008 2:40 pm
by abc123
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"
Posted: Thu Feb 28, 2008 3:00 pm
by dspxlearn
Did you try refreshing the director or closing or reopening it?
Posted: Thu Feb 28, 2008 4:29 pm
by abc123
Yes
Posted: Fri Feb 29, 2008 12:18 am
by DSDexter
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.
Posted: Fri Feb 29, 2008 3:46 am
by ArndW
"DS.REINDEX ALL" would work better.
Posted: Fri Oct 03, 2008 6:01 am
by manuel.gomez
ArndW wrote:"DS.REINDEX ALL" would work better.
I answer here because this user has the problem exaclty in the same condition as me (version 8 in UNIX)
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'
and it returned me results, but the job cannot be spotted in Designer, but perfectly visible in Director (and I can even watch detailed log for this job)
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???
Posted: Fri Oct 03, 2008 6:32 am
by ray.wurlod
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.
Posted: Sun Oct 19, 2008 12:24 am
by pravin1581
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.
In which schema do we have the DS_JOB table.
Posted: Sun Oct 19, 2008 1:59 am
by ray.wurlod
The table names are different too, and there are hundreds of them. No documentation appears to be available.
Posted: Sun Oct 19, 2008 2:22 am
by pravin1581
ray.wurlod wrote:The table names are different too, and there are hundreds of them. No documentation appears to be available.
In which schema do these tables exist ?
Posted: Sun Oct 19, 2008 6:55 am
by ArndW
Probably "XMETA" - check which name you used during the installation.