SUPPORT / SAMPLES & SAS NOTES
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | |||