SAP R/3 Data Flow slow

dataservices sap-erp-bw
1

Hello.

I have two same servers.
I have the same R/3 Data Flow but in one server it takes only 10 minutes to success and on the other, it takes more than 5hours and sometimes it fails.

If somebody can help me or give me some ways to resolve this difference ? Where do i find ?

Thanks in advance.

Eric

ericf :fr: (BOB member since 2007-07-03)

2

You understand the R/3 DF is converted into an ABAP and then executed on the SAP Server machine? So this is likely a question of what is the difference between the two SAP servers, isn’t it?

Werner Daehn :de: (BOB member since 2004-12-17)

3

It is ok … for the first part.

But the SAP server is the same. I have a DF for test and another for prod …

So what could be the difference to have this large difference of time ?

Eric

ericf :fr: (BOB member since 2007-07-03)

4

Identical Server down to system number (and client number)? Otherwise the server has two databases which might have different optimizer settings.
Is the generated ABAP different?

(btw, why do you have two dataflows? Normally you would have one repo that connects to dev, from there you export the objects to the prod local repo and there the SAP datastore points to prod. And might have different settings. No need to maintain multiple dataflows for that.)

Werner Daehn :de: (BOB member since 2004-12-17)

5

It was just a forgotten parameter.
:lol:
Sorry for the desagrement.

ericf :fr: (BOB member since 2007-07-03)

6

Oh, or it could be a parameter :mrgreen:

Werner Daehn :de: (BOB member since 2004-12-17)

7

Hi!
We are facing the same slowness problem, could you tell us which parameter were you talking about??
Many thanks.

miguelb (BOB member since 2004-07-23)