DSXchange

Hello ,

I have problem running jobs on my DEV server which runs on UNIX, so i have enabled reporting ENV variables to know the issue. The jobs start normally and after that they hung up and will be on RUNNING state forever.
In the job log i can see
main_program: Starting Players.
main_program: Waiting for Players to start.
main_program: Setting up data connections among Players.
main_program: Starting step execution.
main_program: Waiting for step completion.

And that's where the jobs are being struck up. Any inputs please...

What the job is doing?

DS User

Seqfile Stage-->>Transformer-->>Lookup (reference as Oracle table)-->>Transformer-->>output(Oracle enterprise stage)

reading an input fixed width field and trimming all of them about 20 columns and then do a lookup with a oracle table and then applying some transformations and then to get loaded to oracle table

I am not sure why?

But, change the tagert oracle stage(s) to run in Sequential (change it from default to Sequential), it may work.


DS User

Locking in the Oracle database?

I am deploying the jobs in another Environment to see if the problem is with the jobs or with the Environment before i put the blame on Oracle..Will update once i get some results. Thanks for replies