Error DS_JOBOBJECTS does not Exist

[Vinodanand]

Hi ,

I am getting the following error when I try to open teh job from designer

Record J\376\V0 in file DS_JOBOBJECTS does not exist

When i tried to delete the job and/or reimport it it says job accessed by another user but I checked for locks and tried to clear the status of the file but nothing helped.

Please let me know if anything can be done apart from this

Regards,
Vinod

[Abhinav]

Did you try to kill the job from unix, kill by PID in unix and see if you can open the job.

Abhi

[Vinodanand]

I am unable to kill by PID as there are no process running and we have a lot of slave connections open.

[dspxguy]

I would go to the project and do

ls | grep (jobno)

it would pull all the RT and DS files associated with the job no.

I would remove them one by one and Delete the VOC entries too from the admin command window.


Then after everything has been done successfully, Import the job again.

HTH

Guys please correct me if I am wrong .
Thanks

[ray.wurlod]

You're wrong. (You did ask!)

There is only one record missing from DS_JOBOBJECTS, and it is the record relating to the job view (the design canvas). So you don't need to "pull" anything - it will suffice to re-import the job.

Assuming the view definition is in the export file, all will be well.

It is definitely unnecessary to remove the RT_... hashed files that support the job.

(All of the above assumes that DS_JOBOBJECTS and its indexes have not been corrupted.)

[Vinodanand]

Ray ,

I tried to re-import the job and it threw an error saying job being accessed by another user. After 4 - 5 hrs I tried to re-import it and it imported without any issues and I was able to compile the job,not sure though what the reason could be.

Thanks,
Vinod

[ray.wurlod]

The reason is that, in that time, the deadlock daemon (dsdlockd) had cleaned up after the defunct processes.