cancel
Showing results for 
Search instead for 
Did you mean: 

DSO Activation Fails

Former Member
0 Kudos

Hi,

When i am trying to activate the DSO,The activation fails with the following error messages

Error when inserting the data record for data package

Process BCTL_46VTHFK8WZVQ7UEZGUGW8QEK4 could not be terminated. Terminate manually

Time limit exceeded. No return of the split processes

Could anyone help me on this,Points will be assigned.

Regards,

Sridevi

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Sridevi,

I think this problem remains unanswered.

The issue behind this problem is, during parellel activation the child jobs acknowledge the parent job about status. If the child job takes long time to read data from active data table, then it times out and fails.

Check the primary index on Active data table and it should be missing in your case. See the se11 index or db02 missing indexes. That is the reason that causes time out. Rebuild the primary index by asking your basis folks and repeat the activation. It should succeed.

Thanks,

Sri.

Former Member
0 Kudos

The last time i had this issue is due to System copy

former_member186358
Active Contributor
0 Kudos

Hi Sridevi,

•If you are using Process Chain

in that case go to the process type = "Activate datastore data" -->maintain variant --->Hit " Parallel Processing " button change it to "BACKGROUND process”, select" parallel generators "option

Number of processes = 3

For

1)DS-Activation

2)DS-Sid generation

Above activity must be done separately for every single ODS you have. You can play around with the number of processes to increase of decrease depending on the resources you have -you can check that in SM50/SM51.

•In case u r not using a process chain and activating the data manually, then execute RSODSO_SETTINGS transaction (RSCUSTA2 in BW3.5) and give your ODS technical name. Select 1st Radio Button against Change Runtime Parameter and execute. There r 3 settings which u can change. Select each one and individually change the number of work processes depending on available DIA processes (SM50).U can also set Maximum Package Size and Maximum Wait Time for Process.

Some Sanity Checks for ODS activation problems -

1) Transaction RSRV, check the activation program for the ODS if get Red, then correct it and try the activation again.

RSRV>All elementary Test>ODS Objects-->

"Check the status of the Generated Program of a datastore object" drop on the right, inset you ODS technical name, press execute. if error occurs, then press correct error.

Now continue activation of the ODS requests

2) RSKC- Allow special characters can use ALL_CAPITAL

3) Se38-->RSDMD_CHECKPRG_ALL can use this program for checking the characteristics Infoobject consistency.

4) Make sure you have loaded Master data infoobject loaded before transaction data and that Attribute/Hierarchy change run carried out

Regards,

Anil

Former Member
0 Kudos

Hi,

I have tried the option provided by you but still i get the below errors

Process 000001 returned with errors

Error when inserting the data record for data package

Process 000002 returned with errors

Error when inserting the data record for data package

Can anyone help me to resolve this.Points will be assigned.

regards,

sridevi

Former Member
0 Kudos

Hi,

Could any one help me to resolve this......as it is very critical.

Highly appreciated.

Regards,

sridevi

Former Member
0 Kudos

Hi Sridevi,

What is error message your get when Activating DSO. What are your DSO setting? Have your DSO setting as unqiue Data records.? Please check your DSO setting.

Hope it helps,

Cheers,

Balaji

Former Member
0 Kudos

Hi Balaji,

The Error messages are as follows

Error when inserting the data record for data package

Process 000001 returned with errors

Process 000002 returned with errors

I am able to execute the same process chain in development and quality without any issues,but some how i face this isse in production.

Any help on this would be highly appreciated.

Regards,

Sridevi

Former Member
0 Kudos

Plz de-select option of SID generation and then activate ODS. It should work.

Former Member
0 Kudos

Hi,

I tried the option of setting the parrallel processing to dialog parallel generators and the number of processes as 2 and tried executing the process chain again.

but it has failed with the errors

Error when inserting the data record for data package

Could anyone help me in resolving this issue as this is very urgent.

Regards,

Sridevi