Skip to Content
0

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

Apr 12 at 10:04 AM

35

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Joachim Dürr Apr 12 at 11:21 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Michael Loop
Apr 12 at 07:14 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Jim Cookson Apr 12 at 11:27 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded