Model Upload Fails at Object Registration with ORA-00028 & ORA-02291 Errors

(Doc ID 2339712.1)

Last updated on JANUARY 11, 2018

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Data Foundation (OFSDF)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Data Model

Symptoms

User Interface (UI) launched Model Upload failed at object registration step.

See below errors from SMSService.log and ETLService.log from ficapp/common/ficserver/logs folder.

ERRORS

OBJECT REGISTRATION STARTED AS PART OF MODEL UPLOAD
----------------------------------------------
Error while executing the query Failed Executing Batch: error occurred during batching: ORA-00028: your session has been killed
ORA-00028: your session has been killed

Error while executing the query Failed Executing Batch: error occurred during batching: ORA-02291: integrity constraint (DEV_FSDFATM.FK_REV_TAB_INDEXES) violated - parent key not found

Error- Error during batch execution of rollback script for object registration
Object Registration Failed.
Object Registration Failed.
java.lang.Exception: Error while Executing queries for Object Registration
OBJECT REGISTRATION COMPLETED


Changes

According to error ORA-00028, customer session has been killed.
The model upload was successful but object registration failed.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms