Problem Note 58358: Reloading a table created by a SAS® Visual Data Builder query in SAS® Visual Analytics Administrator fails
 |  |  |  |  |
If the SAS® Visual Analytics middle tier uses an external reverse proxy, and the external connection URL is not accessible from the mid-tier system, reloading tables in SAS Visual Analytics Administrator that were created by SAS Visual Data Builder queries will fail.
SAS Visual Analytics Administrator displays an error with the following message:
The application could not retrieve the properties for the selected object.
Clicking the Show Details button in the error dialog box displays the following exception:
I/O error: Connection refused; nested exception is java.net.ConnectException: Connection refused org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:453) org.springframework.web.client.RestTemplate.execute(RestTemplate.java:401) org.springframework.web.client.RestTemplate.exchange(RestTemplate.java:377) com.sas.bicommon.admin.services.server.components.QueryServiceUtil.getRequestEntity(QueryServiceUtil.java:145) com.sas.bicommon.admin.services.server.components.QueryServiceUtil.getVdbCode(QueryServiceUtil.java:170) com.sas.bicommon.admin.services.server.dao.VAAdministratorDAO.getVdbCode(VAAdministratorDAO.java:7732) com.sas.bicommon.admin.services.server.dao.VAAdministratorDAO.getJobByTable(VAAdministratorDAO.java:1383) com.sas.bicommon.admin.services.server.impl.VAAdministratorService.getJobByTable(VAAdministratorService.java:338)
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 Visual Analytics | Linux for x64 | 7.3 | 7.4 | 9.4 TS1M3 | 9.4 TS1M4 |
| Microsoft® Windows® for x64 | 7.3 | 7.4 | 9.4 TS1M3 | 9.4 TS1M4 | ||
A fix for this issue for SAS Visual Analytics 7.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V90.html#58358
In environments where the external connection URL is inaccessible from the SAS® Visual Analytics middle tier, reloading tables created by SAS Visual Data Builder queries fails.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-01-31 12:11:09 |
| Date Created: | 2016-06-08 09:43:19 |