Skip to Content

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.