Check the size of the MAXIMUM_SIZE_OF_ROW_STORE parameter. Make sure you have not exceed either the physical RAM, allocated RAM, or the size of the parameter. Keep in mind that columnar databases are an old type of legacy database that was replaced with relational databases more than 40 years ago because of these memory issues. Instead of finding data by unique identifiers, they search through all the data using columns on every execution. The size of the data in memory can easily exceed the physical RAM, allocated RAM, or the size of the parameter. IBM has this same issue with DASHDB/DB2 WAREHOUSE. It seems that the lessons of the past have been forgoten are being repeated in the present. To prevent the issue simply plan the size of the RAM and parameters to be larger than the largest possible execution or larger than your data times the number of concurrent users. Since SAP Hana S4 is an in-memory database that uses column store, it can exceed the size of the data. Also, you may want to check if the database can exceed the 32-bit memory limit of 2GB, the old limit from 40 years ago. Most of the legacy technologies have the legacy memory limitations. For example, a tabular database has a 2 billion minus 3 record limit. Some of the old columnar databases had a 2GB hard limit for the size of the query itself, or the return of the data from the query. Since this error is reproducible on every column store database, it's likely that HANA has the same limitation. (ERROR CODE 2048 = the old 32-bit 2GB memory limit of columnar databases). (See database history on Edgar F. Codd and ACID compliant databases systems) https://help.sap.com/viewer/7c78579ce9b14a669c1f3295b0d8ca16/Cloud/en-US/20a760537519101497e3cfe07b3...
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.