SUPPORT / SAMPLES & SAS NOTES
Problem Note 52677: The SAS® Add-In for Microsoft Office and SAS® Enterprise Guide® might time-out when you attempt to open long-running SAS® Visual Analytics reports
 |  |  |  |  |
Beginning with release 6.1_M1, you can use the SAS Add-In for Microsoft Office and SAS Enterprise Guide to open reports that are created in SAS Visual Analytics.
However, if your report is very large and it takes a long time to open, then you might see the following message in the SAS add-in:
In SAS Enterprise Guide, this message might appear:
With logging enabled for the SAS add-in, you might see the following content in the log.
2014-04-02 14:17:59,511 [JobSpecificExecThread] ERROR SAS.OfficeAddin.Global [(null)] - Unable to access the TransportService. System.Net.WebException: The operation has timed out at System.Net.HttpWebRequest.GetResponse() at SAS.EC.SASWebExtensions.VisualAnalyticsTransport.TransportServiceAPI.MakeHttpWebRequest(Uri requestUri, WebRequestMethod requestMethod, String requestPayload, WebHeaderCollection headers, String acceptHeaderType, CookieContainer sessionCookieContainer, Boolean allowRedirect) at SAS.EC.SASWebExtensions.VisualAnalyticsTransport.TransportServiceProxy.MakeHttpWebRequest(Uri requestUri, WebRequestMethod requestMethod, String requestPayload, Boolean allowRedirect, String acceptHeaderType, WebHeaderCollection headers) at SAS.EC.SASWebExtensions.VisualAnalyticsTransport.TransportServiceProxy.GetReport(ReportResponse rr, String folder, CachedReport& outCachedReport, DataLevel dataLevel) at SAS.EC.SASWebExtensions.VisualAnalyticsTransport.TransportServiceProxy.GetReport(String folderSBIP, String folder, CachedReport& cr, DataLevel dataLevel) at SAS.OfficeAddin.BIReport.DownloadContent(ReportActivityState reportActivity, String displayName, String reportMetadataPath, String reportSBIP, AmoDelayedConnectionReportLiveService& service, List`1 reportFiles, TransportServiceProxy& proxy, String& destinationDirectory, String& errorMessage, String& downloadWarningMessage, Boolean& needUpdateStatus, Exception& error, String metadataType) 2014-04-02 14:17:59,547 [JobSpecificExecThread] ERROR SAS.OfficeAddin.Global [(null)] - ----------- END OF EXCEPTION REPORT ------------
With logging enabled for SAS Enterprise Guide, you might see the following content in the log.
2014-04-02 14:31:18,841 [Main] ERROR SAS.ReportBI.BIRDViewer.BIRDViewer [(null)] - The report failed to open. Contact your SAS administrator. System.Net.WebException: The operation has timed out at System.Net.HttpWebRequest.GetResponse() at SAS.EC.SASWebExtensions.VisualAnalyticsTransport.TransportServiceAPI.MakeHttpWebRequest(Uri requestUri, WebRequestMethod requestMethod, String requestPayload, WebHeaderCollection headers, String acceptHeaderType, CookieContainer sessionCookieContainer, Boolean allowRedirect) at SAS.EC.SASWebExtensions.VisualAnalyticsTransport.TransportServiceProxy.MakeHttpWebRequest(Uri requestUri, WebRequestMethod requestMethod, String requestPayload, Boolean allowRedirect, String acceptHeaderType, WebHeaderCollection headers) at SAS.EC.SASWebExtensions.VisualAnalyticsTransport.TransportServiceProxy.GetReport(ReportResponse rr, String folder, CachedReport& outCachedReport, DataLevel dataLevel) at SAS.EC.SASWebExtensions.VisualAnalyticsTransport.TransportServiceProxy.GetReport(String folderSBIP, String folder, CachedReport& cr, DataLevel dataLevel) at SAS.EG.ProjectElementViews.BIRDReportView.BackgroundDownloadReport(ViewerConfiguration config) at SAS.ReportBI.BIRDViewer.BIRDViewer.<DownloadReport>b__6()
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft Windows Server 2003 for x64 | 6.1_M1 | |||
| Microsoft Windows Server 2008 | 6.1_M1 | |||||
| Microsoft Windows Server 2008 R2 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 6.1_M1 | |||||
| Microsoft Windows Server 2003 Enterprise Edition | 6.1_M1 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 6.1_M1 | |||||
| Microsoft Windows NT Workstation | 6.1_M1 | |||||
| Microsoft Windows 2000 Professional | 6.1_M1 | |||||
| Microsoft Windows 2000 Server | 6.1_M1 | |||||
| Microsoft Windows 2000 Datacenter Server | 6.1_M1 | |||||
| Microsoft Windows 2000 Advanced Server | 6.1_M1 | |||||
| Microsoft Windows 95/98 | 6.1_M1 | |||||
| Microsoft Windows 8.1 Pro 32-bit | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro 32-bit | 6.1_M1 | |||||
| Microsoft Windows 8 Enterprise x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Enterprise 32-bit | 6.1_M1 | |||||
| Microsoft® Windows® for x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Datacenter | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Std | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Std | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows XP Professional | 6.1_M1 | |||||
| Windows 7 Enterprise 32 bit | 6.1_M1 | |||||
| Windows 7 Enterprise x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Windows 7 Home Premium 32 bit | 6.1_M1 | |||||
| Windows 7 Home Premium x64 | 6.1_M1 | |||||
| Windows 7 Professional 32 bit | 6.1_M1 | |||||
| Windows 7 Professional x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Windows 7 Ultimate 32 bit | 6.1_M1 | |||||
| Windows 7 Ultimate x64 | 6.1_M1 | |||||
| Windows Millennium Edition (Me) | 6.1_M1 | |||||
| Windows Vista | 6.1_M1 | |||||
| Windows Vista for x64 | 6.1_M1 | |||||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |
| Microsoft Windows 8 Enterprise 32-bit | 6.1_M1 | |||||
| Microsoft Windows 8 Enterprise x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro 32-bit | 6.1_M1 | |||||
| Microsoft Windows 8 Pro x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro 32-bit | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows 95/98 | 6.1_M1 | |||||
| Microsoft Windows 2000 Advanced Server | 6.1_M1 | |||||
| Microsoft Windows 2000 Datacenter Server | 6.1_M1 | |||||
| Microsoft Windows 2000 Server | 6.1_M1 | |||||
| Microsoft Windows 2000 Professional | 6.1_M1 | |||||
| Microsoft Windows NT Workstation | 6.1_M1 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 6.1_M1 | |||||
| Microsoft Windows Server 2003 Enterprise Edition | 6.1_M1 | |||||
| Microsoft Windows Server 2003 Standard Edition | 6.1_M1 | |||||
| Microsoft Windows Server 2003 for x64 | 6.1_M1 | |||||
| Microsoft Windows Server 2008 | 6.1_M1 | |||||
| Microsoft Windows Server 2008 R2 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Datacenter | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Std | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Std | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Microsoft Windows XP Professional | 6.1_M1 | |||||
| Windows 7 Enterprise 32 bit | 6.1_M1 | |||||
| Windows 7 Enterprise x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Windows 7 Home Premium 32 bit | 6.1_M1 | |||||
| Windows 7 Home Premium x64 | 6.1_M1 | |||||
| Windows 7 Professional 32 bit | 6.1_M1 | |||||
| Windows 7 Professional x64 | 6.1_M1 | 7.1 | 9.4 TS1M0 | |||
| Windows 7 Ultimate 32 bit | 6.1_M1 | |||||
| Windows 7 Ultimate x64 | 6.1_M1 | |||||
| Windows Millennium Edition (Me) | 6.1_M1 | |||||
| Windows Vista | 6.1_M1 | |||||
| Windows Vista for x64 | 6.1_M1 | |||||