Delta load is red?

[Former Member]

Hi,

We are pulling data from the R/3 source system.The data is landed to TWO ODS(O1 and O2) and then again these two loads are taken to one ODS(O3) and then from that ODS we are updating the data to cube.The data updating two ODS(O1 and O2) are deltas.and again from O1 and O2 the deltas are updated to O3.The one of the delta available in O1 ODS is marked as red in the Manage option of the data target.But it is green in monitor.When we tried to click on the QM button in manage option we are getting message

request is allready(partially)activated no: furnther QM action is possible.But the request is marked as red.Can any one help us to understand why the request is red in O1 ods.

Points will be definitely assigned.

[Former Member · Accepted solution]

Hi,

This is becasue the activation didn't happen correctly. Check if the activation job failed with an error and see the cause. Try to activate the request again. If you need to delete the request, you'll need to mark it red in the monitor and then delete it.

Cheers,

Kedar

[Former Member · Accepted solution]

As it is delta allready another delta is piledup over this delta.and in the activation que also it is red.I dont think it will allow for activation.

[Former Member · Accepted solution]

Hi,

If your request is red, it won't activate any requests loaded after that. You first have to fix the red request and then activate the requests piled on top of that.

Cheers,

Kedar

[Former Member · Accepted solution]

Guys I got it.it was because of the activation failure.

[Former Member · Accepted solution]

hi,

first delete the red request and fix the issue in the PSA and load it back to target then do activation.

Ramesh

[Former Member]

Hi

Delete the Red req And reconstruct again and activate the req

IN Reconsruction tab->select the req_.> click on monitor> make the status green>? come back and click on Reconstruct/insert

Regards,

Ogeti

[Former Member]

Hi,

If the request which is showing red is loaded thorugh PSA, then delete this request and reconstruct it. Also be sure if any other requests are present over this even they may get deleted during this Process. Make sure they are all thru PSA, note the request ID's after deletion, reconstruct and then activate again.

Cheers,

Neelesh Jain