Skip to Content
avatar image
Former Member

Wrong number of records loaded from HANA

Hello everybody.

I am facing a weird situation, that seems to me something related to Cache, but I couldn't find the root cause to try to fix it permanently.

I have a daily Dataservices job, that reads data from a Calculation view in SAP HANA and inserts this data into a SQL table.

What happens is that it doesn't load the correct number of records everyday. Some days, it loads the data from the day before, as if it was in cache in Dataservices. If I Preview the data from the calculation view, it shows me the correct records. If I ask to preview the data of this "table" (calc. view) in Dataservices, it also shows me the correct number of records... but when I execute the job, it brings me records that are not present in the calc. view anymore.

To make it work, I have to redeploy the calc. view in SAP HANA and then, when I run the job in Dataservices, it brings the correct records.

Has anyone been through a situation like this?

The environment version is SAP BO Dataservices 4.0 Patch 3.

Thanks and regards,

Cristina

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 03, 2015 at 02:44 PM

    Your version of DS is not supported to work with HANA. Check SAP Note 1600140 (for) - SAP Data Services 4.x and SAP Information Steward 4.x compatibility with SAP HANA.

    Add comment
    10|10000 characters needed characters exceeded