Repository corrupted/loading process is taking long time

[Former Member]

The repository load process is getting stuck at the below message for long time. We have disabled sort indexes on all look up tables but still it is taking huge amount of time to load the repository.Any information on this would be of great help.

94 2011/08/26 20:16:55.523 Report Info Background_Thread@Accelerator Preload.cpp Processing sort indices for 'Products'... (98%)

81 2011/08/27 02:08:23.298 Report Info Background_Thread@Accelerator Preload.cpp Processing sort indices for 'Products'... (100%)

Regards,

Nitin

[Former Member]

Hi Nitin,

There are many performance improvement steps that one can take regarding this including verifying your repository.

But i think it should only be a problem if this problem reoccurs.

The accelerators get created when there is a change in table and update indices creates them,possibly there are multiple changes and load by update indices has not taken place for sometme thats why it is creating them.

For better performance one can do following:

Make a judicious choice of which fields to track in change tracking

Disk Space has a huge impact on smooth functioning of MDM. If the disk space is not enough MDM Server cannot even load the repositories

Have a closer look at data model and field properties

Verify if your MDS.INI has this parameter: Session Timeout Minutes (Number. Causes MDM Console, CLIX, and applications based on the new Java API to expire after the specified number of minutes elapses. Default is 14400 (24 hours).When set to 0, sessions never time out.).When you have many open connections, this can to generate performance issue on MDM server

Refer to SAP Note Number: 1012745

Hope this helps.

Thanks,

Ravi

[Former Member]

Hi Ravi,

Thanks a lot.

Regards

Nitin