Problem Note 67478: SAS® Customer Intelligence Studio 6.6 fails to start or fails to respond after you apply a maintenance update
 |  |  |  |  |
Some maintenance updates to SAS® 9.4 do not include an upgrade to SAS Customer Intelligence Studio 6.6. When you apply a maintenance update that does not update SAS Customer Intelligence Studio, SAS Customer Intelligence Studio might fail to start or it fails to respond if it does start. When this problem occurs, SAS Customer Intelligence Studio returns the following error message:
...com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool...
Caused by: com.atomikos.datasource.pool.CreateConnectionException: Could not create JDBC connection
. . .more message lines. . .
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "ciservicesdbuser"
Caused by: com.atomikos.datasource.pool.CreateConnectionException: Could not create JDBC connection
. . .more message lines. . .
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "ciservicesdbuser"
The underlying problem is that the update causes an incorrect change to the ci_services 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.6 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise 32-bit | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows 8 Enterprise x64 | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows 8 Pro 32-bit | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows 8 Pro x64 | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Pro x64 | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows 10 | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2008 | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2008 R2 | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2008 for x64 | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 Datacenter | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 R2 Std | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 Std | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2016 | 6.6 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2019 | 6.6 | 9.4 TS1M6 | ||||
| Windows 7 Enterprise 32 bit | 6.6 | 9.4 TS1M6 | ||||
| Windows 7 Enterprise x64 | 6.6 | 9.4 TS1M6 | ||||
| Windows 7 Home Premium 32 bit | 6.6 | 9.4 TS1M6 | ||||
| Windows 7 Home Premium x64 | 6.6 | 9.4 TS1M6 | ||||
| Windows 7 Professional 32 bit | 6.6 | 9.4 TS1M6 | ||||
| Windows 7 Professional x64 | 6.6 | 9.4 TS1M6 | ||||
| Windows 7 Ultimate 32 bit | 6.6 | 9.4 TS1M6 | ||||
| Windows 7 Ultimate x64 | 6.6 | 9.4 TS1M6 | ||||
| 64-bit Enabled AIX | 6.6 | 9.4 TS1M6 | ||||
| 64-bit Enabled Solaris | 6.6 | 9.4 TS1M6 | ||||
| HP-UX IPF | 6.6 | 9.4 TS1M6 | ||||
| Linux for x64 | 6.6 | 9.4 TS1M6 | ||||
| Solaris for x64 | 6.6 | 9.4 TS1M6 | ||||
| SAS System | SAS Marketing Automation | Microsoft® Windows® for x64 | 6.6 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 6.6 | 9.4 TS1M6 | ||||
| 64-bit Enabled Solaris | 6.6 | 9.4 TS1M6 | ||||
| Linux for x64 | 6.6 | 9.4 TS1M6 | ||||
| SAS System | SAS Marketing Optimization | Microsoft® Windows® for x64 | 6.6 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 6.6 | 9.4 TS1M6 | ||||
| 64-bit Enabled Solaris | 6.6 | 9.4 TS1M6 | ||||
| Linux for x64 | 6.6 | 9.4 TS1M6 | ||||
| SAS System | SAS Real-Time Decision Manager | Microsoft® Windows® for x64 | 6.6 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 6.6 | 9.4 TS1M6 | ||||
| 64-bit Enabled Solaris | 6.6 | 9.4 TS1M6 | ||||
| Linux 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#67478A fix for this issue for SAS Marketing Optimization 6.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H8Q.html#67478
When you apply a maintenance upgrade to SAS® 9.4 that does not cause an upgrade to SAS® Marketing Automation, SAS Customer Intelligence Studio 6.6 fails to start or fails to respond if it does start.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-03-31 09:41:52 |
| Date Created: | 2021-02-23 08:44:22 |