DSXchange

Hi,

I have a simple job, its just extract an load,
but when i run the job it hangs.
no log is recorded, after some time the job batch gets aborted,
i have no idea why this happens.
Please guide me through to solve the problem.

Rbk.

Remove the 'load' part, make the job write to /dev/null. If it still hangs, you know it is an issue on your extract, perhaps a very lenghty select. If it runs, then the issue is probably on your load stage.
Some more details on the stage types involved in the source and target would make solving the problem a lot easier as well.

Remove the 'load' part, make the job write to /dev/null. If it still hangs, you know it is an issue on your extract, perhaps a very lenghty select. If it runs, then the issue is probably on your load stage.
Some more details on the stage types involved in the source and target would make solving the problem a lot easier as well.

How are you managing to double-post all over the place here Arnd, every one several minutes apart? Curiouser and curiouser...

I've been getting network timeouts all day here - but I don't remember trying to re-post this one. Too late to delete the duplicate now as well. I suppose that this is one way to rack up some serious points.

ArndW wrote:I suppose that this is one way to rack up some serious points.

Hello,

i tried "view data" in the source stage, i got result in 5 min, there are about 15 lakhs records, but the stage hangs in the select query, when job is run.
and is there any other way other than removing the load part and writnig to dev/null

Rbk.

ArndW wrote:Some more details on the stage types involved in the source and target would make solving the problem a lot easier as well.

Any details, actually.

Hello,

Both stages are Oracle8 , Source stage has one select query, Transformer has 3 lookups and writes to oracle table and rejects are written to sequential file.
please let me know in case you need anything.


Rbk.

Put a constraint of "1=2" onto the transform stage output writing to your Oracle stage and run the job. Better yet, make a copy of your job and keep only your source stage and write the result to a sequential file at /dev/null to see how long your select takes to execute in the real job, not just the view data.

Hi,

I am also facing the same problem.

I have splitted the job into 2 using Seq File Stage.

Job1

Oracle Stage -> Seq

Job2

Seq -> Transformer -> Seq

Job1 executes successfully.

But in Job2, records were not fetched from the Seq file and the job keeps on running.

Thanks

Vinod

In your 2nd job are the input Seq and the output Seq files different?

Yes. Both are different.

Even I have changed the link names and dropped the transformer and recreated it.

I have changed the transformer with IPC stage. I faced the same problem.

It seems there is some problem in the Active stages in accepting the input records.

I doubt there is a bug - this is base functionality used successfully in hundreds of sites.
Try pointing your output Seq file to '/dev/null'