Delta from ODS to cube/ODS red

[marco_ballarini]

My problem:

this morning an infopackage loading from ODS took a long time. The status of loading was yellow.

From sm66 trans. I killed the processes and from sm58 I force the Idoc post with "execute luw".

Now the 3 data target (1 cube and 2 ODS) have the data required, I changed the QM status of the request into data target, but when I open the infopackage I obtain the error "Delta request REQU_20F1UHOI0CXZ4IZUXBCMQVZMV is incorrect in the monitor. A repeat needs to be requested".

Do I have to set the QM status to green in the monitor of infopackage?

This message appear when I click on the staus button:

"If you set a 'red' delta upload to green,with the next request, BW sends a delta request,to the source system and this delivers the next delta data. The data from the 'red' delta load is then no longer available(even with a repeat). This can lead to loss of data. Do you want to execute a QM Action?"

Thanks in advance

Gianni

[Former Member · Accepted solution]

Hi its a generic message whenever u change the status in process monitor.

mandatory things are "make the status as red in process monitor."(ie status not okay)

Delete the request from data target.

run the infopackage --system asks request again with the message -say yes and ur done..

The repeat run will fetch the delta data records of last delta...

Regards,

RK

[marco_ballarini · Accepted solution]

But the requests on data target are already loaded in other data target.

I work with BW 3.5.

My question is:

If I change the QM status on Infopackage Monitor, the delta will work fine the next time?

Gianni

[Former Member · Accepted solution]

Delta is always picked from changelog table so there won't be any issue with deltas.

Now since you say you are loading data from one dso to multiple targets.

In this scenario:

Just ensure that the last request which is loaded successfully to all the data targets .If not say one of the request loaded to one target was successful but had failed or stuck in load to another target.

In this scenario.:

Say request of date 15.06.2009 has been loaded successfully to all targets.Then delete the request of 16th and onwards from all the data target after making their status red in process monitori.e. status not okay (very very important--).

Even if the request was loaded successfully to one target and unsuccessful to another.

So now you have the same last request successfully loaded to all targets.

Now when you will run repeat delta with your same infopackage the changelog table will fetch the correct delta records to all the data targets.It will work fine.

In anycase If you break the delta mechanism between dso and infocube ,you don't need to worry.Just refer my thread:

https://www.sdn.sap.com/irj/scn/profile?userid=3825137

Regards,

RK

[marco_ballarini · Accepted solution]

I solved my problem.

Many many thanks!

Gianni

[Former Member]

Right, you should not change the QM Status to green in DSO or Cubes. It will never work out well. aybe you still have the data available in the PSA. Check this and if, then delete the requests from all data targets and schedule the load from PSA. If the data is correct, it should be ok. If you are not sure about this, try to do it in DEV-System.

[Former Member]

Look the below blog on SDN.

/people/aaron.wang3/blog/2007/04/11/repair-bad-data-and-subsequent-data-targets-with-delta-update

Hope this helps !