Problem Note 57166: An error occurs when you create custom detail tags in SAS® Customer Intelligence Studio
SAS Customer Intelligence Studio displays the following error when you create a custom detail tag and when Oracle is the database on which the SAS® Content Server is deployed:
An error has occurred. See the log files on node SASServer6_x.
In addition, the SASCustIntel6.4.log file contains an error similar to the following:
2015-11-12 12:42:46,920 ERROR [tomcat-http--328] [761a3122ec89f91f:4074b856:150f97e13a8:-5217] [user-ID] com.sas.analytics.crm.util.SystemCheck - Error saving field info tag for session: 761a3122ec89f91f:4074b856:150f97e13a8:-5217 com.sas.svcs.exceptions.MutatedException: (org.springframework.jdbc.UncategorizedSQLException) Error setting null for parameter #1 with JdbcType OTHER. Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: 1111; uncategorized SQLException for SQL []; SQL state [99999]; error code [17004]; Invalid column type: 1111; nested exception is java.sql.SQLException: Invalid column type: 1111
To work around this issue, deploy your SAS® Content Server by using the default Postgres database.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Customer Intelligence Studio | Microsoft® Windows® for x64 | 6.4 | 6.5 | | 9.4 TS1M3 |
64-bit Enabled AIX | 6.4 | 6.5 | | 9.4 TS1M3 |
64-bit Enabled Solaris | 6.4 | 6.5 | | 9.4 TS1M3 |
HP-UX IPF | 6.4 | 6.5 | | 9.4 TS1M3 |
Linux for x64 | 6.4 | 6.5 | | 9.4 TS1M3 |
Solaris for x64 | 6.4 | 6.5 | | 9.4 TS1M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2017-06-02 10:14:46 |
Date Created: | 2015-12-02 10:35:07 |