Check Data Values, Generates Navigation Data steps taking more time

[Former Member]

Hi,

In the Masterdata load to 0MAT_PLANT

The step - "Updating attributes for InfoObject 0MAT_PLANT" used to take a Maximum if 23 minutes for a data package size of 100,000 records till three days ago with the constituent steps "Check Data Values","Process Time-Independent Attributes" and "Generates Navigation Data" taking 5,4 and 12 minutes respectively.

For the last three days the step "Updating attributes for InfoObject 0MAT_PLANT" is taking 58-60 minutes for the same for data package size of 100,000 records with the constituent steps "Check Data Values","Process Time-Independent Attributes" and "Generates Navigation Data" taking 12,14 and 22 minutes respectively.

Can anyone please explain what is needed to speeden the dataload back to its previous timing e.g. if tables indexes need to built for 'P' or 'SID' table of Mat_plant.

An explanation of why the delay could be happening in the above steps will be really great.

regards,

Kulmohan

[Former Member · Accepted solution]

Hi Kulmohan,

Why can't you use Delta for Mat_plant ? when it is available.

If your system is not Retail, just shift the datasource to Delta.

[Former Member]

no resolution

[Former Member]

Hi Kulmohan Singh,

I think there may be a difference between the first update and second update is the 100,000 records is

already in your 0MAT_PLANT.

If you update the 0MAT_PLANT in twice, The Modify statement should loop the Q table of

0MAT_PLANT that was already have the 100,000 records in it,so the upload speed was slowly.

Hope it helpful you.

Regards,

James.

[Former Member]

Hi James,

Thanks for your note. However the point mentioned by you doesn't apply in this scenario as MAT_PLANT is a full load in a daily routine.

The issue really is that the same amount of data that was being updated previously as well, the steps mentioned in my post above post are now taking more time circa 58-60 minutes), where they previously took 25 minutes for the last 3 months

regards,

Kulmohan