The activation of a dso request (green) isn't working.

[Former Member]

hello bi gurus, i ran a load in a dso and the loading is completed with green light but when i am trying to activate it, it's not being activated.

there's no response at all. the request remains green, dont go yellow at all to show it's activating.

why this is occuring ?

[Former Member · Accepted solution]

the problem is fixed.

thanks everyone for your reply.

i tried everything u suggested and they didnt work unfortunately.

here i am sharing the method that i applied and worked.

1. right click on dso

1. additional functions
2. generate export datasource

after this i selected the request again and click activate and it worked.

[KodandaPani_KV · Accepted solution]

Hi all,

It is good explanation ,

i faced same problem, with out activation i deleted five requests.

i deleted DTP requests the below tables

RSICCONT    

RSMONICDP    

RSODSACTUPDTYPE   

RSODSACTREQ    

Now its working....

[Former Member]

Hi Akash,

Use the program to activate your DSO Requests RSDG_ODSO_ACTIVATE

Thanks,

Purushotham.

[snitwipro]

If you are trying from process chain, please try once manually from the DSO manage screen. Also check if there are any other requests available in the DSO which are not yet activated. All new requests have to be activated at once.

Sourav

[Former Member]

Hi Akash,

Please check the job log in SM30. You will get some idea. If you are using NLS and you have archived data for the same period then also you might get issue. If not then please provide the job log from SM30 which will clear the picture.

Thanks,

Kamal

[Former Member]

Hi Akash,

Try activating using program RSDG_ODSO_ACTIVATE.

Regards,

Verma

[Former Member]

i am not talking about activating dso.

i am talking about activating a request (manually in the dso) that has been successfully loaded with green status.

[former_member1327384]

Hi,

Try to do a test in RSRV T-Code and check if any inconsistencies. Then go forward if you get any errors.

Regards,

Syed

[former_member188080]

,

Pl check below settings and let me know if it works

transaction RSDG_ODSO_ACTIVATE

Execute transaction "RSSGPCLA".

Set the status of the programs belonging to program classes "RSDRO_ACTIVATE",

"RSDRO_UPDATE" and "RSDRO_EXTRACT" to "Generation required".

Thanks and regards

Kiran

[Former Member]

i tried this. logged out and back in but still not working

[former_member213275]

Hi,

Check background jobs corresponding to activation step and analyse the job log.

Below article explains the job log during activation in DSO and how the settings influence activation performance.

http://scn.sap.com/docs/DOC-12057

Check below link for activation errors in DSO.

http://explore-sapbw.blogspot.dk/2012/01/dso-activation-errors-in-sap-bi.html

Srikanth.

[Former Member]

Hi ,

In the Manage tab of the DSO , near the Load monitor where you can monitor the load status of a request , there is a column  ' Logs'  for DSO -Request Processing . Click on that 'Logs' symbol near the DTP monitor , you will get the details of activation steps from there you can find whether the activation has failed in any step .

[Former Member]

thanks all.

i know how to activate the request. the problem is when i go to activation, select the request and then click start, it doesn't do anything.

when i refresh i dont see any changes. apparently the activation process is kind of disabled or something, it just doesnt work.

the data size is not big, only few thousands records and this is the only one request in the dso.

any idea?

[former_member182470]

Hi Akash,

Thanks for clarifying that you know how to activate. I raised some doubts on your scenario, please answer to them.

Otherwise, please delete the request and reload again to DSO and try to activate it.

Regards,

Suman

[RamanKorrapati]

Hi Akash,

Please check at SM37(in BW server)

Job name: *BI_ODSA*

User id: *

date from 12.07.2013 to today date

status are: Active.

Enter, if you find any job which was still running and check it. if you see any job there that may cause. Please check it.

Have you deleted any request for this DSO before activating??

if yes, that also may cause because previous request may not be deleted completely from back end tables.

if you remembered delete request id name, then need delete that id  from below tables:

RSICCONT,RSMONICDP, RSODSACTUPDTYPE and RSODSACTREQ .

Thanks

[Former Member]

thanks. i tried this in sm37 and i can see nothing in the list but when i check for all the jobs i can see the same request status is shown as cancelled. i deleted that in sm37 and tried re activation the request in dso and then when i went back to sm37 i could see the same request going back to cancelled status. so it looks to me the activation request is being cancelled by something.

yes, i deleted one req before and then deleted manually the new table too.

also when i checked those table, i find number of entries as follows but i couldnt delete the list (may be cause its test system)

RSICCONT     1

RSMONICDP     52

RSODSACTUPDTYPE     0

RSODSACTREQ     1

what to do now ?

[former_member182470]

You did a wrong thing by deleting manually from New table. You have to delete the same Req Num( which was deleted by you) from RSICCONT and RSODSACTREQ. Then only, your issue will be resolved.

[former_member182470]

HI,

In the activation window, there will be a place to set BGDs. Keep it as 3 or 5.

How many records are there in this request? Is it so big? Logout and login again and try to activate again.

Did you delete any previous request yesterday or today? IF yes, that request might not have been deleted properly. It must be lying in RSICCONT and RSODSACTREQ tables. Please delete that request from tables.

Regards,

Suman

[RamanKorrapati]

Hi Akash,

Go to respective DSO--> manage--> request tab,

Select the request, click on activate, on next screen select request there and click on start button. they activation process will run.

you can see the job logs from the same screen or you can check at SM37 job name: BI_ODSA*, select user id: your id and to day date. you will get dso activation job.

Try and let us know

Thanks