Content error using Export All To Excel - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Web Client Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10

We do not recommend you export very large data sets using the Export All to Excel command. You are advised to use reports that have been specifically developed to handle large amounts of complex data. For more information, see Configure reports and Reporting on your data.

Problem

When you export a large number of documents to Microsoft Excel using the Export All To Excel command, the full contents of the export are not present in the Excel file produced.

Cause

The server checks the OAuth authentication access token when performing internal paged requests. If the authentication Access Token Lifetime property value has been set at too short a duration for the export to finish, the export can complete prematurely and not include all the content. Similarly, if the token has expired or is about to expire (has less than one minute remaining), then an Export All To Excel command only returns the data collected before the token expires.

Solution

You can increase the Access Token Lifetime property duration value on your authentication provider to allow the Export All To Excel command to complete within the given token lifetime. The Access Token Lifetime property should be set with a long enough duration for any large exports to complete.