Problem Note 63374: “FATAL…Schema update failed…" occurs and the SAS® Model Implementation Platform middle tier server does not start when you use an Oracle database
 |  |  |  |  |
In SAS Model Implementation Platform, the middle tier server does not start. This problem occurs when you use Oracle as the SAS Model Implementation Platform database. When you encounter this issue, the middle tier server logs contain messages that are similar to the following:
FATAL com.sas.risk.common.schema.SchemaDbHelper - Schema update failed, rolling back
WARN org.springframework.web.context.support.XmlWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'modImpDataSourceProvider': Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
WARN com.sas.services.session.SessionContext - Forced destruction of the session context by the Session Service. Session Context=30aa11dae8c96edd:6a99ea95:1672d62f18b:-7060
ERROR org.springframework.web.context.ContextLoader - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'modImpDataSourceProvider': Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
…more log messages…
WARN org.springframework.web.context.support.XmlWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'modImpDataSourceProvider': Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
WARN com.sas.services.session.SessionContext - Forced destruction of the session context by the Session Service. Session Context=30aa11dae8c96edd:6a99ea95:1672d62f18b:-7060
ERROR org.springframework.web.context.ContextLoader - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'modImpDataSourceProvider': Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
…more log messages…
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 Model Implementation Platform | Microsoft® Windows® for x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 |
| Microsoft Windows 8 Enterprise 32-bit | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro 32-bit | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro 32-bit | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows 10 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 R2 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 for x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Datacenter | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Std | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Std | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2016 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Windows 7 Enterprise 32 bit | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Windows 7 Enterprise x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Windows 7 Home Premium 32 bit | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Windows 7 Home Premium x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Windows 7 Professional 32 bit | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Windows 7 Professional x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Windows 7 Ultimate 32 bit | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Windows 7 Ultimate x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Linux for x64 | 3.1 | 3.2 | 9.4 TS1M5 | 9.4 TS1M5 | ||
A fix for this issue for SAS Model Implementation Platform 3.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C9P.html#63374
The SAS Model Implementation Platform middle tier server does not start when you use an Oracle database and generates “FATAL com.sas.risk.common.schema.SchemaDbHelper - Schema update failed, rolling back…” in the middle tier log file.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-12-12 14:35:37 |
| Date Created: | 2018-12-12 11:50:54 |