SAS Add-In for Microsoft Office might time out while trying to open large SAS Visual Analytics reports. In the SAS Add-In logging file, connection time-out errors similar to the following appear:
2021-09-19 14:50:34.6962 [WARNING] NetworkDataLogger.cpp::66:HTTP_POST http://sasbi.demo.sas.com/SASVisualAnalyticsTransport/onebi/ser vices/generateReport?bypassCache=true&dataLevel=interactive&location=SBIP%3a%2f% 2fMETASERVER%2fXXXXX%2fRevenue%20Management%2fHotel%28Report% 29&type=Report.BI&timeout=60&useHighContrastReportStyle=false returned CONN_TIMED_OUT
2021-09-19 14:50:34,697 [22] DEBUG GTL_commons_Interfaces.CLog [(null)] -
2021-09-19 14:50:34.6971 [DEBUG] [TRANSPORT] RequestServicer.cpp::980:45 - Response Error - CONN_TIMED_OUT
The following error might appear as well:
2021-09-30 13:40:30,699 [VSTA_Main] ERROR SAS.ReportBI.BIRDViewer.BIRDViewer [(null)] - The report failed to open. Contact your SAS administrator.
SAS.EC.GTLTransport.GTLTransportServiceException: Exception of type 'SAS.EC.GTLTransport.GTLTransportServiceException' was thrown.
at SAS.ReportBI.BIRDViewer.BIRDViewer.<DownloadReport>b__22_0()
Beginning in SAS Add-In for Microsoft Office release 8.2, a configuration option is available to override the time-out. In version 8.2, the default report time-out threshold is 25 seconds. If this threshold needs to be increased, add the ReportTimeoutThreshold configuration option to the SAS.OfficeAddIn.dll.config file.
Edit the SAS.OfficeAddIn.dll.config file using a plain text editor. This file is located in the SAS Add-In for Microsoft Office installation directory. Add the ReportTimeoutThreshold key, making sure to match the casing exactly. For the value attribute, enter an integer greater than 25 in double quotation marks. Here is an example:
<configuration>
<assemblySettings>
<add key="ReportTimeoutThreshold" value="60"/>
</assemblySettings>
</configuration>