Sharyn Smith Senior Project Manager

This was raised via MS ticket Tracking ID#2409270030002995

In UAT, Users reported issues when exporting from the All Emissions tab - Error Message when exporting all Emissions.

This will become an issue when more metrics are added to MSM.

Advised by MS, there is a limitation to export only 5000 records.  

Here's the correspondence:  

There are multiple reasons why we would see slow view load performance or SQL timeout.

Here are few:

• Excessive number of columns in the view

• Missing index for the columns in the view

• Calculated Fields in the view column

• A lookup field set to sort in a view causing slower performance

• SQL timeout due to TotalRecordCount (TRC query)

Mitigation:

 1. Excessive number of columns in the view :

  - 1. When you load a view the number of columns selected will affected the performance.

  - 2. You can go to Advanced find and select the entity from the list and select the view.

  - 3. Then click on "Edit Columns" and select the column and click on "Remove"

  - 4. Now test the performance and see if that improve.

 2. Calculated Fields in the view column:

We can't index calculated field so it will affect the performance. In Unify you'll find a page of unindexable columns. Remove the calculate field from the view and see if that improves the performance.

Suggested to narrow down the filter and then export.

This is just not good enough with increasing volumes of data over numerous years, expected increase number of business units and increase number of metrics, data sources, data categories, etc.