cancel
Showing results for 
Search instead for 
Did you mean: 

Immediate help Delta load now green but data mart status and report sign no

Former Member
0 Kudos

I have the zo ods for "item" which feeds the another "status" ods with delta load and then update to cube. i have the delta load success green in "Item" Ods but when it update to "Status" ods request is green but not reportable and not updated to cube it is running from 30 mins please tell how to fix this since user is waiting for the result. please tell me exact steps

soniya

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

if status is green did you see in a PSA processing number of records, any number of records in PSA. check in sm37 and sm50 to see your job is still running or any process in sm50.if job is finished and data is loaded in item ODS try to manually activate the request in ODS 1.

data will not be able to load in to the cube unless it is availbale and activated in the item ODS object.

see the lock in SM12 or any shortdump n ST22.

Thanks

Qandeel

Former Member
0 Kudos

Delta Request Data in Item Ods is already activated and green but now when it goes to Status ods it is not getting the reportable symbol but request is green . please suggest

Former Member
0 Kudos

Hi soniya,

From Tcode RSD1 select ODS and insert your ODS --> display. In the next screen open Parameters and check if "Reporting BEx" has flag: if you do not have this flag this ODS is only for upload of data and transfer of the same to other objects.

If you have this flag in RSA1 right mouse click on ODS --> Manage --> Tab request --> select your request --> select Activate.

If nothing chenges look in ST22 or SM21 if you got dump. Maybe is a problem of memory space, in this case you need to enlarge Table Space (ask your basis team).

Ciao.

Riccardo.

Former Member
0 Kudos

Hi,

Check if the ODS is set up for reporting and also if the request is activated.

Also, check if the SM37 job has finished processing, even if the request is showing green.

Cheers,

Kedar

Answers (0)