Delta Loading BW - using timestamp method via ODP datasource from Calculation view throws error

[former_member193630]

All

Here is the scenario, where I am getting short dump in BW, while loading Delta from an ODP datasource ( which is from a Calc.View ) and the delta is based on Timestamp.

Scenario:

--------------

I have a simple table with Field_one (char), Field_two(char), Num_point (integer) and Timestamp (Timestamp)

I have created a Calculation view on top of above table.

Since I want to consume this in BW, hence created a ODP datasource on top of this Calc.view with below settings:

Generic Delta = "Timestamp - short" and Delta Field = "Timestamp" and Timezone = UTC

After creating infopackge and loaded 'init with data', it has loaded successfully.

Whereas when i tried to do a delta load, it shows the error message as below and short dump with MESSAGE_TYPE_X.

"Inconsistency in delta administration. See long text" with below long text.

Diagnosis

The delta administration for DataSource GK_TS_V1 from the source system DHFCLNT100 is inconsistent.

The table RSSDLINIT in the BW system contains at least one entry for initialization. However the table ROOSPRMSC in the source system does not contain any entries for this DataSource in this source system.

Procedure

The following SAP Notes describe the state mentioned above and explain how to resolve the situation:

873694 873401 852443

I have gone through the notes given above, nothing is of use for me.

However, interestingly with the same Calc.view, when i tried delta with "NumericPointer" method its working fine.

Any help is greatly appreciated.

Thanks

Gopi.