Input buferring

ralleo · Post by **ralleo** » Wed Jan 17, 2007 6:31 am

Hi Guys,

I am trying to view a sequential file and I get the error message "input bufferring" with no rows displayed in a parallel environment. File is a comma delimited file with a unix line feed.

However using the same sequential file, I can view this data in a server environment.

Any clues.

Thanks

Ritchie

DSguru2B · Post by **DSguru2B** » Wed Jan 17, 2007 7:50 am

Can you please post the complete error message. Doing a copy paste of the message usually helps.

ralleo · Post by **ralleo** » Wed Jan 17, 2007 9:44 am

DSguru2B wrote:Can you please post the complete error message. Doing a copy paste of the message usually helps. ...

The error message is as follows:

No rows were returned from view data

DSProjectMapName
##W TOIX 000000 15:36:51(000) <CustFile,0> Input buffer overrun at field "Postcode"
##W TOIX 000154 15:36:51(001) <CustFile,0> Import warning at record 0:

However, I have found the problem and fixed it. It is to do with the formatting at record level, i.e final delimiter=end has to be used as well as record delimiter = UNIX new line .

Thanks

Ritchie

ArndW · Post by **ArndW** » Wed Jan 17, 2007 10:15 am

The error message goes a long way to explaining your problem. Your metadata for "Postcode" specifies a length that is shorter than the actual data contents for the field, hence the error message.

ralleo · Post by **ralleo** » Wed Jan 17, 2007 10:40 am

ArndW wrote:The error message goes a long way to explaining your problem. Your metadata for "Postcode" specifies a length that is shorter than the actual data contents for the field, hence the error message.

Thanks for the info.

Ritchie

ArndW · Post by **ArndW** » Wed Jan 17, 2007 10:41 am

I guess in your case the postcode field was the last one in the row, which is why the error disappeared when you changed delimiter settings.

ralleo · Post by **ralleo** » Wed Jan 17, 2007 10:41 am

ralleo wrote:
ArndW wrote:The error message goes a long way to explaining your problem. Your metadata for "Postcode" specifies a length that is shorter than the actual data contents for the field, hence the error message.
Thanks for the info.

Ritchie

However, why does it work in server environment and not parallel environment

DSguru2B · Post by **DSguru2B** » Wed Jan 17, 2007 10:49 am

Different engines, different methadologies. PX has a stronly typed language like C. It is particular about variable meta data which for us is column metadata.

ralleo · Post by **ralleo** » Wed Jan 17, 2007 11:03 am

DSguru2B wrote:Different engines, different methadologies. PX has a stronly typed language like C. It is particular about variable meta data which for us is column metadata. ...

Thanks for for expanding on that.

Ritchie