Following is the environment setting used to run the job , This i have captured from the director log.The Job automatically stops after pulling the 100th row from oracle database. Any clue on thi please
Hi ,
I am running from designer with out giving any rowlimits ( No Row limits ). I took the same Oracle stage out of the job and directly dumped the query result from the oracle stage to a text file and the ran the sample job through the designer, It pulled around 713475 rows. Hope something is wrong with the environment or some time out is happening any clue please
Do you have a constraint in your transform stage - either an explicit clause using @INROWNUM or perhaps a row limiter? When you job stops, is it with a status of aborted?
As a debug option, you can remove the stages from the job and them add one by one. Run the job after adding each stage (add a copy stage as the destination). The job might be aborting due to the later stages (other than Oracle stage).
There's probably a datatype issue (wrong datatype or NULL) happening in the Aggregator stage and the job is blowing up. The 100 rows is not an indication of which row has the issue, just the last time the job updated its link statistics. If I was you I would take the sequential file and try to run that thru the rest of the job and see what the Aggregator does.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Best thing is to check for Numeric data on those columns before doing aggregation.
(If Num(columnname) then columnname else 0).
Try this .May be it work.
I was wondering,
How many rows are there?
if you say less then 200 and your running OCI stage
I have encountered once a situation where array size of more then 1' let's say 100 gave only increments of 100 at the resulting row number equal Div(row number,100)
The work-around we used then was to use 1 at the array size.
I Hope This Helps,
Roy R.
Time is money but when you don't have money time is all you can afford.