Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
47shailesh
Participant
Posts: 60 Joined: Tue Aug 29, 2006 11:14 pm
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
47shailesh
Participant
Posts: 60 Joined: Tue Aug 29, 2006 11:14 pm
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
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Participant
Posts: 60 Joined: Tue Aug 29, 2006 11:14 pm
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
Charter Member
Posts: 299 Joined: Wed Nov 13, 2002 5:38 pm
Location: USA
Post
by throbinson » Fri Feb 08, 2008 12:28 pm
Ouch!
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Participant
Posts: 60 Joined: Tue Aug 29, 2006 11:14 pm
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
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Participant
Posts: 60 Joined: Tue Aug 29, 2006 11:14 pm
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
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Participant
Posts: 60 Joined: Tue Aug 29, 2006 11:14 pm
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
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Participant
Posts: 60 Joined: Tue Aug 29, 2006 11:14 pm
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