DSXchange

Hi all,

I have recently refreshed Project from Production in Testing env.

Problem:
Now when i try to run any job in Testing env the job is not running.
It shows status a compiled no logs are created. It niether gives any error.

Also when I monitor the Job it shows Waiting state for Transformers and ready state for OCIs..

What is the problem.

47shailesh wrote:I have recently refreshed Project from Production in Testing env.

Explain to us exactly how you did this 'refresh'.

We deleted all the Project related data in Testing and than Copied from Production, the Project related data to the Testing enviroment.

Was any of this "Data" in the DataStage project directory and did you do a UNIX level copy & deletion?

By Data I mean only the DataStage Code that was in production

And Yes I did a UNIX level copy from production and deletion in Testing

Ouch!

Oh my, not even close to what you needed to do. Drop the test project, recreate it empty and then populate it from a production export.

The only supported and correct way to migrate DataStage code is through the use of the export & import functionality; doing anything from the UNIX level will usually result in corrupted projects.

My mistake,

The removal of files was a UNIX level deletion but the import into the Testing was from a proper export file taken from production.

was something missed during the imports ??

What happens when you try to compile the jobs in Testing? Perhaps all you need to do is use the multiple job compile option on all imported jobs.

I tried compiling the jobs, jobs are still not running they remain in compilied state.

There are no logs in the director

If you manually create a simple dummy job can you compile and run that in the new project? Also, are you sure the compile is working? Try "resetting" a job and then compiling it to see if the status changes to make sure.

Yes I can compile a new created job, it compiles without any error.

The job is not running when I make it to run...
Since the job is in compiled state I am not able to Reset it

Can you also run the job you just created?
Can you validate the job - it should have a non-compiled status so that you can reset it.

Clicking on Run doen't do anything

Same is with Validating a Job, when I click on validate it shows nothing