Problem Note 66679: You cannot preview an export in SAS® Customer Intelligence
 |  |  |  |  |
When you preview an export in SAS Customer Intelligence, the following error is displayed:
Could not run the generated query.
In addition, the following error is generated in the SASCustIntelCore log:
2020-09-04 10:45:48,093 ERROR [tomcat-http--144] [5091760866fca166:-1dd66f75:1745965d2ad:-b4b] [John Smith] mon.tableviewer.RemoteTableViewerService - Error querying table: SASMA - MCYMATables - EXP_24800002HGGH5D04YVENT2YR
com.sas.services.connection.platform.MissingIdentityException: The user "John Smith" could not log on to the server "SASMA - Logical Workspace Server". No valid identity could be found for the authentication domain "DefaultAuth".
at com.sas.services.connection.platform.PlatformConnectionFactory.getConnectionHost(PlatformConnectionFactory.java:495)
at com.sas.services.connection.platform.PlatformConnectionFactory.getConnection(PlatformConnectionFactory.java:111)
at com.sas.services.connection.platform.PlatformConnectionFactory.getConnection(PlatformConnectionFactory.java:93)
at com.sas.ci.services.common.tableviewer.RemoteTableViewerService.getLogicalServerConnection(RemoteTableViewerService.java:1016)
com.sas.services.connection.platform.MissingIdentityException: The user "John Smith" could not log on to the server "SASMA - Logical Workspace Server". No valid identity could be found for the authentication domain "DefaultAuth".
at com.sas.services.connection.platform.PlatformConnectionFactory.getConnectionHost(PlatformConnectionFactory.java:495)
at com.sas.services.connection.platform.PlatformConnectionFactory.getConnection(PlatformConnectionFactory.java:111)
at com.sas.services.connection.platform.PlatformConnectionFactory.getConnection(PlatformConnectionFactory.java:93)
at com.sas.ci.services.common.tableviewer.RemoteTableViewerService.getLogicalServerConnection(RemoteTableViewerService.java:1016)
The issue occurs because SAS® Customer Intelligence Studio uses a workspace server first, before searching for pooled workspace servers, when it queries the preview export table. The workspace server is found, but it cannot be used because authentication is not set for the user on the server.
To work around this problem, enable token authentication on the workspace server or make the user available for authentication on the server.
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 Marketing Automation | Linux for x64 | 6.6 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 6.6 | 9.4 TS1M6 | ||||
| 64-bit Enabled AIX | 6.6 | 9.4 TS1M6 | ||||
| Microsoft® Windows® for x64 | 6.6 | 9.4 TS1M6 | ||||
A fix for this issue for SAS Marketing Automation 6.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H8P.html#66679| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2020-12-23 13:48:11 |
| Date Created: | 2020-09-22 15:14:38 |