OFSAA AAI 8.1.1.3.0 Has Error On DIM_RUN_SEQUENCE
(Doc ID 2871624.1)
Last updated on JUNE 27, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.1.1 and laterInformation in this document applies to any platform.
Symptoms
Installation completed successfully, however the following error is in the OFSAAIUpdate.log file:
Log [2022-05-18 10:24:09.833] [OFSAAIUPDATE] [DEBUG] - dir-/app/fccm/downloads/AAI-8.1.1.3.0_tfccmap1/OFS_AAI/../schema_creator
Log [2022-05-18 10:24:09.834] [OFSAAIUPDATE] [DEBUG] - Updating the Config Schema
Log [2022-05-18 10:24:10.314] [OFSAAIUPDATE] [DEBUG] - Executing script config_8.1.1.3.0.sql on config schema
Log [2022-05-18 10:25:43.548] [OFSAAIUPDATE] [ERROR] - Exception while executing the query - BEGIN
FOR cur_rec IN ( select DBUSERID from db_master where DBCATEGORY='APP' and DBTYPE='ORACLE')
LOOP
EXECUTE IMMEDIATE 'grant select on DIM_RUN_SEQUENCE to ' || cur_rec.DBUSERID;
END LOOP;
END;
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
ORA-06512: at line 4
ORA-06512: at line 4
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
Changes
N/A
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |