Problem Note 64109: The SAS® Risk and Finance Workbench web application fails to start during an Oracle 11 deployment
 |  |  |  |  |
During an Oracle 11 deployment, the SAS Risk and Finance Workbench web application fails to start. When this issue occurs, the middle-tier log includes an exception like the following:
INFO com.sas.risk.common.schema.SqlBatchStatementExecutor - Executing: create index
data_point_key_period_id_ix on data_point_value (data_point_key, period_id)
INFO com.sas.risk.common.schema.SqlBatchStatementExecutor - Executing: BEGIN
execute immediate 'ALTER TABLE data_point_value ADD (data_point_sk NUMBER
GENERATED ALWAYS as IDENTITY(START with 1 INCREMENT by 1))';
data_point_key_period_id_ix on data_point_value (data_point_key, period_id)
INFO com.sas.risk.common.schema.SqlBatchStatementExecutor - Executing: BEGIN
execute immediate 'ALTER TABLE data_point_value ADD (data_point_sk NUMBER
GENERATED ALWAYS as IDENTITY(START with 1 INCREMENT by 1))';
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 'schemaManager': Invocation of init method failed; nested exception is
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-02000:
missing ( keyword ORA-06512: at line 8
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 'schemaManager': Invocation of init method failed; nested exception is
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-02000:
missing ( keyword ORA-06512: at line 8
WARN com.sas.services.session.SessionContext - Forced destruction of the session
context by the Session Service. Session Context=3124f17fe6a16aeb:5d4364a6:161e6a71b6e:-707b
ERROR org.springframework.web.context.ContextLoader - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'schemaManager': Invocation of init method failed; nested exception is
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-02000:
missing ( keyword ORA-06512: at line 8
context by the Session Service. Session Context=3124f17fe6a16aeb:5d4364a6:161e6a71b6e:-707b
ERROR org.springframework.web.context.ContextLoader - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'schemaManager': Invocation of init method failed; nested exception is
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-02000:
missing ( keyword ORA-06512: at line 8
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 Risk and Finance Workbench | Microsoft® Windows® for x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 |
| Linux for x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
A fix for this issue for SAS Risk and Finance Workbench 3.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C5N.html#64109A fix for this issue for SAS Risk and Finance Workbench 2.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A4G.html#64109| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis |
| Date Modified: | 2019-06-28 10:08:10 |
| Date Created: | 2019-04-25 16:42:44 |