When executed in the SAS® Add-In for Microsoft Office, a stored process might not produce output even though it seems to execute


If you attempt to run a stored process using the SAS Add-In for Microsoft Office, you might not see any results even though the stored process seems to execute. When this problem occurs, enable logging for the SAS add-in to verify any error message. To turn on logging for the SAS add-in, see SAS KB0036497.

After logging is enabled, run your stored process again. Navigate to the log file in your file system, and search the log for error messages that are similar to the following:

System.Net.WebException: The remote server returned an error: (401) Unauthorized.

at System.Net.HttpWebRequest.GetResponse()

at SAS.EC.SASWebExtensions.VisualAnalyticsTransport.TransportServiceAPI.<>c__DisplayClass1.<MakeHttpWebRequest>b__0()

at SAS.EC.SASWebExtensions.X509CertificateHelper.SetupCertificates(Object service, Action workMethod)

Typically, you see this message if the connection information specified for SAS® Visual Analytics Transport Service is incorrect. If the information is not correct, then the stored process is unable to display any output in the Microsoft Office client.

How can you tell where your SAS Visual Analytics Transport Service is connecting

You can check the internal and external connections for all of your services by running the code listed on the Full Code tab. Before submitting the code, modify the Options statement at the top of the code for your site-specific information. The results list out the port, host, and service name. Use this information to verify that the protocol, host name, and port are specified correctly for SAS Visual Analytics Transport Service.

You can also use SAS® Management Console to verify your SAS Visual Analytics Transport Service connection information.

  1. On the Plug-ins tab, select Application Management ► Configuration Manager ► SAS Application Infrastructure ► Visual Analytics 7.3 ► Visual Analytics Services 7.3.
  2. Right-click Visual Analytics Transport Service 7.3 and select Properties.
  3. Verify the information on both the Internal Connection and the External Connection tabs. In particular, verify the Host Name and Port Number. You can compare these properties in the Visual Analytics Transport Service with other services to see whether the Host Name and Port Number are different.

How to fix your SAS Visual Analytics Transport Service connection

If the Visual Analytics Transport Service is pointing to an incorrect host, you need to correct that information in order to see stored process results. You can modify the information in SAS Management Console.

  1. On the Plug-ins tab, select Application Management ► Configuration Manager ► SAS Application Infrastructure ► Visual Analytics 7.3 ► Visual Analytics Services 7.3.
  2. Right-click Visual Analytics Transport Service 7.3 and select Properties.
  3. Make the necessary changes on both the Internal Connection and the External Connection tabs. This includes the communication protocol, host name, and port number. The Service should be set to /SASVisualAnalyticsTransport.
  4. Click OK to save your changes and close the dialog box.
  5. To enforce the changes, restart the SAS® Web Application server and the Microsoft Office application.