Jobs not running

47shailesh · Post by **47shailesh** » Fri Feb 08, 2008 12:01 pm

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.

chulett · Post by **chulett** » Fri Feb 08, 2008 12:05 pm

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

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

47shailesh · Post by **47shailesh** » Fri Feb 08, 2008 12:08 pm

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

ArndW · Post by **ArndW** » Fri Feb 08, 2008 12:18 pm

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

47shailesh · Post by **47shailesh** » Fri Feb 08, 2008 12:21 pm

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

throbinson · Post by **throbinson** » Fri Feb 08, 2008 12:28 pm

Ouch!

chulett · Post by **chulett** » Fri Feb 08, 2008 12:28 pm

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.

ArndW · Post by **ArndW** » Fri Feb 08, 2008 12:28 pm

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.

47shailesh · Post by **47shailesh** » Mon Feb 11, 2008 3:27 am

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 ??

ArndW · Post by **ArndW** » Mon Feb 11, 2008 3:56 am

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.

47shailesh · Post by **47shailesh** » Mon Feb 11, 2008 5:21 am

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

There are no logs in the director

ArndW · Post by **ArndW** » Mon Feb 11, 2008 5:23 am

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.

47shailesh · Post by **47shailesh** » Mon Feb 11, 2008 7:43 am

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

ArndW · Post by **ArndW** » Mon Feb 11, 2008 7:46 am

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.

47shailesh · Post by **47shailesh** » Mon Feb 11, 2008 7:58 am

Clicking on Run doen't do anything

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

DSXchange

Jobs not running

Jobs not running

Re: Jobs not running