SAP Note 1975448 - Problems due to Late Materialization and chunk-wise Data Processing

Component : SAP HANA Database -

Solution : https://service.sap.com/sap/support/notes/1975448 (SAP Service marketplace login required)

Summary :
This SAP Note discusses issues related to ABAP dumps, SQL and DB failures in SAP HANA, such as UNCAUGHT_EXCEPTION, DBIF_RSQL_SQL_ERROR, and issues during SQL operations on tables causing log entries about SQL errors and transaction rollbacks. It details errors in late materialization and chunk-wise processing. The note outlines how using late materialization can optimize memory usage by processing data based on IDs and columns, but may lead to inconsistent page sizes and other issues. Solutions include adjusting late materialization thresholds and chunk sizes and clearing the SQL plan cache to ensure changes are recognized, while cautioning about potential increased memory demands and performance impacts.

Key words :
cx_rsr_propagate_xabap program           cl_rs_base====================cp category               installation errorsruntime errors         dbif_rsql_sql_errorexcept, customer component han-db sap hana database priority correction, alter system recompile sql plan cache entry '<plan_id>', log by2=> sql error 129 performing exe [dbds 712], medium priority category program error validity, category               abap programming errorruntime errors         uncaught_exceptionexcept, heap area pool/joinevaluator/jerequestedattributes/results, log by4=> sql error 287    performing upd, alter system clear sql plan cache, __%pdfstyle%__ / } symptom abap dumps

Related Notes :

2003736SAP HANA SPS 07 Database Revision 74