0cust_sales DTP load issue

[sap_user62]

Hello Friends,

Env BW 7.3

I am having issues with the load to the 0cust_sales attributes in few systems.

In development system, where the data records are around 1 million, the full dtp load takes 6 minutes ( the info package taken 1 min)

There is no customization in the transfer rules and the no routines in the DTP.

However the same DTP in 2 other systems takes 7 hours to load. Sometimes it just gets hanged out. The info package load takes as in dev 1 minute.

The system resources though not exactly the same are not alarmingly different. I tried changing the load to delta with no change. psa just has one request.

I have checked 0division, 0distribution channel and 0salesorg have master data activated.

I have checked the forums but could not find any proper answer.

Your comments are appreciated.

Ed.

[RamanKorrapati · Accepted solution]

Hi,

Again re transport your data flow from dev to Qua and prod.

Later try to check at Qua and prod.

Compare to dev, Qua and prod won't take same time, its may take more time.

Prod system is live one, due to other loads and available application servers its may take bit more time.

During your info pack load, please check ecc T code - SM58 and ECC job at SM37.

Thanks

[former_member532796]

Hello,

are there any look up codes in transformations? Can you check where the load is taking time in RSMO? If indexing table of the source is corrupted then we may face this issue, please check. Did you try loading with semantic keys?

Thanks,

Maddy

[sap_user62]

Thanks all for your replies.

I do not have any issues with the ECC load, they run fine, in less than a minute in all the systems. Have issues only with the DTP ( full or delta). The other system that I tried is Sandbox. where the CPU is less, but one of the transaction load in the system with 4 million records completed in 30 minutes. So I guess this may not be with CPU entirely

Restarted the server, with no luck. I will try to transport the objects again and check for semantic option.

Can we create indexes on sap standard info objects?

Thanks

Ed.

[RamanKorrapati]

Hi,

at Prod server, try to activate transformations and dtp. try to load full load and see.

if its taking more time then try transport your transformations and dtp again to qua and prod servers.

Even try to check transformations have any inconsistencies at prod/qua.

use program - RSTRAN_ROUT_RSFO_CHECK

thanks

[KodandaPani_KV]

Hi,

create the new DTP at PRD and first extract the data with DTP filters some records

find the time how much time taking for loading the data.

check the process avalibilty at SM51

increase the parellel process for DTP -> select the DTP -> goto menu -> select the setting for the batch manger -> increas the parllel process.

after execute the DTP.

Thanks,

Phani.

[sap_user62]

Thanks Phani for your reply.

I tried to increase the number of processes in DTP to 12, no positive results

My issue got fixed by selecting semantic groups for customer number in the DTP selection. The load now completes in 4 minutes

Its really strange, that in development without the semantic groups it runs fine, but in sandbox it needs semantic grouping.

Thanks everyone for your valuable inputs.

Ed.

[KodandaPani_KV]

Hi,

please check the applicaiton server avalibilty in SM51.

how many process in your system and how many back ground process?

increae the back ground process system.

check the job logs in SM37 while executing the DTP.

same job logs check in ECC system while running the info pacakge.

Thanks,

Phani.