Search found 195 matches
- Wed Nov 30, 2016 2:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: java.net.SocketException: Connection reset
- Replies: 1
- Views: 1627
java.net.SocketException: Connection reset
Hi, My job is failing while reading data through file_connector stage, please help me to resolve the issue. Error: File_Connector_10,0: An exception occurred: com.ascential.e2.common.CC_Exception: Failed to parse row 1,138,067 (org.apache.avro.AvroRuntimeException: java.net.SocketException: Connecti...
- Mon Nov 14, 2016 5:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: timestamp to string conversion error
- Replies: 1
- Views: 1484
timestamp to string conversion error
Hi While i am trying to convert the string to timestamp getting below error. Caould some one help to me. Numeric value first converting into string and then that string value converting to timestamp. using format in the transformer ::stringToTimestamp(var1,"%yyyy-%mm-%dd %hh:%nn:%ss") Erro...
- Wed Nov 02, 2016 12:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to do a Union condition in Datastage
- Replies: 3
- Views: 5887
- Tue Nov 01, 2016 12:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to do a Union condition in Datastage
- Replies: 3
- Views: 5887
How to do a Union condition in Datastage
Hi All,
We can do Union all condition with funnel stage, how we can implement the union logic in datastage ?, can some one help.
We can do Union all condition with funnel stage, how we can implement the union logic in datastage ?, can some one help.
- Tue Oct 18, 2016 4:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hive_Connector_24,0: java.lang.StringIndexOutOfBoundsExcepti
- Replies: 0
- Views: 2184
Hive_Connector_24,0: java.lang.StringIndexOutOfBoundsExcepti
Hi, I am trying to load the data into hive data base though hive connector getting below error, still I am using my data type length is 250 in datastage and in hive provide the STRING as data type. Hive_Connector_24,0: java.lang.StringIndexOutOfBoundsException at java.lang.String.substring (String.j...
- Fri Oct 14, 2016 6:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: File connector showing No such file or directory
- Replies: 4
- Views: 2554
No It is in bigdata location... and getting below error. File_Connector_0: java.lang.NoSuchMethodError: org/apache/http/conn/scheme/Scheme.<init>(Ljava/lang/String;ILorg/apache/http/conn/scheme/SchemeSocketFactory;)V at org.apache.http.impl.conn.SchemeRegistryFactory.createDefault (SchemeRegistryFac...
- Fri Oct 14, 2016 6:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Access Big Data, AVRO, and ORC from File Connector
- Replies: 1
- Views: 2369
Access Big Data, AVRO, and ORC from File Connector
Hi,
Any one worked with the Big Data, AVRO, ORC, Sequence through FILE connector stage. IF Yes tell me how to develop and required installations.
Any one worked with the Big Data, AVRO, ORC, Sequence through FILE connector stage. IF Yes tell me how to develop and required installations.
- Tue Oct 04, 2016 6:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: File connector showing No such file or directory
- Replies: 4
- Views: 2554
File connector showing No such file or directory
Hi All, I am getting below error. File_Connector_14: com.ascential.e2.common.CC_Exception: java.io.FileNotFoundException: /EDMBD/CDH/avro_sch.avsc (No such file or directory) But providing the Host,port,user, filename, avro schema but still job failing. Eventhough schema file in a location, job show...
- Fri Jan 22, 2016 5:34 am
- Forum: General
- Topic: sequence job failure
- Replies: 16
- Views: 7958
sequence job failure
Hi,
in my sequencer i have 5 jobs, if my 4th job fails, after reset the job, sequencer should be rerun from 3rd job not from 4th job.
Please some one give an idea how to achieve this activity without using routine.
in my sequencer i have 5 jobs, if my 4th job fails, after reset the job, sequencer should be rerun from 3rd job not from 4th job.
Please some one give an idea how to achieve this activity without using routine.
- Sat Jan 16, 2016 12:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dynamically select the column at runtime
- Replies: 10
- Views: 4933
dynamically select the column at runtime
Hi,
I want to select the required column dynamically at run time.
Ex: out of 5 columns, may i will select any column at runtime, output should be only selected column data..
I want to select the required column dynamically at run time.
Ex: out of 5 columns, may i will select any column at runtime, output should be only selected column data..
- Fri Sep 25, 2015 8:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Invalid character(s) ([x8D]) found converting string
- Replies: 1
- Views: 2074
Invalid character(s) ([x8D]) found converting string
Hi I am getting below warning can any one can explain what is the meaning and how to resolve the issue. 1) SqlTb_Stg_Mstr,0: Invalid character(s) ([x8D]) found converting string (code point(s): SLA_000215_D[xC3][x8D]AS DE CINE) from codepage ASCL_MS1252 to Unicode, substituting. 2)APT_CombinedOperat...
- Wed Sep 02, 2015 5:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: using switch stage filtering different values into one file
- Replies: 3
- Views: 2080
using switch stage filtering different values into one file
Hi, scenario: i have 5 columns A,B,C,D,E when month 1, want to populate A,B,C,D,E when month 2, want to populate A,B,D,E when month 3, want to populate A,B,E but 3 output file name is should be same please tell me how to do this scenario I tried once. but if i use same name for 3 outputs file is cur...
- Wed Aug 19, 2015 3:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rejecting data without any logic from transformer to seqfile
- Replies: 6
- Views: 2378
Rejecting data without any logic from transformer to seqfile
Hi, We are mapping data from sql to sql and taken a reject link from Transformer for reject data, but the thing is rejecting the data without any logic in transformer and it's converted into the reject link. we have 4 keys. Those are Varchar only. Please tell some one how it's happening, i never see...
- Tue Aug 11, 2015 4:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Case statement in transformer
- Replies: 6
- Views: 6165
Re: Case statement in transformer
Hi i experimented will do with below logic even fine.
( Left(column,1) ='1' and Left(column,2) <>'12')
but looking any other way we can filter.
( Left(column,1) ='1' and Left(column,2) <>'12')
but looking any other way we can filter.
- Tue Aug 11, 2015 4:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Case statement in transformer
- Replies: 6
- Views: 6165
Case statement in transformer
Hi, Please explain the situation resolvation Now i am getting data -1,-12,-13,-1,-1 data started with 1 should be flip sign, if getting '-' should be '+' or '+' should be'-'. except data start with 12, remaining start with 1 should be change. i have to get the data like +1,-12,+13,+1,+1 How to do in...