Skip to Content

Increase buffer for error: The supplied buffer was insufficient for the information returned

Hi,

Trying to create a view using Advantage Data Architect.

If I run the SQL, data is returned without any errors. Creating as a view, the full error message is:

poQuery: Error 7200: AQE Error: State = HY000; NativeError = 5005; [iAnywhere Solutions][Advantage SQL][ASA] The supplied buffer was insufficient for the information returned. The data may have been truncated.

If I knock some 60 lines off the bottom of the SQL, it creates the view. Is there something I can do to allow the buffer to take more lines?

Thanks for any help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Apr 12 at 11:21 AM

    data truncated is on field level, not on record level. There seems to be a record that produces more content than fits into a field.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12 at 07:14 PM

    The error does seem to be coming from Architect trying to display the resulting view. It is possible that the view is created correctly, but then Architect fails to display the results. If you run the following command in the SQL tool, do you get the correct value for the complete view?

    SELECT View_stmt_len FROM system.view WHERE "Name" = "<YourView>";

    Do you have better luck if you create the view in the SQL utility with the following syntax?

    CREATE VIEW <view-name> AS SELECT <select-spec>;

    Regards,

    Mike Loop
    Senior Product Support Engineer
    SAP Product Support

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12 at 11:27 AM

    Hi, thanks for the reply.

    Returning data from this isn't a problem - SELECT works perfectly well and all the data is returned.

    The problem is when I change the SQL into creating a view. Just adding the lines CREATE VIEW MyView AS generates the error. If I remove 60 lines of SQL, the view creates perfectly.

    Jim.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 14 at 01:53 PM

    I found this Wiki page referring to error 5005: https://wiki.scn.sap.com/wiki/x/pQBuGg. It is talking about Advantage Optimized Filters (AOF), but it implies that there may be a buffer problem in the Tdataset descendants, on which Architect is built. Unfortunately, it doesn't say which versions have the problem or which ones if any have the fix.

    It might be worth finding a third-party SQL tool that is not built on Delphi to see if you can create the view you want. If you are not on the latest Advantage build (currently 12.0 SP2) you might consider testing against the evaluation version.

    If you could provide me with some details of the view you are trying to create (data types, row width, number of rows, etc.) I may be able to reproduce the behavior and submit it as a bug.

    Mike Loop - SAP Product Support

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 14 at 12:46 PM

    Hi Michael,

    Thanks for your reply.

    No, the view isn't created.

    Using the statement

    CREATE VIEW <view-name>ASSELECT<select-spec>;

    is the way that I tried to create the view.

    To get round the problem, I created a number of views looking at views. The result is that the end view is slow but the end users are happy that they have the dataset.

    Many thanks for your suggestions.

    Regards,

    Jim.

    Add comment
    10|10000 characters needed characters exceeded