Search found 78 matches

by shaonli
Mon May 28, 2007 6:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting error in a parallel job with OCI and funnel stage
Replies: 1
Views: 680

Getting error in a parallel job with OCI and funnel stage

I am getting an error "When checking operator: Dropping "C1" in transfer from "inrec" to "outrec""
while processing data from OCI stage(Reject link->reject=TRUE) to funnel stage through transformer.

Please suggest.
by shaonli
Fri May 25, 2007 2:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Longvarbinary datatype problem in a job
Replies: 4
Views: 2362

Thanks for the info.
by shaonli
Thu May 24, 2007 11:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Longvarbinary datatype problem in a job
Replies: 4
Views: 2362

Longvarbinary datatype problem in a job

Source of my job is SQL server table.It has a column whose datatype is Longvar binary (length-214748364). The target table is oracle 9i.I am creating the table from job with same datatype. The table is getting created with datatype LongRaw.But The job is getting aborted with error "Oracle datat...
by shaonli
Thu May 24, 2007 3:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to use XML as source in parallel Extender
Replies: 3
Views: 1316

I tried to use Sequential File stage to read multiple files. I have set Source->Read Method->File patternS Source->File Pattern->filepath/*.xml I have selected one single column named 'Record' only to store the XML. In the next stage XML Input Stage in the input tab I have selected Record as XML sou...
by shaonli
Thu May 24, 2007 12:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to use XML as source in parallel Extender
Replies: 3
Views: 1316

How to use XML as source in parallel Extender

While developing a job using XML we use folder stage before XML input stage in Datastage Server job.If I want to develope the same job in Parallel extender how to do it as there is no folder stag in parallel extender.

Please suggest.
by shaonli
Thu Apr 26, 2007 4:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting error in a job using Aggregator
Replies: 8
Views: 3001

source->transformer->sorter->aggregrator->target.

it is getting aborted after transformer.
by shaonli
Thu Apr 26, 2007 3:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting error in a job using Aggregator
Replies: 8
Views: 3001

Hi,

Using sorter also the job is getting aborted with this error "Error in merging files
At row 1, link "INST_Cds1"
Call to output link returned numeric error code: -100"

Please suggest.
by shaonli
Thu Apr 26, 2007 12:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting error in a job using Aggregator
Replies: 8
Views: 3001

Soumik,

Can you tell me the size of the Inter Process Buffer Memory?

Thanks
Shaonli
by shaonli
Wed Apr 25, 2007 11:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting error in a job using Aggregator
Replies: 8
Views: 3001

Getting error in a job using Aggregator

Hi, I am running a job in DS 7.5 with an aggregator.The volume of data is almost 14056919.The job is getting aborted when it is trying to aggregate the data after selecting from the source. The error is "job1 Aggregator_9: |-100|" The buffer memeory is 1024 kb. Please suggest. Thanks Shaonli
by shaonli
Fri Apr 13, 2007 8:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Facing Problem while usinh XML as source in DataStage 7.5
Replies: 1
Views: 1121

Facing Problem while usinh XML as source in DataStage 7.5

I am developing a job where XML is used as a source.The traget table is RDBMS. Now the XML source is containing the data like this: <A> <a>abc</a> <b>123</b> <c>q</c> </A> <B> <d>2007</d> <e>DP</e> <f>-4</f> </B> <B> <d>2006</d> <e>DH</e> <f>-3</f> </B> <B> <d>2006</d> <e>DJ</e> <f>-2</f> </B> The c...
by shaonli
Mon Apr 09, 2007 2:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting error in compilation of a job where XML is used sour
Replies: 4
Views: 1057

Is it is in job design.I want to load it into oracle table not in xml format.
Are you talking about folder stage?How should I use that before Xml-Input?
by shaonli
Mon Apr 09, 2007 12:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting error in compilation of a job where XML is used sour
Replies: 4
Views: 1057

getting error in compilation of a job where XML is used sour

I am creating a new job with XMl as source.I want to pupulate XMl source in a table.I have used xml stage and I have loaded the metadata with XML metadata importer.When I am compling the job it is giving the error "Plug in stage does not have the required stream inputs". I have given the X...
by shaonli
Tue Feb 27, 2007 1:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to connect Data Stage Client
Replies: 11
Views: 5940

You mean to say, server is up and running and Client is not able to connect? Have you tried with different client machine? What happens if you execute /bin/uv from $DSHOME, were you able to get '>' prompt? There was problem with password file.After resolving it We are able to connect to the client....
by shaonli
Tue Feb 27, 2007 1:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to connect Data Stage Client
Replies: 11
Views: 5940

kumar_s wrote:Were you getting this error all out of sudden? Did you do any maintanance in your server or any configuratin change?
Check if you license are still valid?

license is still valid.No maintanance has been done.But we are still getting this error.