Question about delta inistialization

[amine_lamkaissi]

Hi experts,

If someone deleted by mistake the request of delta initialization option for source system. And i recreate this request without data transfert option.

Is there any risk to loose some delta records?

Thanks.

Amine

[karthik_vasudevan · Accepted solution]

Hi Amine

Yes, there is a possibility of missing some delta records, because data created in source system after this INIT will only be fetched during the next Deltas to BW system.

So the transactions created during this time will be lost.

It is also based on the time when the first initialization request was deleted and the next one gets created.

But the more you wait, the more data will be lost. So load init w/o data as you have planned and reconcile the target data to the source.

If any data is missed, fill the setup table accordingly and run a full repair without disturbing the delta records.

Regards

Karthik

[amine_lamkaissi · Accepted solution]

Hi Karthik,

Thanks for your answer.

Can you tell me more about filling the setup table? (standard or custom extractor)

Thanks.

Amine

[karthik_vasudevan · Accepted solution]

Hi Amine

Setup table could be filled only for LIS datasources and below is the document which explains how to do it.

https://scn.sap.com/docs/DOC-58038

If you have any generic datasource, give us the detail of the same. we will see how to proceed further.

Regards

Karthik

[amine_lamkaissi · Accepted solution]

Thanks Karthik,

Just one question. If the init request was deleted and immediatly recreated afterwards.

Is there any risk to loose data?

Amine

[amine_lamkaissi · Accepted solution]

Thanks Karthik,

Just one question. If the init request was deleted and immediatly recreated afterwards.

Is there any risk to loose data?

Amine

[Former Member · Accepted solution]

Hi Amine,

init request (if it is a LIS data source ) will be done during the non-business hours (or) down time, where there are no other posting happen for the respective data source. So to answer your question, there wont be any data loss if you re-doing the inti during the down time.

[karthik_vasudevan · Accepted solution]

Hi Amine

To be precise, it depends on your business. But as you said, its recreated immediately, there is very minute probability of data loss.

But no worries, give it a go and run the delta on its time.

If there is any data mismatch, then we will think about the consequences but am sure it will be very minimal. So don't take tension on a Monday . Leave it till the next delta happens or if any user raises a question

Regards

Karthik

[KodandaPani_KV · Accepted solution]

Hi,

if recreate the immedetely no issue with data.but you need to do  this actvity non business hours and better do in weekends.

if you want reinit again pelase lock the users, user not to do any positing in source side.

better lock the user and take help form the basis team (how to lock the users)

Thanks,

Phani.

[amine_lamkaissi]

Thanks guys for your answers.

There are come contradictory answers, but we will see

Amine

[Former Member]

Hi Amine,

The delta will be lost.even if you have deleted the init and created it immediately.

what ever delta records which were available in the  delta Queue is is not considered for the next delta load when you delete the init. On performing the reinit a new pointer is set. In effect the delta records are lost.

Hence you can wait for the next delta and check whether there is any delta which is missed. if yes then you have to fill in the setup tables and bring the data into BW

Regards

Vivek