Skip to Content
Author's profile photo Antony Jerald J

DTP Pushes zero records from Source – In Hana Optimized DSO’s

There are cases in Hana Optimized DSO’s, where ZERO records been pulled from Source DSO to Target DSO.

Reason, we’ll find ZERO records in Changelog table of source DSO though there are actually requests available in DSO’s.

We’ll face the following errors in Hana optimized DSO at the time of data transferring from source to target:

“column store error: search table error: [41028] DataStoreObject: Query


not supported for the changelog.;Unsupported query on changelog”.


Hence, if you check in Hana studio, you’ll find it’s table as a normal table.  We’ll have to recreate changelog view here.

Go to SE38 in your BW system and run report RSDU_RECREATE_CHGLG_HDB(Program comes as a part of note: SAP Note: 1816581)

(Refer following SAP Notes:

Enhancement of the report RSDU_RECREATE_CHGLG_HDB

0001846967   Change
log of SAP HANA-optimized DSO is inconsistent

the correction is now available. Please implement Note

Recreate changelog as shown below by mentioning it’s DSO name in ODSOBJECT:


The above issue would be overcome if we convert Hana optimized DSO’s to Standard Optimized DSO(Classical DSO)

If any of you have faced such problems, please follow above steps and implement the same 🙂

Will explain converting IMO Dso’s to standard DSO’s in a separate document.

The same conversion of Hana optimized DSO to standard optimized DSO can be done by referring document:


Antony Jerald.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Phani KV
      Phani KV

      Thanks for sharing.



      Author's profile photo Antony Jerald J
      Antony Jerald J
      Blog Post Author

      Welcome 🙂

      Author's profile photo Former Member
      Former Member

      really helpfull for HANA......beginer