How to solve the problem with the EXX110 error that occurs when building a recommendation model?

Question

SAP

When I try to build a recommendation model using the /api/analytics/recommendations/recommender/sync resource, I get the following message:

{
  "errors": [
    {
      "errorCode": "EXX110",
      "errorMessage": "An SQL error has occurred."
    }
  ]
}

Here is what is indicated in the aac4paservices application log:

2017 05 14 15:28:40#+00#ERROR#com.sap.analytics.cloud.helper.JDBCDriverExceptionHandler##anonymous#http-nio-8041-exec-5#na#p1942899535trial#aac4paservices#web#p1942899535trial#An SQL error has occurred.com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [2048]: column store error: search table error: [1000002] exception 1000002:
ltt/impl/memory.cpp:86
Allocation failed ; $size$=1573055; $name$=ihm; $type$=pool; $inuse_count$=678; $allocated_size$=1066531290
exception 1000002:
ltt/impl/memory.cpp:86
Allocation failed ; $size$=1573055; $name$=ihm; $type$=pool; $inuse_count$=796; $allocated_size$=1252151780

I believe the reason is that the resource call requires too much memory. What can be done to solve this problem? I called a resource on a dataset based on a 75 megabyte table. I created a dataset based on a 2 megabyte table, but the result is the same. Only if I pass the period parameter to the /api/analytics/recommendations/recommender/sync resource and limit it to a few days, do I get a successful response.

Answer 1

It shouldn't be like that.
I correctly understand, what the table at you not column and records 110000? This is nonsense even for a trial account.
Try
a) to make sure that the table is columnar, if not - copy the data like create column table my_new_table as (select * from my_existing_table) or CREATE COLUMN TABLE ... LIKE WITH DATA or in another way
b) check the data for correctness and completeness, so that the date everywhere was a date with the date type :), there were no empty lines
c) try to slip it a view, not a table. But after a and b.
Send, plz, a couple of lines of data