Object Registration Queries Not Executed During Data Model Upload Process (Doc ID 1344781.1)

Last updated on AUGUST 10, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) infrastructure, when you run a model upload, the upload fails during object registration.  The following message is at the end of the Model Upload log:

----------------------------------------------
OBJECT REGISTRATION STARTED AS PART OF MODEL UPLOAD AT Mon Aug 01 17:18:35 GST 2011
----------------------------------------------
objectRegReqFlag..falseObject registration queries not executed,only the old object registration entries are deleted(If any). Object Registration not Done

The SMSService.log in $FIC_APP_HOME/common/FICServer/logs shows errors indicating a privileges issue on the DATA_TS tablespace:

[UMMLOG] Jul 31,11 14:14:43 : [DACDATABASEGATEWAY]Executing normal Update Query : [ Insert into REV_COLUMN_REQUIREMENTS(COLUMN_NAME,REV_DATA_TYPE_CD,DATA_LENGTH,DATA_PRECISION,DATA_SCALE,DATA_TYPE,NULLABLE,DBF_NAME,PROTECTED_FLG) values ('TOTAL_FEES',1,22,14,2,'NUMBER','Y','TOTALFEES',1)
] On URL: jdbc:oracle:thin:@xxx.xx.xxx.xxx:1521:ofsaa Driver: oracle.jdbc.driver.OracleDriver
[UMMLOG] Jul 31,11 14:14:43 : [DACDATABASEGATEWAY]Failed Executing Queryjava.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'DATA_TS'

The are additional errors on other REV_ objects like REV_PROPERTY_COLUMNS, REV_COLUMN_PROPERTY_CD, REV_COLUMN_PROPERTY_MLS, etc.

The issue prevents you from registering any tables for use in OFSAA.

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