delete object

[murali]

Hi,
We have deleted one folder from manager, this folder contains twenty jobs. After deletion we tried to reimport from backup, then nineteen jobs got imported successfully and for remaining one job we are getting a message that the job already exists in the project. But if we see in the folder the job is not seen.
Then we re-indexed the project and again re-imported but we are again seeing the same message that job already exists in the project.
And as per your guidelines in previous mails to me we tried to clear status file and log file . But we are getting the message below as in the attachment.
How can we clean up this and again reimport ?

[ray.wurlod]

Get to a command prompt, such as the Administrator client Command window, and issue the command DS.CHECKER - this checks for incompletely deleted jobs and deletes orphaned components. This ought to be enough to cure your current dilemma.

[kumar_s]

That a the solution. Perhaps you could posted the full log. If the complain is about DS_JOBS, you could check whether the entry in the DS_JOBS by

Code: Select all

SELECT * FROM DS_JOBS WHERE NAME LIKE '%job name%'

.
And if you find the entry, make sure it is pointing to the same category as you expected. There may be a case, where it might be residing silently in other category. If is you can proceed with DS.CHECKER or DELETE. The first option is cleanest.

[ray.wurlod]

Problem is the second approach is knowing exactly what to delete. If there's an entry in DS_JOBS there may be entries in lots of other tables.