DSXchange

Broken pipe is when one stage fails in a link which either produces or consumes data. This is generally accompanied by an abort on a stage. Is there any more error message available in your logs ... Hi Sainath, Yes, that was the reason. I was looking for it, actually the job was failing due to a er...

Hello,

I am trying to find out the reason for the following error -

Write to dataset failed: Broken pipe

Appreciate any help about why this might be occuring.

Thank You!

If you keep the same character set throughout there will be no problem with such characters. 1. What is the encoding used in your DB2 table? Have you told that to DataStage? 2. What is the encoding used in your Oracle table? Have you specified this in DataStage as well? When you fix #1 and #2 your ...

If you keep the same character set throughout there will be no problem with such characters. 1. What is the encoding used in your DB2 table? Have you told that to DataStage? 2. What is the encoding used in your Oracle table? Have you specified this in DataStage as well? When you fix #1 and #2 your ...

Hi, I encountring a problem while reading special charachters like trademark sign, registered signs, and other special signs stored in DB2 database. When quried from DB2 database and loaded into Oracle database, the characters are translated into junk characters, like inverted question marks etc. Is...

Hi, I have used CDC a couple of times on dimension tables with low volume of data(about 1 million records) and the performance was good.But now I have a requirement where I have to compare an entire record(20 columns) and the volume of data is high(21 million records).The job is running for the last...

adis wrote:

girija wrote:Select option "Clear" in "Preserver Partitioning" of your transformer output link.

Thanks for your quick reply! I will check it.

That did the trick!! Thanks, warning is not there anymore....

girija wrote:Select option "Clear" in "Preserver Partitioning" of your transformer output link.

Thanks for your quick reply! I will check it.

girija wrote:Do you have separate file for two link?
Check RCP check box in your job.

Yes, seperate files for 2 links.
I will check RCP.

Hi Guys, Any ideas about the following warning message? When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0. I am getting this warning message while writing records from transformer to a sequential file. I have been writing to seque...

ray.wurlod wrote:Where do the reject links go? ...

The reject writes to text files.

Thanks!
Rishi

Hello All, I have 2 Oracle Enterprise Stages in my job for inserting records. Both have reject links with default output column "sqlcode" along with other columns. When I run my job I get a warning - "When checking operator: Dropping component "sqlcode" because of a prior co...

Hi I am getting the following error when trying to write data into a sequential file When checking operator: When validating export schema: At field "col1": "null_field" length (0) must match field's fixed width (19). My input data type for the col1 is timestamp(nulls...yes) Aprr...