0MAT_PLANT data load is taking more time after upgrade

[Former Member]

Hi All,

We are upgrading our BW system from 7.3 SP03 to SP13. After upgrade, we came to know that couple of master data loads are taking more time than before upgrade.

Ex: 0MAT_PLANT load (PSA to IOBJ) used to take 1 min before upgrade and after upgrade it is taking 20 - 30 mins.

I came to know that one of the step from DTP monitor  "Check Time Independent attributes" step is taking the more time.

a. 0MAT_PLANT - P table index is fine

b. Slight increase in the no of records for this data load

c. Activated the data source, transformation & DTP then tried but no luck

d. Did RSRV but didn't find anything

Can you suggest anything on this issue.

Thanks

Prasanna

[Former Member · Accepted solution]

SAP asked us to maintain a entry (MD_SINGLE_SELECT value 'X') in RSADMIN table as per 1807709 note.

Our master data loads are running fine now after updated the entry in RSADMIN table.