Delta update to the cube not possible because there is a request in the cub

[Former Member]

Hi BW Gurus,

Have a problem here..

I had deltas PSA->DSO->Cube

All loads were deleted from PSA by mistake

I did a FULL REPAIR load to PSA.

Then INIT without data transfer (deleted old init first).

Then FULL REPAIR PSA-> DSO (was ok).

Then FULL REPAIR DSO->Cube (was ok)

Daily deltas are in process chain, but it is disabled for now. I wanted to test manual loads first.

So, manual delta to PSA is ok.

Manual Delta PSA->DSO ok

Delta DSO->Cube does not work.

Error is ;

'The last delta update was incorrect !

Therefore, no new delta update is possible.

You can cancel the request or:

Attempt to load the data of the last delta update again'..

If I request again, it says that Cube still includes delta request xxx.

I went to RSRQ and put red in monitor and in request and deleted it from the cube. Repeated again. Got the same error. It looks like I did NOT delete it.. And I can not say where it is coming from , can't see it in DSO.

Please advise what to do now.

Thabnks in advance

Olga

[anindya_bose · Accepted solution]

Hi Olga

Check this note carefully and let us know if it helps..

https://service.sap.com/sap/support/notes/1607601

I was wondering what flow you have? BW 3.5 right? got confused as you mentioned DSO ( expected ODS in 3.5)

Regards

Anindya

[Former Member · Accepted solution]

Yes, it is 3.5, sorry..

[Former Member · Accepted solution]

Hey..

So you are running entire data from ECC to BW through full repair..right?

As you are loading entire data again..have you deleted data from DSO and Cube before you load full repair?

and how many records you have in Full Repair Request?

Do you have any old request in your Cube?

You know the steps to make full repair request right? I mean before running full load IP, in menu bar we will have option"Repair full".we need to check this option and save.Now we need to run the IP.

Regards,

Venkatesh

[Former Member · Accepted solution]

Hi

If you have less no of records in full repair request and this is the only request you have in CUBE, follow the below steps

before starting the below steps, delete your old init.

1) Delete entire Cube contents

2) right click --> delete contents and click on yes.

3)In this screen(you want to keep data in dimension tables) click on No.

4) now run the init IP with data transfer option.

If you want to test your delta, run the delta IP it should get successful by picking 0 records.

Regards,

Venkatesh.

[Former Member · Accepted solution]

Hi Venkatesh

yes, I run Full Repair (about 3mln records) from ECC. I've dropped all data from the Cube. ODS is in 'overwrite mode' as I understand, so, I did not delete data from the ODS. Yes, I checked this losd as 'full repair' in the scheduler...

Olga

[Former Member · Accepted solution]

Hi,

If I run INIT with data transfer options, will there be duplikates in PSA, ODS?

Thanks,

Olga

[Former Member · Accepted solution]

Hi,

As you have DSO in between I don't think there will be any problem of duplication due to delta init.

Regards,

Durgesh.

[Former Member · Accepted solution]

Hey!

Everything works! Thank you!

1) Full Repair to PSA

2) Full Repair PSA->ODS

3)Dropped ALL data from the Cube

4) Deleted old INIT in 'Scheduler' and run 'INIT with data transfer' ODS->Cube

I ran all deltas manually, every is ok.

Ran again in process chain, everything works fine.

Thank you so much!

Olga

[Former Member · Accepted solution]

Hi Olga,

That's great.

Regards,

Venkatesh

[former_member188080]

Hi Olga,

just go to RSMO and go to selection and select the 8DSO Infosurce and select request since it failed..put this date selection..

there will be some yellow or red request last...

just select that if yellow make it red by going to status tab there..double clieck on those staus button and make it red..refresh whole request will become red..

just rerun the delta package..it shd work..

then in case required reinit..

Thanks and regards

[Former Member]

The point is that when I load delta from DSO to Cube, I can not load delta request 41153, because delta request 41158 was not loaded correctly. Ican't see 41158 in DSO, DSO has 41153. And obviously I can not delete 41158 ..