SUM EHP / MAIN_TRANSEXEC/PARMVNT_TRPRE -> Too many processes to initialize

[benoit-schmid]

Hello,

I wanted to monitor the resources used by a ECC 6.04->6.07 upgrade with a high parallelism.

In the SUM settings, I have set 128 processes.

During the upgrade there is the following error.

###

1 ETQ200 Executing actual phase 'MAIN_TRANSEXEC/PARMVNT_TRPRE'.
1 ETQ399 Phase arguments:
2 ETQ399 Arg[0] = 'TP_MOVENTABS'
2 ETQ399 Arg[1] = 'INTDEL;INTACT;TOUCH;NOBUFFRESET'
2 ETQ399 Arg[2] = 'MF=F,RANGE-TS; MF=A,RANGE-TS; MF=J; MF=B'
2 ETQ399 Arg[3] = 'PARCONV.TP0'
1 ETQ399 Using error summary log 'MVNTTRANSPRE.ELG'.
1 ETQ399 Using 128 parallel processes
4 ETQ380 computing toolpath for request "TP_MOVENTABS"
4 ETQ382 translates to group "R3UP_TOOL_GROUP_SYS"
4 ETQ399 Requirement for tp maps to '<system>'
4 ETQ383 translates to path "/usr/sap/xxx/DVEBMGS00/exe"
3 ETQ399 20140123151131: PID 29610 execute '/usr/sap/xxx/SUM/abap/exe/tp -V' , output written to '/usr/sap/xxx/SUM/abap/log/TOOLVERS.OUT'.
3 ETQ399 20140123151131: PID 29610 exited with status 0 (time 0.000 real)
1EETQ399 Last error code set is: Too many processes to initialize
1EETQ204 Upgrade phase "PARMVNT_TRPRE" aborted with severe errors ("20140123151131")

###

1. Is the maximum amount of processes for tp or R3trans?

2. What is the maximum value?

3. In which file could I reduce this value for SUM execution?

Thanks in advance for your answers.

[benoit-schmid · Accepted solution]

Hello,

After opening a incident with SAP, it turned out that there is hard limit set to 62.

Regards,

[sunny_pahuja2]

Hello,

This value is very high. Number of R3trans processes usually depends upon number of CPU's on the server. You can refer to SAP note 1127194 and 1616401 for more information.

You can reduce the process by using command <DIR_PUT>/bin/SAPup set confpar gt=scroll

Thanks,

Sunny

[benoit-schmid]

Hello,

Sunny Pahuja wrote:

This value is very high. Number of R3trans processes usually depends upon number of CPU's on the server. You can refer to SAP note 1127194 and 1616401 for more information.

It is high, but it should be suited to this machine.

After reading these notes, I thought that it is suited to the host as it is a T5 with 256 threads.

Regards,

[benoit-schmid]

Hello,

Sunny Pahuja wrote:
You can reduce the process by using command <DIR_PUT>/bin/SAPup set confpar gt=scroll

This answer my question 3.

It works thanks.

Would someone has the answer to the following two remaining questions?

1. Is the maximum amount of processes for tp or R3trans?

2. What is the maximum value?

Thanks in advance for your help

[sunny_pahuja2]

Hello,

Have you referred to SAP note 1616401 which gives idea about parallelism?

Thanks,

Sunny

[benoit-schmid]

Hello,

Sunny Pahuja wrote:

Hello,

Have you referred to SAP note 1616401 which gives idea about parallelism?

Thanks,
Sunny

My question is not how many parallel processes I should set.

I have already asked this question in another thread.

My question concerns the specific error that I am facing.

Would someone has the answer to the following two remaining questions?

1. Is the maximum amount of processes for tp or R3trans?

2. What is the maximum value?

Thanks in advance for your help

[Reagan]

My question is not how many parallel processes I should set.

There is no fixed number for this.

It all depends on how many CPU's and the underlying database.

You may read this SAP note

1127194 - R3trans import with parallel processes

