Warning in Director

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
madhavamaganti
Participant
Posts: 21
Joined: Thu Jun 25, 2009 10:28 am
Location: Andhra Pradesh

Warning in Director

Post by madhavamaganti »

Sequential_File_0,0: Input buffer overrun at field "Sale_Date", at offset: 0.

The above warning is coming while i am running job.

To solve, the above warning..please help me.
Madhava
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

It might be a metadata issue!
Check your metadata and the original data in the sequential file.
pandeeswaran
madhavamaganti
Participant
Posts: 21
Joined: Thu Jun 25, 2009 10:28 am
Location: Andhra Pradesh

Post by madhavamaganti »

dont mine, give some more clear and solution to solve that warning.
Madhava
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What do YOU understand by this error message?

Even from the sparse information you have provided I can tell that the error was thrown in the first line of the file (offset 0) and that there were more bytes in that line than the metadata specify. Chances are that you need to, but have not, specified First Line is Column Headings.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
prakashdasika
Premium Member
Premium Member
Posts: 72
Joined: Mon Jul 06, 2009 9:34 pm
Location: Sydney

Post by prakashdasika »

It is intresting to see people demanding answers as if this is a tutorial. The forum is to suggest and discuss datastage issues. The reply from pandeesh is apt. It would be nice to learn some courtesy.
Prakash Dasika
ETL Consultant
Sydney
Australia
BI-RMA
Premium Member
Premium Member
Posts: 463
Joined: Sun Nov 01, 2009 3:55 pm
Location: Hamburg

Post by BI-RMA »

prakashdasika wrote: The reply from pandeesh is apt. It would be nice to learn some courtesy.
pandeesh is trying to give you a hint as to what the warning might mean. This is by no means uncourteous! It remains up to you to check your specific data and stage-configuration, since we haven't got access to it.
As to your last sentence, I agree entirely. :)
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
djbarham
Participant
Posts: 34
Joined: Wed May 07, 2003 4:39 pm
Location: Brisbane, Australia

Re: Warning in Director

Post by djbarham »

madhavamaganti wrote:Sequential_File_0,0: Input buffer overrun at field "Sale_Date", at offset: 0.
Your input record is shorter than the definition of the record in your metadata.
Post Reply