Delta load failure for ODP datasource after delta init

[Former Member]

Hello Experts,

We are facing issue in loading delta data after doing delta initialization without data transfer on ODP datasource.  Actually we are trying to load data from one infocube of BW system on Oracle database(BOO) to respective cube of BW system on HANA database (BOH). We have created an ODP datasource in BOH system for the respective cube of BOO system and created transformations with one to one mappings to the cube in BOH system, and now trying to load data in below two scenarios.

Scenario 1:

Where there is few amount of data in BOO cube(Source), running Detla DTP and the data load finishes fine to BOH cube. And also the next delta load runs fine and loads data if there is any new data in source(as init happens when the delta is run for the first time) .

Scenario 2: (Facing Issue)

Where there is huge amount of data, we are running full load DTPs based on Fiscal year selection/filter and once all loads are completed successfully and complete data is fetched, doing delta initialization without data transfer after checking there are no more new requests in source after the full load is completed which finishes fine.

And now when trying to load delta DTP when there is new data in source(BOO Cube), the data load is getting failed immediately with the below errors(detail error log also has same info which is mentioned below nothing more to it).

Error while Processing

Exception in Substep Extraction Completed

Processing Terminated

Please provide your valuable inputs and suggestions in getting this issue resolved.

Attached are the error screenshot and version details of both BW systems.

Note:

BOH: BW on HANA database  system (which is Target)

BOO: BW on Oracle database system (which is Source)

Thanks,

Bharath Kummithi

[lucas_oliveira]

Hi,

I'm moving this to space.

BRs,

Lucas de Oliveira