Job missing in repository

[ankursaxena.2003]

Hi,


I imported a DataStage job from dev to QA.
I cannot see these job in repository. But, when I do following command in unix, it shows me the job under that project

Code: Select all

$ ./dsjob -ljobs PROJECT_NAME

And when I try to import the same job again in QA, it gives me below error.

Code: Select all

The Job 'X' cannot be found in the repository

And during import when I see details, it says that Job Design is missing but Job Executable is present.

Do you guys know how can I delete the existing Job Executable.

[chulett]

Don't forget there are two repositories in play now. Best to get support involved. IMHO.

[ankursaxena.2003]

Craig,

I am also thinking of involving IBM, but before that I want to discuss this with my senior DataStage Developer.

I did some research and I found on IBM's website saying that the project might be corrupted. As I can see the Job present in Director but it is missing in Designer.

http://www-01.ibm.com/support/docview.w ... wg21574001

And when I followed the steps in the below link. I could find the Job a Job Number associated with the Job.(I did not do the delete part)

http://publib.boulder.ibm.com/infocente ... layer.html

[asorrell]

Well, from a technical viewpoint, the repository is definitely corrupted in that a job is not represented in its entirety in both the uniVerse and XMETA databases.

However, if it is just a case of a job not being completely stored, there may be a quick fix to resolve that.

Try the following:

1) Create a copy of the job
2) Verify the job looks correct (has all stages, compiles, etc.)
3) Delete the original job
4) Rename the copy

Alternatively:
1) Dump the job to DSX
2) Delete the original job
3) Load the DSX

That usually will resolve the missing pieces in the repository. If, however, it won't let you delete the job or overlay it, then you really do have a corrupted project and will need to run recovery procedures. Don't delay - it will probably get worse over time.

[ankursaxena.2003]

It is not allowing me to delete the job.()

So, I think the only option left is to do the recovery procedure by running the SyncProject Script.