LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  CLI2: BADBUFRQ(302): Invalid buffer size

    Employee
    Posted 01-12-2012 13:16

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Kathleen McGuigan

    Hi,

    I am getting this error while trying to run a large query against a Teradata database. It has multiple case statements which I have aleady split in two pieces without success.

    I found that SAS has had the same problem interfacing with Teradata:

    Using SAS/ACCESS Interface to Teradata to pass an SQL statement longer
    than 32K in length will result in the following error:

    CLI2: BADBUFRQ(302): Invalid buffer size

    From: http://support.sas.com/kb/12/478.html

    For now, I am exporting the data and importing into the graph but I would like to run it using Lavastorm. I am using v 4.5.2.0

    Thank you.
    Kathleen


  • 2.  RE: CLI2: BADBUFRQ(302): Invalid buffer size

    Employee
    Posted 01-17-2012 16:22

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    This has been resolved.

    The query in question had 500 extra blanks on the end of each line.. the 'file' was 200k when it could/should have been only 20k.

    I used the attached graph to fix the two queries.
    Attachments:
    rtrim.brg