DSXchange

Hello,

I was working in Datastage and something strange happened.

Was working with a job, and I got this error message: "Type mistmatch"

I couldnt save my job, but a new one was created: ROOT (see image)

http://img292.imageshack.us/my.php?image=jobrootst1.jpg

Now, if I try to delete this job, I get this message:
I went to the console, and rebuild repository. Then stopped all datastage services and restarted again, but nothing changes, the job is still there

If I go to the Command Console, and do a SELECT * FROM DS_JOBS, none of the jobs do appear: 'root' nor 'Comp_MPD_SAP2'

Can anyone tell me what is it happening here?

Thanks very much

I just restarted completely the server
It did not help at all, problem remains the same

Odd... you probably need to take this question to your Support provider, looks like some new problem introduced in 8.x?

Can you rename "ROOT" to something else then delete it? Can you try to move it to another category then delete it? I recall having a similar V8 issue where the internal metadata and the repository metadata didn't match. This was a category with no components and I think we only got rid of it when we deactivated that project.

ROOT is a reserved name, and can not be used as a job name. This is undocumented, but even the visible portions of DS_JOBOBJECTS make it clear why it is so. You would need the same name for the job record and for its root (entrypoint) record. Duplicate primary keys are forbidden.

Thanks for your answers guys

I could not fix the issue at all. Tried to rename, move the job to a differente category, but nothing helped

Thank godness I backuped the project the day before this happened. So far, I will create a new project and import this backup, and try to delete the old one. I cant think in any other better solution

Sorry to hijack your thread but I have exactly the same problem, did you ever stumble over a soloution. I cant delete the projekt so I have my ROOT job laying there bothering me.

Thanks,
Mattias

You definitely need help from Support for this, to get your repositories in a consistent state after removal of the ROOT data.

I had the same problem again, now with a job sequence (I do have a root job and a root sequence)

Have you ever heard about this since I asked for the first time?

Thanks a lot

It won't really help unless we know the provenance of DStageWrapper. Does it come with DataStage, does it come from IBM, does it come from your particular reseller, was it written in-house? What's in it?