Navigating the Latest Bug Fixes in SAP HANA 2.0 SPS7 Rev 78 and 79: Essential Updates Before Upgrade

[A_ER]

SAP HANA continuously evolves, and recent updates in version 2.0 SPS7 Rev 78 and 79 bring critical bug fixes that can impact your environment. Below, we highlight notable issues addressed, along with their corresponding SAP Notes and applicability, to help you evaluate your upgrade path.

Category	Issue Number	Description	SAP Note	Fixed in Rev	Parent Note	Applicability	Affected Release/ Version
BW/OLAP	310837	Fixed an issue that caused the BW query to fail with the error message "Failed to lookup path '$transient_path,B<n>': calcEngine search on olapIndex failed" as a result of incorrect handling of the hierarchy join attribute during the optimization process.	3466327	78	https://me.sap.com/notes/3447850/E	BW	SAP HANA 2: Revisions <= 059.12 (SPS05) Revisions of SPS06 Revisions <= 077.00 (SPS07)
	322338	Fixed an issue that could have caused a query to fail with the error 'Attribute Engine method not implemented' when OlapEngine joins on TIMESTAMP type attributes with compressed attributes. This issue can be worked around by using "WITH HINT( NO_USE_OLAP_PLAN )".		78	https://me.sap.com/notes/3447850/E	BW	SAP HANA 2: Revisions <= 059.12 (SPS05) Revisions of SPS06 Revisions <= 077.00 (SPS07)
Data Provisioning	323021	Resolved missing records after data load with ODataAdapter and SAP SuccessFactors remote source.	3453818	78		SF to BW	SAP HANA 2.0 SPS 06 (2.00.067.00)
	323380	Fixed incomplete data issue with SuccessFactors API for SAP BW Extraction.	3456531	78		SF to BW	SAP HANA DATABASE Version 2 2.00.076
High Availability	318016	Fixed race condition preventing SQL port opening after timetravel.		78			SAP HANA 2: Revisions <= 059.12 (SPS05)
	320246	Resolved long HSR takeover times leading to errors when primary remained in "stopping" state.		78			SAP HANA 2: Revisions <= 059.12 (SPS05)
Scale Out	317146	Fixed landscape redistribution failure with HDI tables.	3410692	78			SAP HANA 2: Revisions of SPS00 - SPS06 Revisions <= 077.00 (SPS07)
Smart Data Access	286631	Fixed indexserver crash when a federated query was canceled.	3467714	78		sda	SAP HANA 2: Revisions of SPS00 - SPS04 Revisions <= 059.12 (SPS05) Revisions <= 077.00 (SPS07)
	313635	Fixed PSE encrypted SDA connections failure.	3397488	78	s4,bw	sda	SAP HANA 2: Revisions >= 070.00 (SPS07)
	321175	Resolved hanging issue during thread callstacks collection from third-party libraries.	3439753	78		thread locking situation	SAP HANA 2: Revisions 071.00 - 077.00 (SPS07)