Regards

RB

[benoit-schmid]

Hello,

Reagan Benjamin wrote:


My question is not how many parallel processes I should set.

There is no fixed number for this.
It all depends on how many CPU's and the underlying database.
You may read this SAP note
1127194 - R3trans import with parallel processes

I said my question is NOT.

Again I am not asking for that, I am interested by the following.

1. Is it the maximum amount of processes for tp or R3trans?

2. What is the maximum value accepted by SAP?

Thanks in advance for your help

[Reagan]

I am sorry I missed NOT part in your previous message.

1. Is it the maximum amount of processes for tp or R3trans?
2. What is the maximum value accepted by SAP?

There is nowhere mentioned about max limit for the tp/R3trans.

The max limit one can configure is based on the system resources and also with the database.

That could be the reason why SAP uses the 'n' instead of a digit.

1223360 - Composite SAP Note: Performance optimization during import

1616401 - Understanding parallelism during the Upgrades, EhPs and Support Packages implementations

Regards

RB

[sunny_pahuja2]

Hello,

SAP has not defined any maximum number of R3trans/tp processes for upgrade. You can determine this number based on CPU and memory available on the server. SAP note that I shared previously gives you an idea that how you can determine optimal value based on server capability.

Thanks,

Sunny

[benoit-schmid]

Hello,

Sunny Pahuja wrote:

SAP has not defined any maximum number of R3trans/tp processes for upgrade.

Thanks for the info.

Could someone please tell me what kind of processes are concerned by this error?

I am thinking of dialog wp as there is no limitation on R3trans, R3load and tp.

I also would like to mention Oracle DB max session is reached.

Thanks in advance for your answer.

[Reagan]

Hello

Have you noticed any errors in the alert log ?

Check the number of processes and sessions configured at the database level.

If you have configured the upgrade tool to trigger a lot of tp/R3trans processes then the database should be able to accommodate those requests too.

Regards

RB

[benoit-schmid]

Hello,

There is no max session warning in the alert log.

There should be enough sessions:

processes = 1070

sessions  = 2140

Regards,

[benoit-schmid]

Hello,

Reagan Benjamin wrote:

Check the number of processes and sessions configured at the database level.

Changing the values value with SAPup, it turned out to be the maximum number of parallel SQL processes.

As there is nothing in the alert log, in which log file could I see the sql client error?

Thanks in advance for your answers.

[Reagan]

Good Day Benoit

Oracle should report all the error occurring at the database level in the alert log.

If the problem is with the upgrade tool triggering the R3trans/R3load processes then it must be most likely be in the upgrade tool logs.

Unfortunately EHP7 is quite new and there are plenty if issues (undocumented) reported during the upgrade. You (or the company for whom you work for) need to be smart enough to WAIT until there is a stable version available for the upgrade.

Either the upgrade tool doesn't like the new EHP or the kernel for EHP7 is buggy.

I would create an OSS and get in touch with the CIC and have that escalated if none of the suggestions work (including a complete restart of the system).

Regards

RB

[benoit-schmid]

Reagan Benjamin wrote:

Good Day Benoit
Oracle should report all the error occurring at the database level in the alert log.
If the problem is with the upgrade tool triggering the R3trans/R3load processes then it must be most likely be in the upgrade tool logs.
Unfortunately EHP7 is quite new and there are plenty if issues (undocumented) reported during the upgrade. You (or the company for whom you work for) need to be smart enough to WAIT until there is a stable version available for the upgrade.
Either the upgrade tool doesn't like the new EHP or the kernel for EHP7 is buggy.
I would create an OSS and get in touch with the CIC and have that escalated if none of the suggestions work (including a complete restart of the system).

Regards
RB

I am aware of that.

Our business users are interested in upgrading to ECC 6.07.

This is why we are performing the EhP on a sandbox,

so that they can test the functionalities.

I also test the problems encountered during the upgrade.

How old should an EhP be so that it is considered stable?

Regards,