Symptom
While executing the Task “Release Universal Journals” (aka Data Release Task) the following may happen:
- a time out limit is stopping the program
- Hana Memory limits are ending the execution
OR
- runtime may not fulfill the KPIs defined
Root Cause Analysis made by you or by SAP Support showed that a certain SQL statement reading from a certain CDS view can be optimized by database hints. For more information regarding hints, refer to KBA 2142945 - FAQ: SAP HANA Hints. This KBA aims to give guidance on how to maintain the recommended hints and give background information for ongoing system operations with the chosen settings.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
- S/4HANA Finance for Group Reporting Private Cloud Edition
- S/4HANA Finance for Group Reporting On Premise
Keywords
Performance, CDS Views, HANA Hints, Group Reporting, S/4HANA Finance, Release of Universal Journals, Data Release Task, HANA Memory, DBSQL_SQL_INTERNAL_DB_ERROR, CX_SY_OPEN_SQL_DB , KBA , FIN-CS-COR-DT-RUJ , Release Universal Journals , FIN-CS-COR , S/4HANA Financial Consolidation, Core Processing , FIN-CS-COR-DT , Data Transfer , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.