XS Engine	322233	Fixed potential deadlock in threads from xsodata batch requests.		78		BW
General	287968	Resolved indexserver failure on startup after upgrade due to unregistered conversion rates provider.	3326809	78		all indexserver	SAP HANA 2: Revisions (SPS01 - SPS05) Revisions <= 066.00 (SPS06)
	297054	Fixed crash at ESStatistics check for invalid log_mode value.	3284126	78		all log_mode	SAP HANA 2: Revisions of SPS03 Revisions of SPS04 Revisions <= 059.13 (SPS05) Revisions of SPS06 Revisions <= 077.00 (SPS07)
	310220	Fixed long execution times for Savepoints with HANA Fast Restart Option.	3466826	78		all Savepoint Slowness	Affected Releases: SAP HANA 2: All Revisions of SPS04 Revisions <= 059.12 (SPS05) All Revisions of SPS06 Revisions <= 077.00 (SPS07)
	311518	Fixed auto delta merge failures due to outdated CPU load checks.		78			< 2.00.058.00
	318143	Resolved webdispatcher crash when changing profile parameters.	3416859	78		all HANA Web Dispatcher	SAP HANA 2: Revisions of SPS00 - SPS04 Revisions <= 059.12 (SPS05) Revisions of SPS06 Revisions <= 077.00 (SPS07
	319152	Removed confusing error message after upgrading HANA revisions.		78
	319313	Fixed issues with statements not being canceled properly.		78		all Cancel requested	< 2.00.078.00
	320559	Fixed issue with alias name insertion in base aliases setting.		78			< 2.00.078.00
	321431	Fixed invalid column name error during query optimization.		78			< 2.00.058.00
	321579	Fixed delayed delta merges causing garbage collection issues.	3449331	78		all Delta Merge	SAP HANA 2: Revisions of SPS00 - SPS04 Revisions <= 059.12 (SPS05) Revisions of SPS06
	321748	Fixed incorrect TSTMP_IS_VALID function results for leap day timestamps.		78			< 2.00.078.00
	321758	Fixed assertion failure when handling NULL values in the ESX engine.		78			< 2.00.078.00
	321773	Fixed long takeover duration on secondary site during ongoing table compression.		78			< 2.00.058.00
	321905	Resolved long query runtimes on column store tables with concatenated indexes.		78			< 2.00.078.00
	322463	Fixed indexserver crash at TREX search add operation.	3471504	78		all indexserver	Affected Releases: SAP HANA 2: Revisions of SPS00 - SPS06 Revisions <= 077.00 (SPS07)
	323800	Fixed indexserver crash due to allowed rowcount discrepancy.	3462484	78		all indexserver	SAP HANA 2: Revisions of SPS00 - SPS04 Revisions <= 059.13 (SPS05) Revisions of SPS06 Revisions <= 077.00 (SPS07) Prerequisites:
	321503	Fixed query failure on joined parameterized SQL views.	3483974	78			SAP HANA 2: Revisions <= 077.00 (SPS07)
	323344	Fixed indexserver crash related to synchronization locks on IBM Power architecture.		78			< 2.00.058.00
	320762	Fixed suboptimal insert performance with Inverted Individual indexes.		78		All	< 2.00.078.00
	319948	Fixed mem_phys value not refreshing in M_HOST_INFORMATION with cgroups-v1 enabled.	3452648	78		all IBM Power machines	RHEL8.x: impacted RHEL9.x: no issue
	319233	Fixed issue preventing LOB cleanup initiation based on global settings.		78		All	< 2.00.058.00
	321696	Fixed memory increase during SQL parsing without proper reclamation.		78		All	< 2.00.058.00
BW/OLAP	322966	Fixed an issue in pruning optimization that could lead to long runtime and high memory consumption for a query.		79	https://me.sap.com/notes/3470932/E	BW
	324526	Fixed an issue that may have caused unexpected query results in the OLAP engine when applying filters to an inner joined table.		79		BW
Backup & Recovery	320536	Fixed an issue that previously caused recovery to fail due to indexserver crash on "Backup::Channel::DecompressionChannel::waitForDecompressionJob()" when out-of-memory events occurred during backup writing.		79		All
	322793	Fixed an issue that caused the recovery of the Tenant DB to fail due to the SSFS access not being initialized.		79		All	affecting to SPS07 only lower than revision 78
	323138	Fixed an issue that caused an indexserver crash with a crashdump when the backup via backint was unexpectedly aborted. The stack trace of the crash was similar to: "Double concatenation exception throw location: 0: ltt::exception::append_exp 1: Diagnose::ExceptionTransfer::registerException 2: Execution::JobFinalObjectImpl::transferError ... exception: Error during stream send: Error: multistream data transfer terminated during send after transferring ... instead of ... bytes exception throw location: 0: Stream::Multiplexer::doCopy() 1: Backup::BackupSrc_Copier::doCopy 2: Backup::BackupSrc_Copier::doMultistreamCopy 3: Backup::MultistreamBackupCoordinator::run() 4: Backup::BackupExe_Job::run()".	3509465	79		all data compression	SAP HANA 2: Revisions of SPS06 Revisions <= 078.00 (SPS07)
	324556	Fixed an issue that caused hdbbackint files used as pipes of Backint to not be cleaned up after completing or canceling a backup.	3465987	79		all hdbbackint files	SAP HANA 2: Revisions of SPS00 - SPS06 Revisions <= 078.00 (SPS07)
	324910	Fixed an issue that caused an old backup file not to be deleted at the end of backup due to some reference counting issue when it did not reach zero.		79		all
Database Client	323226	Fixed an issue that caused an XA join request to fail when using ECN with the error message: "failed to join XA session due to active user transaction".		79		all	Affected only Hana Cloud Edition
Data Provisioning	314926	Fixed an issue that caused the candidate select function to return all rows from the master data set instead of only returning the rows that matched the break keys when enabled with pre-cleansed data.	3482523	79		all	SAP HANA 2.0 SP05 Rev 59.13 and below SAP HANA 2.0 SP07 Rev 78 and below
Enterprise Search	322672	Fixed an issue that caused the cancellation of ESH queries with an "*" sign to fail with a timeout error.		79		all	have been fixed in 2.00.078 or higher. affected to SPS07 only lower than revision 78
High Availability	297664	Fixed an issue that could have caused the nameserver service to not respond to requests anymore due to exhausting its threads. This could have occurred on hosts where one or more filesystems had been mounted that did not respond to a "stat" call.	3434285	79		all nameserver	SAP HANA 2: Revisions of SPS00 - SPS04 Revisions <= 059.10 (SPS05) Revisions <= 067.03 (SPS06) Revisions <= 073.00 (SPS07)
	322107	Fixed an issue that caused the host failover to the standby node to fail, due to the old coordinator not responding to the timestamp synchronization request, causing post-commit operations to be blocked.		79		all
Live Cache	322905	Fixed an issue that could have led to an indexserver crash at OMS_Hash due to the exception "Cannot delete Block [...] (maybe double delete)" caused by a rare race condition when running liveCache SAPAPO_CLEANUP.		79		all	Issue has been already fixed in SPS05 revision 058 or higher
Scale Out	322580	Fixed an issue that caused a table redistribution to fail with the error "replica index does not exist" when the table contained a column of type TEXT and there was a FULLTEXT index on that column.		79		S4,BW,PW	fixed in 2.00.078 or higher Affecting to SPS07 only lower than revision 78
Security	322110	Fixed an issue that caused unexpected performance when granting privileges on schemas in data warehouse scenarios.		79		all	issue has already been fixed in SPS05 revision 058 or higher
Smart Data Access	306575	Fixed an issue that prevented cancellation in certain timing scenarios if the remote statement execution did not reach the remote server (for example, in the Federation layer, in the client, on the network).		79			Affected only Hana Cloud Edition
	322428	Fixed an issue that caused the linked database feature to fail with the error message "SAP DBTech JDBC: [7]: feature not supported: Linked Database feature not supported on this remote source" for a Google BigQuery remote source when several catalogs were available.		79			HANA 2.0 SPS05 or higher. Relevant fixes have been implemented in 2.00.059.13 or higher.
	324712	Fixed an issue that led to an indexserver crash due to the presence of invalid characters in the remote table intended for replication.	3475314	79		all indexserver	SAP HANA 2: Revisions of SPS00 - SPS04 Revisions <= 059.13 (SPS05) Revisions of SPS06 Revisions <= 078.00 (SPS07)
	325214	Fixed an issue that could lead to the error "Failed to create virtual table: cannot use duplicate table name: LT0000000000000000" when using the linked database feature.		79			Reported from HANA 2.0 SPS05 or higher, Relevant fixes have been implemented in 2.00.059.13 or higher.
Smart Data Integration	324674	Fixed an issue related to SAP HANA Smart Data Quality (SDQ) Match candidate selection.	3482523	79		all	SAP HANA 2.0 SP05 Rev 59.13 and below SAP HANA 2.0 SP07 Rev 78 and below
Supportability	324622	Improved the format used to store error messages that are returned by the technical consistency check in the column 'ERROR_MESSAGE' of the monitoring view 'M_CONSISTENCY_CHECK_HISTORY_ERRORS'. The error message might have contained redundant line breaks.		79		all	Reported in SPS06 or higher, and have been fixed in 2.00.078 or higher
	303777	Fixed an SQL performance issue related to SQL queries with CAST or SUBSTRING predicates when an argument of those SQL functions was a column of a remote data source and the ABAP VARCHAR mode was enabled.	3333831	79		Near line Storage- BW External remote non-HANA data source	SAP HANA 2: Revisions of SPS06 Revision = 070.00 (SPS07)
	316947	Fixed an issue that caused long query runtime and high memory consumption when using 'count(distinct)'.		79			Affected only Hana Cloud Edition
	318529	Fixed an issue with the Query Optimizer where evaluations of a function were missing support for a data type.		79			Affected only Hana Cloud Edition
	318908	Fixed an issue that caused small column store tables to experience increasing disk size consumption in 'M_TABLE_PERSISTENCE_STATISTICS'.		79			Affected only Hana Cloud Edition
	319110	Fixed an issue that could lead to an indexserver crash at "Task::TaskOperationStatistics::getTaskStatus".		79			Affected only Hana Cloud Edition
	320157	Fixed an issue that led to a secondary indexserver crash with the error message "Assertion failed: m_pEncryptionManager->encryptionActive(getLoadOrFlushSavepointVersion()) == isFlushEncrypted()".	3442541	79		all HANA secondary indexserver crashes	SAP HANA 2: All Revisions of SPP06 Revisions <= 078.00 (SPS07)
	322172	Fixed an issue that caused unexpected results when using the group by clause in queries on remote sources.		79			Affected only Hana Cloud Edition
	322197	Fixed an issue that caused the planning engine thread to stay in "Running (CANCEL REQUESTED)" status for a long time, even after the job had been canceled from the application.	2987850	79		all	SAP HANA 2: All revisions of SPS05 - SPS06 Revisions <= 078.00 (SPS07)
	322361	Fixed an issue that caused memory to remain in the 'Pool/JoinEvaluator/JERequestedAttributes/Results/Latemat' allocator after exporting a column store table as CSV.		79		all
	322730	Fixed an issue that caused the index server to crash when accessing the monitoring view 'M_TEMPORARY_VIEW_COLUMNS'.	3485471	79		all Indexserver M_TEMPORARY_VIEW_COLUMNS	All revisions of SPS05 – SPS06 Revisions <= 078.00 (SPS07)
	323102	Fixed an issue that could have led to an indexserver crash due to garbage collection after the DDL execution of altering a table.		79		all	Reported from HANA 2.0 SPS05 or higher, but the relevant fixes have been implemented in 2.00.059.13 or higher.
	323635	Fixed an issue that caused the query on table function to fail with an assertion error.		79			Affected only Hana Cloud Edition
	323875	Fixed an issue that caused the indexserver to not start up with "Missing savepoint/snapshot record for savepoint/snapshot ID".		79		all	reported from HANA 2.0 SPS05 or higher, but the relevant fixes have been implemented in 2.00.059.13 or higher.
	324657	Fixed an issue that caused the indexserver to crash on "ESX::EsxFieldExpressionTrexTypes::FixedAttributeValue8::evaluate" due to incorrect type casting.		79			Affected only Hana Cloud Edition
	325035	Fixed an issue that caused DML statements to unexpectedly fail with the error message: "inserted value too large for column".	3471848	79		all DML	SAP HANA 2: Revisions <= 059.13 (SPS05) All revisions of SPS06 Revisions <= 079.00 (SPS07)
	325369	Fixed an issue that could have caused an indexserver crash at "JoinEvaluator::CJEGraph::effectMove" during the creation or alteration of a complex view.	3482555	79		all indexserver	SAP HANA 2: Revisions of SPS00 - SPS06 Revisions <= 078.00 (SPS07)
	322999	Fixed an issue that caused a catalog import to hang after an error occurred while importing a table.		79		all
	323230	Fixed an issue that caused no entries to be written in 'M_SERVICE_THREAD_SAMPLES' due to a missing service reconfiguration.		79			Affected only Hana Cloud Edition
	316442	Fixed an issue that caused unexpected results when sorting in the Row engine and ESX engine using the locale parameter.	3501346	79		all	SAP HANA 2: Revisions of SPS00-SPS06 Revisions <= 078.00 (SPS07)
	323024	Fixed an issue that could have caused tables with no data in any main fragment of their partitions to be skipped by the NSE Advisor.	3475978	79		NSE Advisor	SAP HANA 2: Revisions of SPS00 - SPS04 Revisions <= 059.13 (SPS05) Revisions of SPS06 Revisions <= 078.00 (SPS07)
	324780	Fixed an issue that caused the particular column and the UT metadata check to fail during an import with mismatching ids when the column contained whitespaces at the end of the name.		79		all	known issue in HANA 2.0 SPS5 Rev59.09 reported from HANA 2.0 SPS05 or higher