DSXchange

Hi,
I am getting the following error while running a job.

Contents of phantom output file =>
RT_SC1014/OshExecuter.sh[20]: 627050 Segmentation fault(coredump)
Parallel job reports failure (code 139)

Can anyone help me out how to get rid of this error.

Cheers
Debasis

Hi,
My input Time column is in string format and the values are like below.

6:35:23 PM
12:00:01 AM
02:24:22 PM

Input field is stored in DB2.

I need output like below in Timestamp

18:35:23
12:00:01
14:24:22

Can anyone help me out how to do it parallel.

Cheers
Debasis

Thanks Ray. Yes those sentences are present in the log.

Cheers
Debasis

Hi,
I made APT_DUMP_SCORE to True in one of my jobs . Can someone help me where to check the Dump_Score output. I checked in the log but couldnt find anything related to that.

Please tell me.

Cheers
Debasis

Hi, I am reading a dataset and creating output XML. Here is the XML output I am getting. <Message> <Main> <Col1>18108</Col1> <Col1>18108</Col1> <Col1>18108</Col1> <Col2>U00009473</Col2> ............... </Main> </Message> First Column is repeting 3 times as the I have 3 rows present for that same key...

Debasis, Are the column names of the field you are defining as key same in both input link and reference link? If so, Try renaming the either of the key field and then perform a lookup. e.g you could mention the reference column name as Id1 by writing a userdefined sql. Try this and let us know whe...

Normal lookup

If it is present in the dataset schema then you are left with the link coming from DB2. That is supported by the error message noting the "key" field is missing. ... Hi, Can you please tell me how to get rid of this error. I checked the dataset schema and also removed and recreated the lo...

Hi Nri,
I have checked that .. Id is present in the dataset schema..
I also deleted and recreated the dataset but no luck.

Cheers
Debasis

Hi, I have a input dataset with one field "Id" as key. I am doing a lookup using a lookup stage with a DB2 table based upon "Id". But I am getting the following error ... lookupstage: Error when checking operator: Key field "Id" not found in input schema But if I perfor...

So... you took PX job A and tried to save it as PX job B but couldn't for some unknown reason. When you were able to check again, PX job A is now an empty Server job? :? Hi Craig, I think you already understood the issue. Anyway I will contact the support for this issue. Thanks to all whoever repli...

Hi All.
Thanks for your replies. I know the problem is weired.. But if any one of you have any solutions for this please let me know.

Hi, Yesterday I performed a save-as operation on an existing PX job. But since there was a connectivity issue I couldnt do that. But after sometime when the connectivity issue solved I found the job I had opened has converted to server and the Canvas is totally empty.. Can anyone please help me out ...

Hi Ray,
Thanks for your reply.. You are right .. I also observed the same thing. But I wonder why ? Since the dataset creation job and my job (where I am using this Dataset with the Join stage) they both are using the same config file (of 4 nodes)..

Hi, I have two input datasets to join based upon a KEY. When I view the data in dataset stage the data looks OK and I get 32 number of records. But when I ran the job the join stage is able to read only 7 rows.. I tried all permutation and combinations of Partition types for the input datasets but s...