phase MAIN_TRANSEXEC/PARMVNT_TRANS very slow

[clemens_schneider]

Hi all,

we're installing EHP7 for ERP6.0.

SUM seems to be stuck in the Phase MAIN_TRANSEXEC/PARMVNT_TRANS. We can see logs written in .../SUM/abap/tmp, but with hours of no change.

The system runs on Solaris 11, DB is Oracle 12, SUM Version is 1.0 SP14 (PL6).

What can we do to speed things up?

Thanks and regards,

Clemens

[anandkarthik_raja · Accepted solution]

Hello Clemens,

The phase PARMVNT_TRANS is a database intensive phase, 99% of the work is reading/writing to the DB, please involve you DBA for tuning.

1. Confirm you have updated the tp, R3trans, DBSL and kernel to the latest

2. Confirm if the location of the data files is on a network drive or local, if network move to local.

3. Check the note 1616401 - Understanding parallelism during the Upgrades, EhPs and Support Packages implementations

Also attach us the SAPupConsole.log file.

Regards,
Anand.

[clemens_schneider · Accepted solution]

Hello Anand,

thank you for your hints.

The actual problem was an ORA-Error. Both TPs were locking each other as I could see in the .../SUM/abap/tmp/PD*...-logfile.

Solution: Killed the TPs and repeated the phase in SUM.

Regards,

Clemens