Activation of M records from DataStore object terminated

[Former Member]

Hi All, I am getting error while activating data into ODSes. This is happening to some of the ODSes not all. I tried deleting that request & reloading but it fails at the activation. The request shows red in the manage, when I try to change the request from red to green it says that "Request is already (partially) activated; no further QM action possible". I can't make it green so can't activate the request manually.

I am getting the following error messages:

Activation of M records from DataStore object ODS_PPOR terminated

Time limit exceeded. No return of the split processes

Process BCTL_47NQSIEIQXZC6C47ZUFBUATQM could not be terminated. Terminate manually

Error during confirmation of process 000018

There has been few erros in the database but can't do mcuh as the basis resource is currently not avaliable. Is there something that I can do it to fix this issue. kindly help!

regards

PK

[Former Member · Accepted solution]

Hi PK

May be you have less no. of BDG process. you can chk it in SM50.

Also check the tcode RSODSO_SETTINGS, here you can find activation time settings. increase it if it is less.

Thanks

Tripple k

[Former Member]

What SP are you on

may wish to look at below-

Note 1028394 - P13: RDA: Manually setting terminated requests to red

Hope it Helps

Chetan

@CP..

[Former Member]

Thanks Chetan, we are on SP13. so I believe this note is already applied.

I have asked the basis to bounce the database & SAP instance. Will try my luck after that.

[Former Member]

Sounds like a Plan

Good Luck

Hope it Helps

Chetan

@CP..

[Former Member]

Hi PK,

Did you ever find out what the problem was? I am facing exactly the same situation.

cheers

[Former Member]

Hi,

option1:try to activate the reqeusts manually one by one

chk the no of parallel process..

if you have concluded it is not basis issue,then

Use RSRV transaction and run a test on ODS.....then try to activate the requests

the steps are mentioned in one of the thread(credit goes to the writer)

1. Do transaction code RSRV (analysis and repair of BW objects)

2. Perform both : Foreign Key... and Check How...

3. Click on transfer and Execute it.

4. Make sure that you get green lights (check of foreign key relation get the green light)

Cheers,

Swapna.G

Message was edited by:

swapna gollakota

[Former Member]

Thanks Tripple/Roberto/Swapna for your responses. I will assign you relevant points fro your response. Below is my response.

SM50 has 15 BDG processes, almost all of them are waiting.

RSODSO_SETTINGS has Parameter for activation.....Maximum Package Size -20,000; Maximum Wait Time for Process-300

I believe they are optimal.

No other jobs are running right now. System is almost idle.

Swapna, I cannot activate it manually as the request is red & it doesn't allow me to make it green, gives me a message "Request is already (partially) activated; no further QM action possible", when ?I try to change the QM to green.

I already ran the RSRV for the ODSes & its all green.

kindly help as its urgent. thnaks

[Former Member]

May be num of Batch Processes available are all in use ..wait for other jobs to finish if any running in BI.