OFSAA 8.1.1.1 Object Registration Fails With "There is a space in the Table name" Error (Doc ID 2863766.1)

Last updated on JULY 26, 2023

Applies to:

Symptoms

OFSAA 8.1.1.1.0 Object registration(which is part of Model upload process) fails because the table name is not correctly registered but Model Upload completes successfully.

In the model upload log: OFSAEPM_LOG_XX_xxxx.log following can be seen:

ERROR:

----------------------------------------------
JSON MODEL UPLOAD STARTED AT Tue Jan 04 11:12:26 EET 2022
----------------------------------------------
.................
----------------------------------------------
fsi_prod_code_std_prod_ty_hist

 There is a space in the Table name .....XX_FSI_ILOP Product_CD

----------------------------------------------

.........
.........

MODEL ALTERED SUCCESSFULLY

----------------------------------------------
JSON MODEL UPLOAD COMPLETED AT Tue Jan 04 11:13:11 EET 2022
----------------------------------------------Ended Model Upload using JSON :Tue Jan 04 11:13:11 EET 2022
Modelupload status..0
Triggering Object Registration as part of Json Model Upload ...
----------------------------------------------------------------------------
OBJECT REGISTRATION STARTED AS PART OF JSON MODEL UPLOAD AT :: Tue Jan 04 11:13:14 EET 2022
----------------------------------------------------------------------------
------------------------------------------------------------
Object Registration DML Script creation started at ::Tue Jan 04 11:13:14 EET 2022
-----------------------------------------------------------Object Registration Failed.

java.lang.NullPointerException
--------------------------------------------------------------
OBJECT REGISTRATION COMPLETED AT Tue Jan 04 11:13:21 EET 2022
------------------------------------------------------------

>>> At this point Model upload should have failed, but instead only Object registration fails.

After correcting the name of the table in the Erwin file, another XML was generated and a new model upload was performed with this new XML.
This time the DMU failed with the following error:

----------------------------------------------
XX_FSI_ILOP PRODUCT_CD.

This table XX_FSI_ILOP PRODUCT_CD has been deleted in the new database model.
Error is......ORA-00942: table or view does not exist
Error while querying the database for the number of records in the table
XX_FSI_ILOP PRODUCT_CD.

This table FSI_D_LOAN_TXN_OLD has data in it and hence cannot be dropped.

----------------------------------------------

>>> Ideally after this step model upload process should complete successfully but instead it fails.

Changes

Cause

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