Problem Note 63380: Forecast Studio Project tasks might fail with the error "No HPF Forecast Server is defined in the active metadata repository..."
 |  |  |  |  |
In SAS® Add-in for Microsoft Office, or SAS® Enterprise Guide® in an SSL/TLS enabled environment, Forecast Studio Project tasks might fail. Examples: "Forecast Studio Create Project" and "Forecast Studio Open Project". The following error is displayed:
No HPF Forecast Server is defined in the active metadata repository. Please contact your administrator.
When you click the Exception tab of the error dialog box, the following exception is displayed:
No certificate was selected.
The request was aborted: Could not create SSL/TLS secure channel.
The request was aborted: Could not create SSL/TLS secure channel.
Exception Details:
----------------------------------------
Exception type: System.Net.WebException
Message: No certificate was selected.
Source: EC.SASWebExtensions
Target Site: SetupCertificates
Stack Trace:
at SAS.EC.SASWebExtensions.X509CertificateHelper.SetupCertificates(Object service, Action workMethod)
at SAS.EC.Directory.WebServices.SASServiceRegistry.GetServices()
at SAS.EC.Directory.WebServices.SASServiceRegistry.GetURI(String service)
...
Inner Exception Details:
----------------------------------------
Exception type: System.Net.WebException
Message: The request was aborted: Could not create SSL/TLS secure channel.
Source: System.Web.Services
Target Site: GetWebResponse
Stack Trace:
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
...
This error occurs because the SAS middle-tier looks for client SSL certificate(s) and rejects TLS 1.2 client connections. For details, see SAS Note 61498: "SAS® Enterprise Guide® and SAS® Add-In for Microsoft Office continuously prompt for a Transport Layer Security (TLS) certificate".
To resolve the issue, apply the applicable SAS Add-In for Microsoft Office or SAS Enterprise Guide hot fix from the Hot Fix tab of SAS note 61498.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Forecast Studio | Microsoft® Windows® for x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 14.3 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 R2 | 14.3 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 for x64 | 14.3 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 Datacenter | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| SAS System | SAS Forecast Server | Microsoft® Windows® for x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 14.3 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 R2 | 14.3 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 for x64 | 14.3 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 Datacenter | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| HP-UX IPF | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Linux for x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Solaris for x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| SAS System | SAS Time Series Studio | Microsoft® Windows® for x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 14.3 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 R2 | 14.3 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 for x64 | 14.3 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 Datacenter | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 14.3 | 15.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 7.1 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 R2 | 7.1 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 for x64 | 7.1 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 Datacenter | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 7.1 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 7.15 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 R2 | 7.15 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 for x64 | 7.15 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 Datacenter | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
A fix for this issue for SAS Visual Analytics Add-In for Office 8.0 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D5U.html#63380A fix for this issue for SAS Enterprise Guide 7.15 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B4N.html#63380A fix for this issue for SAS Add-in for Microsoft Office 7.15 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B4P.html#63380A fix for this issue for SAS Enterprise Guide 7.13 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A3V.html#63380| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2019-01-15 13:56:15 |
| Date Created: | 2018-12-13 14:25:34 |