cancel
Showing results for 
Search instead for 
Did you mean: 

DSO activation fails????

Former Member
0 Kudos

hi experts,

when i execute the DTP the request is green, and i am able to see the data in new data table. but when i activate the request it is becoming red. plz suggest me what is the problem..

regards

vadlamudi

Accepted Solutions (1)

Accepted Solutions (1)

former_member345199
Active Contributor
0 Kudos

Hi,

There are a couple of places where you can see the activation progress.

1) To start with SM37 job log > (give BI_PROCESS_ODSACTIVAT or BI_ODSA*)

and it should give you the details about the activation job. If its active make sure that the job log is getting updated at frequent intervals. If its completed check the log for ODS activation.

2) For very huge number of records SM37 job log may not get update frequently. In that case you have a workaround.

Go to contents > Active Data table > No. of entries > This will keep on increasing at frequent intervals.

3) SM66 > Get the job details (server name PID etc from SM37) and see in SM66 if the job is running or not. See if its accessing/updating some tables or is not doing anything at all.

4) Go to Activate button in Target > Request tab. Inside you can see a job log button. It will also show some log regarding the last activation.

5) If the Reporting icon has appeared near the request id in ODS. If it appears that may indicate that request is available for reporting

6) Check the request status in these tables.

Table RSICCONT table contains the requests that are actually loaded in a target.

Table RSMONICDP contains the request id of the fact table.

Table RSODSACTREQ contains information if an ODS is available for reporting/deleting inactive requests also possible.

Table RSODSACTUPDTYPE.

Check and confrim.

Hope this helps.

Thanks,

JituK

Answers (4)

Answers (4)

Former Member
0 Kudos

The data load must have failed....plz see the data load monitor screen for error message.

SID generation takes place at the time og cube loading also.

Thanks..

Shambhu

Former Member
0 Kudos

do the RSRV check for ur ODS it dispaly the error message

Former Member
0 Kudos

thanks = assign points

Former Member
0 Kudos

There must be some error in the activation job. Go to RSA1-ur DSO-manage---> Log of the activation job (not the data load job, as there will be two log sysmbols). Analyze the log to see the error.

Thanks...

Shambhu

Former Member
0 Kudos

HI ALL,

in the dso settings i unckeck sid automatically generate and now data is coming to ACTIVE DATA TABLE, but i am pushing data to info cube, i cannot see the data in info cube.

Former Member
0 Kudos

Hi Venu,

ODS activation fails due to following reasons,

1) Duplicate records

2) while activating , SID has changed from 000023...00034 like this

If you want to load with dupliate records means in ods settings uncheck Unique data records and activate and load it.

For second one while activating ODS request choose activate records in parallel and try to activate it.

One more thing check in RSADMINA table for background user (ALEREMOTE) available or not.

Go to SE14

Give the active table name..

Click on Edit

Click on activate and adjust database.

Load again and try to activate.

Also check this link:

[https://forums.sdn.sap.com/click.jspa?searchID=13085942&messageID=5125079]

Hope it helps you. Assign points if it helps you.

Regards,

Yokesh.

ravikanth_indurthi
Active Contributor
0 Kudos

Hi Venu,

Just analyze the error in logs/ Details tab in RSMO, might be due to invalid chars. just edit the request in PSA and update to DSO and load the data.

Thanks=Points in SDN

Rgs,

I.R.K

Former Member
0 Kudos

hi,

there are no errors in log. in the details tab everything is green, but in header its red.

plz suggest me what went wrong what can we do to overcome this.

regads

vadlamudi

Former Member
0 Kudos

Hi Venu,

Try to check is there any Dump in St22 or any error noticed in SM21 on this..

If u dont find anything then u can try reconstruct the data again and check if the activation works fine for u or not??

Or u can even check the request in RSODSACTREQ.. where u can trace is there any issue in any of the data packet of the load.... If the status is 0 for all the data packets then there is no issue in load and activation .....

if so then u can turn ur request to Green and then proceed further...

If u find any the status as wrong then u need to analyze where the issue is..

Post the results here for more assistance..

thanks

Assign points if this helps