My Oracle Support Banner

OFSAA - Application Is Not Getting Started Post DGS 808 Installation (Doc ID 2668592.1)

Last updated on MAY 19, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.9 and later
Information in this document applies to any platform.

Symptoms

On : OFSAAI 8.0.9 version, Installed DGS 8.0.8

When attempting to login to application after applying DGS.
the following error occurs in SMSService.log

ERROR
-----------------------
[DEBUG] [APP] [SMS] [NA] [DACDATABASEGATEWAY] Trial reinitialization connection and query execution
[DEBUG] [APP] [SMS] [NA] [DACCONNECTIONPROVIDER] Connection Type getting used ->
[DEBUG] [APP] [SMS] [NA] [DACCONNECTIONPROVIDER] Apache Connection
 [DEBUG] [APP] [SMS] [NA] [DACDATABASEGATEWAY] Failed Executing 2nd time normal Select Query : [SELECT DER_ENT.*, SD.LOCALE_DESCRIPTION AS SHORT_DESC, LD.LOCALE_DESCRIPTION AS LONG_DESC, CM.METADATA_COMMENT AS COMMENTS FROM VIEW_DERIVED_ENTITY_TPOSE DER_ENT JOIN METADATA_LOCALE_MASTER SD ON UPPER(SD.METADATA_LOCALE) = UPPER(?) AND DER_ENT.SHORT_DESC_KEY = SD.METADATA_KEY AND DER_ENT.DSN_ID = SD.METADATA_INFODOM LEFT OUTER JOIN METADATA_LOCALE_MASTER LD ON UPPER(LD.METADATA_LOCALE) = UPPER(?) AND DER_ENT.LONG_DESC_KEY = LD.METADATA_KEY AND DER_ENT.DSN_ID = LD.METADATA_INFODOM LEFT OUTER JOIN METADATA_COMMENT_MASTER CM ON DER_ENT.DSN_ID = CM.METADATA_INFODOM AND DER_ENT.DER_ENT_CODE = CM.METADATA_CODE AND DER_ENT.DER_ENT_VERSION = CM.METADATA_VERSION WHERE DER_ENT.DER_ENT_CODE LIKE ? AND DER_ENT.DER_ENT_VERSION = ? AND DER_ENT.DSN_ID = ? AND DER_ENT.IS_DELETED = ? AND ROWNUM <= ?] [On URL: jdbc:xxxxxxxxxxxxxxx_batch] [Driver: oracle.jdbc.driver.OracleDriver] [Metadata Required : false]
[ERROR] [APP] [SMS] [NA] [DACDATABASEGATEWAY]
java.sql.SQLException: ORA-04063: view "<config>.VIEW_DERIVED_ENTITY_TPOSE" has errors

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)



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
Cause
Solution


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