Search found 9 matches

by nilesh_kant
Mon May 17, 2010 12:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange behaviour in Transformer
Replies: 10
Views: 4216

Hi,

Any help on the below topic will be appreciated...

Please tell me the path in Unix where to look these files.

The job gets aborted sometimes not daily. It runs fine after a re-run.
by nilesh_kant
Thu May 13, 2010 12:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange behaviour in Transformer
Replies: 10
Views: 4216

Yes I did get another warning. "DMDayLoad..DWFDay.inDWDay: DSD.BCIOpenW results of SQLColAttributes(PARENT_ROW_SEQ_NUM) gave MetaData mismatch COLUMN.TYPE Expected = BigInt Actual = Numeric". But this warning we get often and job doesn't get aborted.Only sometimes we get the job aborted. W...
by nilesh_kant
Wed May 12, 2010 11:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange behaviour in Transformer
Replies: 10
Views: 4216

Hi,

Abnormal termination of stage FactLLoad..t1XfrmFilterRows detected..

The above is the message I get.
by nilesh_kant
Wed May 12, 2010 10:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange behaviour in Transformer
Replies: 10
Views: 4216

I get only a single statement in the log saying Job has been reset and no othe logs. Jobs run normally when re-run.

Also, it is a server job and not a parallel job.
by nilesh_kant
Tue May 11, 2010 6:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange behaviour in Transformer
Replies: 10
Views: 4216

Strange behaviour in Transformer

I have a job which reads from a sequential file and loads into a Oracle database through a tranformer. The job gets aborted saying "Abnormal termination of stage load..t1XfrmFilterRows detected" . There are no error messages only two warnings. No conversion done in transformer. Number of r...
by nilesh_kant
Wed Jun 11, 2008 11:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Showing wrong count
Replies: 3
Views: 1319

Ray, The option "First Line is column names" is set to True which should mean that the header should not be taken as count while showing the total reords count. Also as I mentioned earlier When I am running the same job in different enviornment I am able to see correct count in the link co...
by nilesh_kant
Tue Jun 10, 2008 12:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Showing wrong count
Replies: 3
Views: 1319

File Showing wrong count

Hi, i am reading data from a sequential file with "First Row is Column name" set as true.The file has 100 records including the header. But the count in the link while running the job is showing as 100. ideally it should show as 99. The same file when i am running in other enviornment(Dev)...
by nilesh_kant
Wed May 07, 2008 4:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To abort a job in Transformer
Replies: 3
Views: 1308

Because if the job doesnt abort then we will be generating more ID's than required which goes against our requirement. Please let me know if there is any method by which we can abort a job in transformer.
by nilesh_kant
Wed May 07, 2008 4:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To abort a job in Transformer
Replies: 3
Views: 1308

To abort a job in Transformer

I am generating a one up number (ID's) in a transformer. Once the id's reach a max.value ( which is paased as a parameter) the job should get aborted. Can any one tell me how to do this in a transformer?

Regards