Import consumed only x bytes warning

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gilmar67
Participant
Posts: 3
Joined: Mon Dec 06, 2010 8:51 am
Location: Rome

Import consumed only x bytes warning

Post by gilmar67 »

Hi,
in a job I import from a txt file (with duplicated records) to a multiset table via a transformer.
Could you help me please with the warning "File_Seguimi,0: Import consumed only 27bytes of the record's 41 bytes (no further warnings will be generated from this partition)" ?

thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:idea: Please try to use meaningful subjects, I've changed yours from "DataStage" to something more... appropriate.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Obiwon666
Participant
Posts: 22
Joined: Wed Jan 17, 2007 5:34 am

Post by Obiwon666 »

It seems that your different format in your file (fixe format?).

First format use 40 byte and aonther one uses only 27 bytes.

Try to separate different format in import step.
gilmar67
Participant
Posts: 3
Joined: Mon Dec 06, 2010 8:51 am
Location: Rome

Post by gilmar67 »

Ok, resolved, thanks. It was a problem of format (date/varchar).
KRM12345
Participant
Posts: 3
Joined: Mon Jul 15, 2013 6:16 pm

Post by KRM12345 »

Hello,

I am also getting the same warning message.
But the format of (date/Char) looks fine.
Can you please suggest?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If nothing here has helped, suggest you start your own post and give us the details of your problem.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply