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
Input buferring
Moderators: chulett, rschirm, roy
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
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
However, why does it work in server environment and not parallel environmentralleo wrote:Thanks for the info.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.
Ritchie