My Oracle Support Banner

Can ORA-00942: table or view does not exist Errors Be Ignored Running OFSAA 8 Schema Creator for Linux 7 (Doc ID 2725513.1)

Last updated on NOVEMBER 05, 2020

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Red Hat Enterprise Linux Workstation
Linux x86-64
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)
Red Hat Linux (RHEL) 7

Goal

Can the following errors be ignored when running schema creator in OFSAA 8.0.0.0 after applying <Patch 22930093> SCHEMA CREATION FAILING ON OEL 7?

[Wed 14/10/2020 11:15:47] [SCHEMAUTILITY] [ INFO] - Grants creation scripts execution started...
[Wed 14/10/2020 11:15:47] [SCHEMAUTILITY] [ERROR] - Error while executing - grant olap_user to config
java.sql.SQLSyntaxErrorException: ORA-01919: role 'OLAP_USER' does not exist

[Wed 14/10/2020 11:16:09] [SCHEMAUTILITY] [ERROR] - Error while executing - INSERT INTO aai_db_detail (V_DB_SERVER,V_DB_NAME,V_DB_TYPE,V_SCHEMA_NAME,V_DB_SEEDED_BY,V_CREATED_BY,D_CREATED_DATE,F_IS_DELETED) VALUES ('<server_name>', '<schema_name>', 'ORACLE', '<user_name>', 'SYSADMN','SYSADMN', SYSDATE, 'N')
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

[Wed 14/10/2020 11:16:09] [SCHEMAUTILITY] [ERROR] - Error while executing - INSERT INTO AAI_DB_PROPERTY (V_DB_SERVER,V_DB_NAME,V_DB_TYPE,V_PROPERTY_NAME,V_PROPERTY_VALUE) VALUES ('<server_name>', '<schema_name>', 'ORACLE', 'AUTH_TYPE','DEFAULT')
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

[Wed 14/10/2020 11:16:09] [SCHEMAUTILITY] [ERROR] - Error while executing - INSERT INTO aai_db_auth_alias (V_AUTH_ALIAS,V_AUTH_USERNAME,V_AUTH_STRING) VALUES ('<alias_name>', '<schema_name>', '<encrypted password>')
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.