cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade BW4HANA 2.0 - DTP load slow performance

pamarque
Participant
0 Kudos
1,098

Good morning,

We have recently upgraded to the BW4HANA 2.0 version, and we have detected that some loads are slower, compared to the previous version of BW4HANA 1.0.

an example is the load of this DTP:

When dtp runs, it only shows one active job in the system.

and the system is not overloaded with processes, now that we are running it there are only two active jobs, so there is no reason for dtp not to multiplex the load.

Can you help me identify what could be the problem?

BR,

Accepted Solutions (0)

Answers (4)

Answers (4)

RolandKramer
Active Contributor
0 Kudos

wow, you honestly think a SAP Note correction from 2008 for BW 7.01 solves the same Problem for BW/4?

what about the Settings in tx. SBIW => Maintain Control Parameters for Data Transfer

RolandKramer
Active Contributor
0 Kudos

Hello pamarque

pamarque3 Processes are not really called "Performance" as it is the default setting. What Du you think?

Best Regards Roland

pamarque
Participant
0 Kudos

Hi roland.kramer,

The problem is that even having the 3 processes, when the load is executed, in the trx sm50 only 1 process is released, and not the 3 processes parameterized. And the server is completely free of charge, with all batch processes free. So even if the number of batch processes increases, I think the same thing would happen. It is just the same problem that this note indicates, but it does not apply by version.

1158574 - 70SP18: DTPs no longer run in parallel after importing SP 16

BR,

Patricia.


pamarque
Participant
0 Kudos

Hi roland.kramer,

I have reviewed the document, and regarding the parameters of the RSBACTH transaction, I have seen that the DTP was not, therefore, not in the RSBATCHPARALLEL table either. I have activated the DTP, and I have rechecked the RSBATCHPARALLEL table, and the DTP already appears.

I've run the load next, and it's still having performance issues.

I have found this old post, and they talk about the problem I have.

https://answers.sap.com/questions/11553865/parallel-processing-in-dtp-level-not-working.html

This note is mentioned, but it is old, and does not apply to the version of BW4HANA 2.0

1158574 - 70SP18: DTPs no longer run in parallel after importing SP 16

Do you know if there is any similar sap note that applies to the new version of BW4HANA?

On the other hand I am also looking at this note,

2769125 - Composite Note: RSADMIN Parameter for SAP BW/4HANA

do you know if there is any parameter that we have to change related to this problem?

Thanks in advance for the help.

BR,

Patricia.

RolandKramer
Active Contributor
0 Kudos

Hello pamarque

you should rather check with tx. RSODSO_SETTINGS as stated in the Document - Customizing SAP BW 7.x and BW/4

Best Regards Roland

please follow the Rules of Engagement

pamarque
Participant
0 Kudos

Hi roland.kramer,

I have checked the settings in the trx RSODSO_SETTINGS of the object, and they look fine. In the process settings, 3 batch processes are configured.

Any more ideas?

BR,

Patricia,

Oscar_Alberto
Participant
0 Kudos

Hi Patricia

Have you try to apply SAP Note 2603241. I tell you my experience. We are in BW/4HANA 2.0 SP8. When I have an issue related to DTPs or transformations, the first thing we do is verify if SAP Note 2603241 has new updates. Many times applying this SAP Note solves the issue.

Be advised that, depending on the SP level you BW4 is on, it will apply several SAP notes so, be careful.

Regards

pamarque
Participant
0 Kudos

Thanks Oscar, I'll look at the note.

RolandKramer
Active Contributor
0 Kudos

Hello pamarque

Did you checked the BW/4 Basis Customizing again?

Possibly some user values were reset during the SAP Upgrade ...

SAP BW Installation/Configuration on/for HANA => Customizing SAP BW 7.x and BW/4

Best Regards Roland

please follow the Rules of Engagement

pamarque
Participant
0 Kudos

ok Roland, we'll check it out.

Thanks you.