Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

"For All Entries IN" causes short dump when reading from HANA external view

Hi Experts,

in a nutshell:

In ABAP report I use "For All Entries IN" to read data from HANA external view, and FAE causes short dump with DBSQL_SQL_ERROR exception. I have to use ABAP hint: %_HINTS HDB '&max_in_blocking_factor 5&'. Why?


Details:

In HANA I created several calculated view. I exposed these views using external views which I'm consuming in my ABAP report.

Everything was working as I expected until yesterday. From yesterday my report finishes with ABAP short dump like this:

Category           Installation Errors
Runtime Errors     DBSQL_SQL_ERROR
Except.            CX_SY_OPEN_SQL_DB
Date and Time      28.10.2015 09:07:44

Short Text

SQL error "SQL code: 2048" occurred while accessing table "Z079FI_CURR_PO2".

What happened?

Database error text: "SQL message: column store error: search table error:
  [2999] general error (no further information available);Failed to translate
  queryEntries for node CLTTABPROJ_Z079FI_CURR_IZ079FI_CURR_I_ISUB_CAV, reason:
  general error (no further information available"

As far as I know nothing was changed in the database.

In HANA Studio all my views are consistent and Data Preview is returning values.

Even in SAP I can see data from z079fi_curr_po2 in SE16N without problems!

In the ABAP report my SQL statement looks like this:

SELECT *
       FROM z079fi_curr_po2
       APPENDING CORRESPONDING FIELDS OF TABLE lt_tra_isub
       FOR ALL ENTRIES IN ct_data_tra
       WHERE trans_num = ct_data_tra-trans_num.

As you see I use "For All Entries In".

Because short dump gives no information about the cause of error, I started to modify the SQL statement.

Using trial and error method I got the answer. The FAE is the reason of the dump. \

I found an ABAP hint for HANA: &max_in_blocking_factor n& which limits the length of IN lists in the context of FOR ALL ENTRIES to <n>:

SELECT *
       FROM z079fi_curr_po2
       APPENDING CORRESPONDING FIELDS OF TABLE lt_tra_isub
       FOR ALL ENTRIES IN ct_data_tra
       WHERE trans_num = ct_data_tra-trans_num
       %_HINTS HDB '&max_in_blocking_factor 5&'.

Setting the <n> factor to 5 resolved the problem.

Could you please tell my what is wrong or what to check? HANA memory problems or what?

Best regards

Rafal

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question