Issue with loading dso to cube - Yellow status

[Former Member]

Hi

i am trying to load dso to cube and my dtp is yellow status for just 3 records.  its not even transferring the data and its not throwing any error but its hanging in below status . cube has line dimension and no locks in the system. i increased the process time and all other check possible. I tried all other option before reaching here. any one has any idea to solve this?

[KodandaPani_KV]

Hi,

have you written any routines like end routine or start routines.

check the have any syntax errors?

or

i can see form  the scrren shot error handling step with stuked.can you check any issues with errors records.

check the job status in SM37.

Thanks,

Phani.

[RamanKorrapati]

Hi Sash,

Lets try to activate Cube, transformations(DSO to Cube) and dtp thru respective programs.

is it full load or delta load?

Can you check your DTP logs at SM37?

As of now, is it still showing in yellow or red?

if its in red then please share the error message or long text from error log.

Thanks

[Former Member]

Hi Sash,

May be there are any lock entries (SM12)  for this cube? if you don't see any entries, check the background job, it might have got stuck (sm37 -->double click the job-->copy the PID number, goto sm66 and see its status) , if it is stopped/error, then change the DTP technical status to Red and delete it. re run the dtp again and check.