Job exists in Director but not in Designer repository

abc123 · Post by **abc123** » Thu Feb 28, 2008 2:40 pm

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"

dspxlearn · Post by **dspxlearn** » Thu Feb 28, 2008 3:00 pm

Did you try refreshing the director or closing or reopening it?

abc123 · Post by **abc123** » Thu Feb 28, 2008 4:29 pm

DSDexter · Post by **DSDexter** » Fri Feb 29, 2008 12:18 am

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.

ArndW · Post by **ArndW** » Fri Feb 29, 2008 3:46 am

"DS.REINDEX ALL" would work better.

manuel.gomez · Post by **manuel.gomez** » Fri Oct 03, 2008 6:01 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 6:32 am

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.

pravin1581 · Post by **pravin1581** » Sun Oct 19, 2008 12:24 am

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.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 19, 2008 1:59 am

The table names are different too, and there are hundreds of them. No documentation appears to be available.

pravin1581 · Post by **pravin1581** » Sun Oct 19, 2008 2:22 am

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 ?

ArndW · Post by **ArndW** » Sun Oct 19, 2008 6:55 am

Probably "XMETA" - check which name you used during the installation.