Data Consistency Regression in SAP HANA SPS06 – Early Revisions
As part of a proactive landscape stabilization initiative, SAP Enterprise Cloud Services has identified a potential issue, that could lead to unplanned downtime or slow performance or non-compliance. These potential issues are tracked as Top Issues by SAP Enterprise Cloud Services and recommendations are shared with customers to mitigate the risk and avoid any business impact.
We are contacting you, because you may have a SAP S/4HANA Cloud system or SAP HANA Enterprise Cloud system impacted by a new Top Issue.
Top Issue Description
Due to a programming error in early SAP HANA 2 SPS06 revisions, the complete SAP HANA transaction is being rolled back instead of a rollback on the statement level in case an enterprise search statement was cancelled previously on the same SAP HANA connection. This issue only applies for the following Revisions:
- SAP HANA 2 SPS06 Revision 60.00
- SAP HANA 2 SPS06 Revision 61.00
- SAP HANA 2 SPS06 Revision 62.00
What is the Business Impact?
Due to this programming error, an incorrect transaction status might be returned to the application level. In the worst case, this might lead to situations where SAP HANA has rolled back changes on the database level, which the application is not aware of. This can look from the application level as an inconsistency in business data while on the SAP HANA database level no inconsistency can be found by the technical consistency checks on the database level as described in SAP Note 1977584. This could lead to potential inconsistency or apparent data loss in business data due to incorrect transaction status.
What are SAP recommendations?
Update to SAP HANA 2 SPS06 Revision 63.00 or higher
Check SAP note 3213111 and 3198962 for more details
What actions SAP has taken to solve this issue?
Standard templates are made available for you on Service Request App to request implementation of the above recommendation.
What action is recommended for you?
Contact your SAP Enterprise Cloud Services Representative to discuss the details of the impacted systems, Target DB version compatibility with existing OS/application and plan the implementation of recommendations.
What will happen if recommendations are not applied?
SAP’s abilities for the provision of support may be limited and System Availability Service Levels may not apply.
If you have any questions, please contact your SAP Enterprise Cloud Services representative.
Thanks.
Rupesh Chavan